Dynamically Change Members at report Run time.

[former_member288392]

Hello folks,

How can i dynamically change the members in row axis based on context change without using EPM Dimension Member override.

For example..

When PC is A,

I need Accounts 1,2,3 to be displayed in report.

When PC is B,

I need Accounts 2,3,4 to be displayed in report.

I can't use EPM Dimension Member override because then EPM Insert Members as there is a limitation around that.

Any suggestions including on how to achieve this  use of APIs would be highly helpful.

Thanks & Regards,
Sridhar Sundaram

[former_member186338]

Sorry,

But the statement "I can't use EPM Dimension Member override because then EPM Insert Members as there is a limitation around that" is absolutely not clear. Can you explain what do you mean?

Vadim

[former_member288392]

Sorry Vadim,

What i meant is..

If i use EPM Dimension member override , then EPM insert members functionality can't be used.

There is a limitation around that.

Thanks,

Sridhar

[former_member186338]

OK, now it's clear!

Then the solution is the complex VBA code using methods:

GetRowAxisMembers

AddMemberToRowAxis

RemoveMemberFromRowAxis

Or simplified one:

After applying EPMDimensionOverride - clear or comment the cell with EPMDimensionOverride in VBA and refresh (the issue is that double refresh will be required)

Vadim

P.S. No solution without VBA!