Passing Members to Context

[Former Member]

Dear Experts, I have a requirement to build a report based on two different models. These two models have some dimensions in common which are provided for user selection. Moreover, these common dimensions are neither used in row axis or column axis. Now my question is if the user selects the dimension member from EPMSelectMember, is there any way we can pass this member to the context of the other report which is based on a different model. If these dimensions are used in page axis we are getting some error for common dimensions which are secured. For ex: For Dimension1 which is secured, has members aaa, bbb. If the report is saved with aaa member in the EPMSelectMember, and a person who has access only to bbb opens the report. He get some error like "The following members of the page axis are not recognized and have been removed from the report" We also cannot use EPMDimensionOveride since we are not using these dimensions in rows/columns axis. Is there any other way to meet this requirement? Any help on this case would be really helpful. Let me know in case you require any other information. Thanks in Advance. Regards, Chandra

[gajendra_moond]

Hi Chandra

Screenshots are needed. Based on the information, here are a few suggestions that may work-

- EPMSelectMember should have a dummy member,say "SELECT", updated at the time of saving or opening and that dummy member access can be provided to both users.

- Once that is there, then you can use combination of Epmcontextmember and EpmolapmemberO formulae for updating values in page axis.

Please provide more details to assist better.

[former_member186338]

Your security settings are not clear. Please provide some screenshots with sample report.

Vadim