Book to present P&L by location

CCI01
New Contributor

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 2

PeterFu
Contributor II

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

Krishna
Contributor III

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

KS_0-1650941430293.png

KS_1-1650941488181.png