Error while selecting multiple members in page axis.

[former_member566000]

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!

[former_member186338 · Accepted solution]

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

[former_member566000 · Accepted solution]

Hi Vadim,

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

Thanks!

[former_member186338 · Accepted solution]

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 · Accepted solution]

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 · Accepted solution]

Below is the reference of cell C59

Thanks!

[former_member186338 · Accepted solution]

samhita.v

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

[former_member682599]

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]

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

[former_member682599]

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]

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!

[former_member682599]

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! 🙂