Hi all,
I have a report built over a TM1 cube with a combined Year/Month dimension. In Cognos BI I then have a prompt for Month (called pPeriod) and a slicer with "[cubename].[Period].[Period] -> ?pMonth?" which the user selects a month from a Tree Prompt.
I want to then derive the year from this parameter and use it in a slicer in a different query in the report. Year is one level higher than month in the TM1 dimension. Can someone please tell me what the slicer would be to give this result?
Thanks heaps!
John
Hi John
Not sure if you've found a solution for your post yet, but for my TM1 based Report Studio reports, where I use a combined Year/Month dimension, the slicer I use for the "Year" is to simply wrap a parent function around the prompt, eg.
parent ( your prompt )
I don't use levels in my YearMonth dimension since mine is a ragged hierarchy as I have added lots of hierarchies to control things like YTD, Rolling12Mths, YTG, QTD etc etc, and it was simpler to avoid the levels. I've assumed per your post that you only have one hierarchy.
HTH
Ajay