Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Transformer => Topic started by: keerthikarri on 26 Apr 2013 02:20:21 AM

Title: How to Get Cumulative Counts using Special Categories
Post by: keerthikarri on 26 Apr 2013 02:20:21 AM
Is there a way to create cumulative count in cubes???For ex if data is like,
Mnth    Count
Jan                           1
Feb                           2
Mar                           3

The cube should provide me the data like
Mnth                           Count                           Cum.Count     
Jan                           1                              1
Feb                           2                              3
Mar                           3                              6

Is there a way to achieve this in the cubes??
I have read somewhere that this can be achieved using special categories in transformer??If so,please help me in achieving it.

Thanks in advance...

Title: Re: How to Get Cumulative Counts using Special Categories
Post by: jaganlalrm on 23 May 2013 04:47:40 AM
Try to Create Running total in Cube for Cumulative Count. Like that only i have count in Report Studio.

You help me How to Create Cube. In which i can create  Cube Transformer or Powerplay.

Thanks in Advance
Text only | Text with Images