Skip to main content
Newcomer
Apr 15, 2022 6:32 PM UTC

Book to present P&L by location

This is my first time creating a book. I'm working on creating a book that presents an income statement by location. The ideal outcome is that the IS is displaying location at the top and each subsequent page displays a child location member. 

I have my loop setup as a member filter that references the location dimension as shown below.

CCI01_0-1650047310067.png

My change parameter is setup to change the POV. 

CCI01_0-1650047400940.png

When I preview the book it's still showing location at TOP for all the pages instead of showing TOP and then each location base member.

Any suggestions on how to fix this or any literature would be appreciated.

 

Thanks.

2 replies

Newcomer
Apr 16, 2022 9:40 AM UTC

Hi,

 

You are not mentioning what you use to show the Location currently. My guess is that your issue is related to what you use to show the Location (UD2) in the Cube View. Try to use |CVUD2Desc| (see print screen), that should give you the Location of each of the report.

 

PeterFu_0-1650101925636.png

Peter

Expert
Apr 26, 2022 2:52 AM UTC

You should use the Change Parameters and in report provide the report name, it should work.

KS_0-1650941430293.png

KS_1-1650941488181.png