Page Axis Multi members in a dimension - Errors

[Former Member]

hello,

I am getting below error when I have multimember selection in my page axis..attached screenshot of the error.

Any idea why get that error? report works when I select single member..

BPC 10.1 NW.

EPM add in SP23

[Former Member · Accepted solution]

Hi Meg,

have a look at these 2 SAP notes 2129632, 2016928

which SP is your 10.1 ?

Andy

[Former Member · Accepted solution]

we are on SP6

[former_member186338]

By the way, how many members you have selected in the multimember page axis?

Vadim

[Former Member]

i have 5 reports in one sheet  & data from 3 different models.

report 000,002,003 - shares page & col axis-> selected 2 members for entity in page axis

report 001 ->shares col axis with above.. use vb to copy & paste  entiy page axis formula from above report in page axis.change report id in vba and paste

report 004 -> use vb to copy & paste entity page axis  formula from above report in page axis

only for entity its multiple selection and i selected only 2.

report works when i select single member for entity

[former_member186338]

I think the issue is here: "use vb to copy & paste  entiy page axis formula"

Vadim

[Former Member]

hmm..formula syntax all looks correct. why it will not work when i copy paste the formula?

[former_member186338]

Because formulas in page axis can't be simply copy pasted!

[Former Member]

copy paste formula with single member works..only when there is multimembers  it fails

ok..any other way to  override page axis members with multimembers?

[former_member186338]

The formula for single member is different then the formula for multiple members. You can't paste multimember formula instead of single member formula. Just test it manually using simple sample report.

Vadim