Layout not retrieving the values correctly

[Former Member]

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

[Former Member · Accepted solution]

Hi Subha,

Try using Fiscal Year/Period instead of Fiscal Year & Posting Period.

Regards

Srinivas

[Former Member]

Hi Mayank,

I have not restricted to 2006001,but in the layout I have posting period as an variable which contains 1 to 13 periods as the variable definition.I need this becoz I need to generate period1 to period 13 columns dynamically in the same layout.

As you said If I remove the Posting period then how will I be able to genearte the columns dynamically.

Thanks,

Subha

[Former Member]

Hi Mayank,

I have not restricted to 2006001,but in the layout I have posting period as an variable which contains 1 to 13 periods as the variable definition.I need this becoz I need to generate period1 to period 13 columns dynamically in the same layout.

As you said If I remove the Posting period then how will I be able to genearte the columns dynamically.

Thanks,

Subha

Edited by: subhashini reddy on Apr 10, 2008 9:33 PM

[Former Member]

Your layout (is it an input-ready query?) seems to be restricted only to the value 200601. Please check.

The output you want does not have fiscper - To achieve that you can simply remove fiscper from the underlying level and the values with automatically aggregate.