COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Dynamic Cubes => Topic started by: GeethaKL on 19 Mar 2018 06:35:45 PM

Title: Cognos Cube Designer 10.2.2 Custom Relative Time Members
Post by: GeethaKL on 19 Mar 2018 06:35:45 PM
Hi All,
I have created N custom N-Period Running Total Definitions for 2019 and 2020 as
I will get
1. 2019 total if I drag 2019
2. 2019+2020(Cumulative) if i drag 2020.

Its all good so far..

But when I drag individual members for 2019(ie either March 2019 or Sep 2019), i am not getting cumulative total up to Sep 2019.
Can someone advise what am I missing here?

I am expecting the months in the running total Year 2019 should also be cumulative.. How to achieve this?

Thank you

Regards
geetha
Title: Re: Cognos Cube Designer 10.2.2 Custom Relative Time Members
Post by: GeethaKL on 20 Mar 2018 07:09:43 PM
Hi All,
I just want to know whether the 10.2.2 functionality supports to get cumulative count of children or individual members(months) of

cumulative Years
2018 = 2018
2019 = 2018+2019
2020 = 2018+2019+2020

Cumulative Years(Children or individual members)
2018
Jan = Jan
Feb = Jan +Feb
MAr= JAn +Feb+Mar 
and so on

2019
Jan = Jan
Feb = Jan +Feb
MAr= JAn +Feb+Mar 
and so on

Please avise

Regards
geetha