Displaying Children of a Prompted Value

[jv_oz]

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

[MFGF]

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.

[jv_oz]

Thanks mate!  I'll give it a go.  Cheers, John