Skip to Content
0
Former Member
Apr 10, 2008 at 04:01 PM

Layout not retrieving the values correctly

9 Views

Hi,

As per the requirement I need to get the AOP values from the cube for a particular fiscal year to be populated into one of the columns of the Layout,but the planning layout which I had designed retrives the AOP values only for the first period.I should be getting the total AOP for the Fiscal year in my layout.

Say I have the cube values as

Product Fiscal year/Period Value

P-01 2006001 100

P-01 2006008 500

P-02 2006001 200

P-03 2006005 300

My layout retrieves the values as follows

P-01 2006001 100

P-02 2006001 200

but I need the Layout values as

P-01 600

P-02 200

P-03 300.

Could anyone tell me what modifications I need to do in my layout inorder to achieve the above functionality.

Points will be assigned.

Thanks,

Subha