Print Page - Cognos Cube Designer 10.2.2

Title: Cognos Cube Designer 10.2.2
Post by: GeethaKL on 10 Jun 2019 06:42:26 PM

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

Title: Re: Cognos Cube Designer 10.2.2
Post by: GeethaKL on 11 Jun 2019 06:40:42 PM

hello all,

Can anyone guide me in achieving the above requirement?

Thanks in advance

Regards
Geetha

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: GeethaKL on 10 Jun 2019 06:42:26 PM