Skip to Content
author's profile photo Former Member
Former Member

EPM Context Selection on Shared Reports BPC NW 10.0

Hello experts,

I am trying to use EPM Context Pane to select variables for categories (versions) and I noticed one funny thing.

If my worksheet contains two reports with different sources, context pane is report specific.

For instance, I have one report on actual cube and another one on plan cube.

I can select category "ACTUAL" on the actual report and "ACTUAL" data is displayed in the actual report. On the right, I have the plan report and I can select "PLAN" category, the report refreshes and "PLAN" data is displayed. The selection is report specific.

However, if I have two reports on the same cube (plan) , the selection works for the whole worksheet.

For example, I have one report where I want do display data with category "PLAN" and another report where I want to display data with category "PLAN_2". Both reports are on the same cube. If I use the Context Pane on the left report, only data with category "PLAN" is shown in both reports. If I select category "PLAN_2" on the right, only "PLAN_2" is shown in both reports.

Is there some kind of option I forgot to turn on? I want the Context Pane to be report specific.

Putting category in Page Axis works fine, but I want to use the Context Pane.

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    Posted on Jan 28, 2014 at 09:55 AM

    Hi Denis,

    This is a typical reporting requirement. Vadim'd recommendations are spot on. Just to help with example, you can replace the

    EPMOlapMemberO("[VERSION].[].[Actual]","","Actual","","000")

    with

    EPMOlapMemberO($B$2,"[VERSION].[].[PLAN]","PLAN","","000")

    in one report while you keep the other dynamic. Or simply enforce it for the two reports. Ensure that the referrenced cell, B2, contains the desired option.

    BUt in your case, the requirement is simply enough to be taken care of in one report as suggested by Vadim. Just ensure to force the EPMOlapMemberO selection.

    Regards,

    Seyi.

    Add a comment
    10|10000 characters needed characters exceeded

    • Even more simple way:

      1. In B2 put EPMSelectMember function:

      =EPMSelectMember("Connection Name";"[VERSION].[].[Actual]";"";"VERSION";FALSE)

      where VERSION is the name of CATEGORY type dimension.

      Double-click on this cell to select a different version....

      2. Enable member recognition in options.

      3. In the column axis cell where you have VERSION type "=$B$2" and the EPMOlapMemberO function will be created with the link to $B$2 inside.

      4. Disable member recognition.

      If you change the version in B2 with double-click selection from the list of members and press Refresh - the report will show the correct figures.

      Vadim

  • author's profile photo Former Member
    Former Member
    Posted on Feb 10, 2014 at 03:03 PM

    Thank you for the hints!

    What I did was following. I simply added (EPMContextMember("Connection";"CATEGORY"); in the EPMOlapMemberO on the right side. So the report on the right responds to the context and the report on the left can be set manually through Page Axis (EPMSelectMember would do it as well).

    EPMOlapMemberO(EPMContextMember("Connection";"CATEGORY");blabla)

    Regards,

    Denis

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 27, 2014 at 03:37 PM

    Hi Denis,

    The context is model specific, not report specific. If you have number of reports for the same model then you can use context only for one report and other ways to set members for another report. Please show the example screenshot!

    B.R. Vadim

    Add a comment
    10|10000 characters needed characters exceeded

    • First, why not to use single report with 2 dimensions on column axis - Time and Category??

      Second - why not to have column axis for this single report static, with EPMOlapMemberO function containing link to cells with Category and TIME members.

      For Time member you can use EPMContextMemember function (one value!)

      For Category members you can use 2 cells with EPMSelectMember functions

      We have a lot of reports like this created using the described approach! And it's easy to use EPMSelectMember instead of context because context is only one.

      B.R. Vadim

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.