EPMOlapMultiMember - #VALUE error upon selecting more than 4 members

[r_sengottaian]

EPMOlapMultiMember selection in page axis with more than 4 members resulting in #VALUE error. Please advise if there are any limitation in the number of members.

[r_sengottaian]

I checked the user authorization and seems everything in order.

The only difference that I can observe is :

1) Users with 32 bit excel can select more than four members and refresh the report successfully.

2) Users with 64 bit excel are incurring issues when selecting more than four members.

Any suggestions or advise?

[former_member186338]

I am using 64 bit Excel and 64 bit EPM inside AO 2.8 - no issues.

Just test AO 2.8 or EPM SP38 on 64 bit Excel

[former_member186338]

"Refreshing with selected members." - then, for sure, user will need at least read access to the selected members.

[r_sengottaian]

Refreshing with selected members.

[r_sengottaian]

I have already tried your suggestion and it is not working for some users. I did further investigation and found that the issue is not happening for all the users. Some users can execute the report with more than 4 members. Could this be a security issue ?

[former_member186338]

"Could this be a security issue ?" - not directly related to security.

What you are talking about:

Possibility to select more then 4 members?

or

Refreshing the report with already selected members?

[former_member186338]

I see that you have "|" as Excel function arguments delimiter. May be EPM have some issues with it...

Also try to set display only ID for this dimension, not ID and description. To make the line shorter.

[r_sengottaian]

Sorry about that. Please review and advise.

[r_sengottaian]

I have highlighted the error that occurred when selection more than 4 members.

[former_member186338]

Never use "Insert File" instead of correct "Insert Image". I don't answer questions with "Insert File" for screenshots

.

[former_member186338]

No issues with AO 2.8

8 members sample:

[r_sengottaian]

Hi Vadim:

Thanks for responding.

Version details : SAP BPC 11(Standard) with EPM version 2.7.401.87606

[former_member186338]

EPM version 2.7.401.87606 - may be you are talking about AO?

[former_member186338]

In past the limit was about 30 members... 4 is too low.

But you are not providing version details...