Not able to change context after distribution

[former_member590114]

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.

[former_member186338]

Once again - use screenshots to illustrate your questions!

[former_member186338]

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