Forum Discussion

CCI01's avatar
CCI01
New Contributor
3 years ago

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.

My change parameter is setup to change the POV. 

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.

  • PeterFu's avatar
    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.

     

    Peter

  • Krishna's avatar
    Krishna
    Valued Contributor

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