Skip to Content

(This was documented using version 10.0 SP17 Patch 2 of the EPM Add-In for MS Excel.)

As you jump into the EPM Add-In for MS Excel to access data
in SAP BPC , you will see there is
something called the Context Pane:

/wp-content/uploads/2014/07/2014_07_15_121541_498260.png

 
If you are not already on the EPM ribbon and logged in to a
model, then you will not see the Context Pane.

Above, you see 11 dimensions represented by the 11 drop-down
boxes.  Many of these will not be
familiar to most of the users, and consequently, choosing the wrong parameter
can lead to very wrong results.  There
are some cases, however, where the user might choose the time period, the
entity, the account, or the category (version), etc.  In these cases, you might have a “favorite”
context that you would like to work with.
In these instances, you can set a favorite context and save it for future
use.  This document will show you how.

While already logged in to a model (Consolidations, for
example), and on the EPM ribbon, perform the following:

  1. Click on the drop-down option beside “Options”
    and select Context Options:

    /wp-content/uploads/2014/07/2014_07_15_121735_498262.png

  2. Click on the Context Favorites tab, and then
    click on the Selected Member of the Dimension you would like to adjust.  In this example, we will click on Total
    Balance Sheet for the Account dimension:

    /wp-content/uploads/2014/07/2014_07_15_121754_498263.png

  3. The Member Select appears, and then choose Total
    Income Statement:

    /wp-content/uploads/2014/07/2014_07_15_121804_498264.png

    Click OK.

  4. Repeat steps 2 and 3 for all dimensions that
    need to be adjusted.  Some to consider
    are RPTCURRENCY (US Dollar), SCOPE, TIME (choose some relative period, although
    you will likely need to change this after selecting the favorite context,
    particularly if you are updating a monthly report), and MEASURES (Year to Date –
    for Balance Sheet related reports; Periodic – for P&L related reports).
  5. Then, enter a name for this favorite, and click
    on Create Favorite:

    /wp-content/uploads/2014/07/2014_07_15_121815_498265.png

  6. Now, you should notice a couple of new buttons
    as well as the option to either select the favorite you have just created or to
    create a new favorite:

    /wp-content/uploads/2014/07/2014_07_15_121825_498266.png

  7. Click on the Context Display tab to set the Context
    Favorite display option:

    /wp-content/uploads/2014/07/2014_07_15_121836_498267.png

    Check the box for Show Context Favorites and then either choose to put the
    Context Favorite at the start or the end of the Context.  I would suggest the start so that it will
    always be visible when the EPM Context is visible.

    Click OK.

  8. Now, you should notice the Context Favorite
    drop-down in your EPM Context:

    /wp-content/uploads/2014/07/2014_07_15_121849_498268.png

  9. Click on the drop-down and choose your newly
    created Context Favorite:

    /wp-content/uploads/2014/07/2014_07_15_121902_498269.png

    Notice that the context changed according to the settings for your favorite but
    the data in the report did not change.

  10. You can update the report in a couple of
    ways.  You can simply click on the
    Refresh button in the EPM ribbon:

    /wp-content/uploads/2014/07/2014_07_15_121913_498270.png

  11. Or you can change a setting to automatically
    refresh the worksheet on Context changes.
    You may find that you do not prefer this, but you can simply reverse
    these settings to undo this selection.  While
    on the EPM ribbon, click the drop-down beside Options, and then select User
    Options:

    /wp-content/uploads/2014/07/2014_07_15_121922_498271.png

  12. Check Automatic Refresh on Context Changes, and
    then click OK:

    /wp-content/uploads/2014/07/2014_07_15_121931_498272.png

  13. Reselect your context favorite to create a “context
    change,” and then your report will refresh.

I hope you find this useful.
Feel free to post comments, questions, or suggestions as you use this
functionality in the EPM Add-In for MS Excel in conjunction with the SAP BPC
content.

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply