Skip to Content

How to turn off column expansion in EPM for BPC 10 MS

Have anyone come across a solution on how to turn off expansion in EPM on columns or rows? I will start digging a bit more as well.

Thanks

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on May 03, 2012 at 01:36 PM

    Hi,

    when you create a new report and select what you want to see in columns/rows, instead of using something like member & descendants use member only and select all individual elements you want to see.

    That way the report always has the same column/row members.

    Regards

    Add a comment
    10|10000 characters needed characters exceeded

    • Thanks Arnold!

      You are correct the column headers stay static but the expansion still happens on the columns. In EVDRE, if you turned off column expansions, a user could delete or change a member in the column header and the report wouldn't rebuild it. In EPM, the report is rebuilt at every refresh hence the expansion still happens.

  • Posted on Jun 05, 2014 at 02:21 PM

    Selecting member only doesn't turn of the expansion because expansion uses Expand Options defined in the Sheet Options.

    I just found out a trick to turn off the expansion. It doesn't exactly turn off the expansion but it is a workaround.

    Go to Sheet Options and select Custom Expand --> Define Custom Expand. Check "Include member", "Only level" and type 999 to the level. Since there is not going to be a hierarchy that it's levels reach to 999 (unless you have a super huge hierarchy) the expansion in only is not going to work.

    Hope that helps.


    screenshot.jpg (44.5 kB)
    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 09, 2012 at 02:55 PM

    Hi,

    did anyone of you come across a soultion to that?

    I am currently trying to build an input schedule in which the user can individually select a certain dimension member per row.

    Thank you and best regards

    Felix

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.