SAP BPC 10.1 dynamic header of local members.

[Former Member]

Hi,

we are using local members in our report. we want to change its header value dynamically. for example, local member name is Actual . it is written on header but we want to change it with respect to time. if time is 2016 then it would be 2016-Actual written in header of that local member. if its 2014 then it would be 2014 -Actual. we can change its header formula but when we refresh the report its back to its original header value. any solution so far?

[former_member186338 · Accepted solution]

It's not so easy

In the description field you have to put something like:

"&C2&"

where C2 is the cell with header

Then local member will put formula in the header:

= EPMLocalMember(""&C2&"";"000";"000")

And the link to C2 will work!

[former_member186338 · Accepted solution]

P.S. Explanation:

Any text typed in the description field will be surrounded by double quotes and placed in the formula:

= EPMLocalMember("XXXXXXX";"000";"000")

If we use text like:

"&C2&"

The result will be ""&C2&"" - concatenation of empty string, some text in C2 and empty string.

[Former Member]

Thank you All ... great and quick response. very much appreciated. your ideas solved my problem. thank you once again..

Please see my another thread "SAP BPC 10.1 show submit button on performer/reviewer when team is selected in performer and reviewer"

[Former Member]

Hi

Please note that you can only either reference a cell or use a EPMFunction. You can not concatenate different combinations.

For example,

"&EPMMemberProperty(,"VALUE_TYPE:10","YEAR")&" will work

"&C2&" as mentioned by Vadim will work as well.

But it does not like when you try to combine the above two statements in any fashion.

I recommend setting up the string in a cell and then reference that cell in the description of your localmember.

Hope this helps!

Ranjeet

[former_member186338]

"But it does not like when you try to combine the above two statements in any fashion" - why do you think so?

Any valid combination of Excel functions returning string can be placed between "& and &"

Vadim

[Former Member]

Hi,

you could reference a cell (like C5) in the description of the local member and then use an Excel formula in that cell to create the description you want.

BR,

Arnold