cancel
Showing results for 
Search instead for 
Did you mean: 

Error while selecting multiple members in page axis.

former_member566000
Participant
0 Kudos

Hi,

We are currently working on BPC 11 standard and we are facing an issue when trying to select multiple members in page axis.

Below is the screenshot of the error,

In the above, we are selecting multiple members in B2 and based on that we need the company code property to be displayed in B3.

Thanks!

Accepted Solutions (1)

Accepted Solutions (1)

former_member186338
Active Contributor
0 Kudos

You have to create formulas like on my sample (you can add more lines for longer list - up to 30)

former_member566000
Participant
0 Kudos

Hi Vadim,

We were able to pull multiple properties but that cell value is not recognized in the report.

Thanks!

former_member186338
Active Contributor
0 Kudos

samhita.v

Sorry, but what do you mean by:

"We were able to pull multiple properties but that cell value is not recognized in the report."

former_member566000
Participant
0 Kudos

Hi Vadim,

Below is the screenshot of report where we are using dimension override to pull Fund members in report 001 but it is not pulling the members from cell T22. Could you please help we are missing anything.

Thanks!

former_member566000
Participant
0 Kudos

Below is the reference of cell C59

Thanks!

former_member186338
Active Contributor
0 Kudos

samhita.v

EPMDimensionOverride will recognize list of comma separated members in some cell. Test with manually created list.

Answers (1)

Answers (1)

The error is quite obvious.... You can't pass a string like "ID1, ID2, ID3..." to EPMMemberProperty as an ID. Please split the members by comma and retrieve the property one by one.

former_member186338
Active Contributor
0 Kudos

In general you are right! But it's easy to say "split members..." but not easy to implement 🙂

0 Kudos

That's true. In my limited experience, I will write a VBA sub which calls SPLIT() function to implement this, and the sub can be called by an excel button or integrated in BEFORE/AFTER_REFRESH depending on the detailed business scenario.

former_member186338
Active Contributor
0 Kudos

cokecola

Most people don't like to have VBA in case when it's possible to do it with Excel formulas!

I will show how!

0 Kudos

I can only think of FIND() + LEFT/RIGHT/MID to split strings by seperator, but it seems not applicable in this case cuz the number of cost centers is not fixed... Expecting your solution! 🙂