on 03-09-2017 5:39 PM
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
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!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.