Skip to Content

Not able to change context after distribution

Hello All,

I have distributed a report using DISTRIBUTION and all the reports were fine.

Again to check the data, I have opened the same report, placed in the server, in Excel Client through EPM Tab . But now I am not able to change the context through function EPMcontextmember()

Notably, the dimensions that I have given in Distribution Template, i.e. Fixed Members - Category & Time and Variable Member - Costcentre have deactivated in the context bar and I am not able to select member through drop down.

I went to Context Menu and after making selections there, I am able to refresh the report.

Pls suggest how can I select members using EPMcontextmember() function.

NOTE:- The report was working perfectly fine before doing distribution.

I am using BPC NW 10.0 with EPM Addin SP 25 Patch 3.

EDIT 1:- Apparently, if we distribute any report, the Context gets locked for Variable and Fixed Member at workbook level. I was looking in Context Menu for worksheet. After selecting Workbook from drop down, I was able to unlock the dimensions.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Feb 12, 2018 at 08:59 AM

    Sorry, but not clear, what are you doing. Try to explain using some sample screenshot!

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 12, 2018 at 09:31 AM

    Once again - use screenshots to illustrate your questions!

    Add comment
    10|10000 characters needed characters exceeded