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

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

How to create a new Data Item to transform Fact Items into Level items?

Started by lookingforK, 08 Apr 2014 04:03:47 PM

Previous topic - Next topic

lookingforK

Hi,

I am using Cognos Report Studio 8.4.1 to create a List for a Pie chart.

There are 4 drivers for Sales, but the 4 drivers are defined as Fact (Measure) items in the Relational Package.

For example, I can get 2014 YTD Sales info like:
[YTD] ...... [Sales] ...... [Sales - Driver A] ...... [Sales - Driver B] ...... [Sales - Driver C] ...... [Sales - Driver D]
2014    2,137,110        24,999                    5,421                               14,608                    2,092,082

Here:
Sales = [Sales - Driver A] + [Sales - Driver B] + [Sales - Driver C] + [Sales - Driver D];
That is: 2,137,110 = 24,999 + 5,421 + 14,608 + 2,092,082

Now I want to create a List for building a Pie chart as follows
[Year] ...... [Sales Driver] ...... [Sales]
2014  ......  [Driver A]  .......     24,999
2014  ......  [Driver B]  .......     5,421
2014  ......  [Driver C]  .......     14,608
2014  ......  [Driver D]  .......     2,092,082

How can I transform Fact (Measure) items into Level items?  :o

Can I create a new Data item only for the above 4 Driver names? If I can, how?


Thank you in advance.