cancel
Showing results for 
Search instead for 
Did you mean: 

Indentation of Local Member

Former Member
0 Kudos

Dear Friends,

I am working on EPM/BPC 10.1 NW

In the report, in the row axis, I have four dimension i.e. CATEGORY,TIME, ACCOUNT, PRODUCT and then a local member which is =Concatenate(CATEGORY, TIME,ACCOUNT,PRODUCT). I have selected 'Indent Children' in Sheet Option/Formatting.

But the local member formula does not get indented. 😞

So the question I have is, How to indent the local member formula.

Thanks,

Rahul

Accepted Solutions (1)

Accepted Solutions (1)

former_member186338
Active Contributor
0 Kudos

Simulation of indent for local member:

For example we want to create a local member containing P_ACCOUNT dimension (in row axis) member description with indent.

Then:

=REPT(" ",EPMMemberProperty(,EPMMemberID(EPMDIM_CURRENT_MEMBER(P_ACCOUNT)),"HLEVEL")-1)&EPMMemberDesc(EPMMemberID(EPMDIM_CURRENT_MEMBER(P_ACCOUNT)))

2 spaces indent will be applied!

Former Member
0 Kudos

Thanks Vadim, your formula worked out for me.

Rahul

Answers (1)

Answers (1)

former_member186338
Active Contributor
0 Kudos

Indentaition is not applied on local members... Can be some workaround but I don't understand the requirements:

"member which is =Concatenate(CATEGORY, TIME,ACCOUNT,PRODUCT)." ??????

How and what do you want to indent...