1 Reply Latest reply: Apr 14, 2008 7:06 AM by Koundinya Karanam RSS

Want to see constant value of CPU not the aggregated one from the cube?

Indu Sharma
Currently Being Moderated

Hi All,

When I see my layout with fiscyear ,it shows the aggregated values for Quantity,Cost Per Unit,0Amount,which is distributed across period.

For example if one WBS and one uear(2008) -0Quantity(12),CPU(100) to four periods of one fiscyear.The distribution would be as shown below:- 

Period       0Quantity      CPU            0Amount

003.2008         3               100              300

004.2008         3               100              300

005.2008         3               100              300

0006.2008       3               100              300

 

Total               12               400            1200

So in my layout I'll be able to see :-

fiscyear        0Quantity           CPU         0Amount.

2008                12                  400            1200

 

 

So 12 * 400 <> 1200 which is logically incorrect.

 

Is there any way by which we can get the constant or average value of CPU from the cube???

 

Any help would be appreciated.

 

Rgds,

Indu