Hi all,
I have a crosstab report over a TM1 cube. In it is a single continuous time dimension, with a Year level. I need to set up a prompt for the year required (done and called pYear). Then I need to display the periods that are children of the selected year. I thought I could use some MDX like children(pYear), however that doesn't work. Can anyone please point me in the right direction?
Thanks
John
Quote from: jv_oz on 23 Sep 2015 01:09:11 AM
Hi all,
I have a crosstab report over a TM1 cube. In it is a single continuous time dimension, with a Year level. I need to set up a prompt for the year required (done and called pYear). Then I need to display the periods that are children of the selected year. I thought I could use some MDX like children(pYear), however that doesn't work. Can anyone please point me in the right direction?
Thanks
John
Hi,
How have you defined your prompt to operate on the data? Did you use a detail filter? If so, then you're in for some trouble, as these are a relational reporting concept and not something you should use with a dimensional source.
To display the children of a prompted-for year member, try the following approach:
1. Delete the detail filter underpinning your prompt (if it exists).
2. Add a Query Calculation to your crosstab. Set the type to be "Other expression", give it a name, and code the expression as children([Year level from your TM1 cube] -> ?pYear?)
Cheers!
MF.
Thanks mate! I'll give it a go. Cheers, John