Issue while selecting multiple member Ids with display 'Id and Description' option in default report

[former_member566000]

Hi,

I am currently working on SAP BPC 10 standard and facing an issue as below,

In the above, In my default report I am selecting multiple Ids in cost center dimension in page axis and by using dimension override the cost center dimension is displayed in row axis in report 1. Here when I am selecting multiple Id's for cost center in default report the the report is as above showing only Ids of all the selected cost centers in both the reports but when we try to select display 'ID and Description' or only 'Description' in Cost Center dimension in default report then in report 1 cost centers are not displayed and it is and showing only parent member which is as below,

Below is the screenshot when 'ID and Description' is selected in default report,

Please suggest as we want user to select multiple members of a dimension from description,

Thanks !

[former_member186338]

Sorry, but totally unclear!

"In the above, In my default report I am selecting multiple Ids in cost center dimension in page axis and by using dimension override the cost center dimension is displayed in row axis in report 1." - what do you mean????

Provide full info with formulas used.

[former_member566000]

Hi Vadim,

In the above my default report is till A5 which I have hidden and my report 1 is from B7.

When we select members using display 'Description' in B2 the in A8 and A7 Parent member is being displayed and not the respective members selected in B2 which is as below,

Thanks!

[former_member186338 · Accepted solution]

Theoretically you can extract member ID's from EPMOlapMultiMember formula:

Multimember formula is:

=@EPMOlapMultiMember("Germany,France";"000";"[ENTITY].[PARENTH1].[DE]";"[ENTITY].[PARENTH1].[FR]")

Extraction formula:

=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(MID(FORMULATEXT(A1);FIND("""000""";FORMULATEXT(A1))+6;4000);"""";"");")";"");";";",")

In my case the argument delimiter in Excel functions is ";" - to be replaced by ","! In your case argument delimiter is "," - then this replacement will have no effect.

Result of the extraction will be comma separated list of member id's:

[DIMNAME].[PARENTH1].[MEM1],[DIMNAME].[PARENTH1].[MEM2],[DIMNAME].[PARENTH1].[MEM3],...

It can be used in EPMDimensionOverride formula without issues!

This sample will work independent from ID, Description or ID + Description in A1

[former_member566000 · Accepted solution]

Thanks Vadim. It works for us.

[former_member186338]

In general - don't use descriptions in formulas like EPMDimensionOverride. Sometimes it may work, sometimes not! Only Member Id's are working consistently.