This would be beyond super helpful if I can get this!!!
In Framework I want: Current Period, Year to Date, Prior Year YTD, Quarter to Date, etc.. I want this to be in framework so our users can just drag and drop. How can I do this? we have a DMR.
When i try to use the same sort of formulas as I would to create these in report studio, it seems there is a problem with using the prompts, for example the current period.
Please Advise what the steps are to do this. thank you!
You may create aggregation table/viiew/queris for these items. We have no simple way to implement them in DMR.
By the way, functionalities such as YTD in OLAP is more easier than in DMR. The Cubes of OLAP are just for those reqirements.