0

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

null
    • imbarmarinescubar_pyram
    • 12 days ago
    • Reported - view

    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.

Content aside

  • Status Answered
  • 12 days agoLast active
  • 1Replies
  • 16Views
  • 2 Following