PeriodstoDate (MDX) for InMemory (PQL) List
Hello Community,
Is there any way to create a PeriodstoDate List for a InMemory Datamodell?
It seems that InMemory Modell List's work only with PQL Code (look pic.1)
pic.1
This function works perfectly fine if the Modell is a OLAP Cube (pic.2)
pic.2
We tried to replace the PTD with a MTD or YTD function, wich it seems to me im using wrong
even using one element from the Month hierarchie doesn't work for me
what am i doing wrong? The result of this list should be a list of all previous months till actual month
the second part of the code is a parameter containing the all element of the month level (wich is a 1:1 copy from parameter from pic.2)
1 reply
-
MTD expects 1 argument and returns the list of elements within the same month up to the selected value.
This will generally work only on the date level, since there are no other levels below month.
You can use the YTD or QTD functions on a selection from the month level which will return all the months from the start of the year or quarter up to the selected month.
see last example in this link--
In your last example, you can replace the MTD function with RANGE function (and keep the arguments as is). This will also return all the months within this range.