If you are unable to create a new account, please email bspsoftware@techdata.com

Author Topic: Cognos Cube Designer 10.2.2 Custom Relative Time Members  (Read 4072 times)

Offline GeethaKL

  • Community Leader
  • *****
  • Join Date: Apr 2015
  • Posts: 86
  • Forum Citizenship: +1/-0
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

Offline GeethaKL

  • Community Leader
  • *****
  • Join Date: Apr 2015
  • Posts: 86
  • Forum Citizenship: +1/-0
Re: Cognos Cube Designer 10.2.2 Custom Relative Time Members
« Reply #1 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