Relative Time Values in Tree Prompt Using dynamic cube

[Mpotla]

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.

[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.