BPC 11.1 Header data EPM

[former_member697627]

Hello everyone,

I'im working on an output excel file, i need to concatenate the time and category dimension in the same cell, as you can see on the picture down below:

the result that i need is the one specified on the line 5.

I tried using the function concat on excel but once i change the context the result doesn't follow and shows #REF value, instead of the result i need.

Do you guys have any idea how i can do this ?

Thank you in advance

[former_member186338]

Sorry, but unable to understand - what are you doing???

No formulas, no report design...

[former_member697627]

i want to concatenate the content of my dimension category with dimension time.

In EPM you can have each dimension on a different row as you can see here on the line 6,7

this is the standard result.

what i need is a line like line 5 that would combine both dimensions

This is my report content :

Hope that this made my need clear 🙂

[former_member186338 · Accepted solution]

You can create a local member to be used as header. In this local member you can concatenate whatever you want. Then hide the real header.

[former_member697627 · Accepted solution]

Is this how i'm supposed to do it ?

[former_member186338 · Accepted solution]

soumayaitaazize

Sorry, but do you really think that I can confirm your local member setup without looking on your report details???

For me something is strange: insert after some member! Why not before row axis?

Try yourself, it's easy...

And please, accept the correct answer.

[former_member697627 · Accepted solution]

I've tried it out but it's not rendering the result i need

In my Excel sheet, let's say i have two column headers that contain these values, these are context values of course that will dynamically change based on customer choice.

=@ EPMOlapMemberO("[TIME].[PARENTH1].[2020.TOTAL]";"";"2020";"";"000") -> this returns 2020

=@ EPMOlapMemberO("[C_CATEGORY].[PARENTH1].[BUDGET]";"";"Budget";"";"000") -> this returns Budget

What i need is another row where i will get Budget 2020 in the same cell

Hope that i made it clearer now, i've tried using local member but once i change my context, the value of the local member is not correct, as you can see here

Here is my local member config

capture4.png

[former_member186338 · Accepted solution]

soumayaitaazize

Sorry, but you are doing something completely wrong!

Your new local member have to contain concatenation in the formula field, not in the description!

Formula will be:

=EPMDIM_CURRENT_MEMBER(C_CATEGORY)&" "&EPMDIM_CURRENT_MEMBER(TIME)<br>

Please, read help about local members:

https://help.sap.com/viewer/ec68e48b18a44a49abb12b8ee8ae306f/10.0.38/en-US/f9bdca036faf1014878bae8cb...

"Displaying the type of accounts of the members displayed in the row axis"