Hi Gurus,
Using Dynamic cubes as source, working on building Cognos dashboard. I have Date hierarchy with relative time periods. I would like to give user an option of selecting both regular time periods and relative time periods in tree prompt. I am able to set Current Year(Relative time category) as default value, But for users to select another relative time category, relative times are showing part of Tree prompt.
I am using rootMembers([Depletion Actuals].[Depletion Period].[Period Hierarchy]) as source to populate Tree prompt.
Attaching Date hierarchy showing members.
Please suggest me how to show relative categories in tree prompt using Dynamic cube as source.
Thanks,
Mpotla.
Thanks Gurus.
I have work around to the requirement. By adding three data items .
Data Item #1: Added data item [Period Year Level] with below expression, which shows Year level.
[Depletion Actuals].[Depletion Period].[Period Hierarchy].[Period Year]
Data Item #2: Added Data item [Relative Periods] with set of all relative categories MUNs.
set(
[Depletion Actuals].[Depletion Period].[Period Hierarchy].[Period Year]->:[RO].[Depletion Period].[Period Hierarchy].[All Years].[_Current_Period Year],
[Depletion Actuals].[Depletion Period].[Period Hierarchy].[Period Year]->:[RO].[Depletion Period].[Period Hierarchy].[All Years].[_Prior_Period Year],
[Depletion Actuals].[Depletion Period].[Period Hierarchy].[Period Year]->:[RO].[Depletion Period].[Period Hierarchy].[All Years].[_Period Year_to_Date],
[Depletion Actuals].[Depletion Period].[Period Hierarchy].[Period Year]->:[RO].[Depletion Period].[Period Hierarchy].[All Years].[_Prior_Period Year_to_Date]
)
Data Item #3: Is the Union Data #1,Data Item#2.
union([Period Year Level],[Relative Periods])
Assign Data Item #3 as Use Value of the Tree Prompt.
Attached is the Screen of Tree Prompt after changes.
Thanks,
MPotla.