Cognos Cube Designer 10.2.2

[GeethaKL]

Hello All,

I have a requirement for the users to build a report  from the Cognos Dynamic Cube built of Cube Designer to display two graphs
1.  one Graph with Last 3 Financial Years on Categories  and multiple measures on Series
2. the other with Forecast 5 Calendar Years on Categories and multiple measures on Series.

I understand if it is a Relational Package , we can make use of _add_years and calculate last 3 Financial years and forecast years.
In MDX, I am bit unsure of this calculation in Report Studio.
Can anyone advise on how to calculate Last 3 Financial Years and Forecast years dynamically in Cognos Report Studio ?

Thanks in advance

Regards
Geetha

[GeethaKL]

hello all,

Can anyone guide me in achieving the above requirement?

Thanks in advance

Regards
Geetha