EPM Formatting sheet Inner/Outer dimension

[sap_user62]

Hi Friends,

I have 2 dimension in rows and I wanted to format the header for Profit center dimension with a border.

time

Account1 Profit center Level 1

| Profit center Level 2|

I have applied formatting to the header Level 2, (apply format to inner dimension). What i have noticed is it puts the border for the 1st dimension too (account). is it a bug or its behaving the way its designed.

time

Account Profit center level 1

| | | Profit Center Level 2|

as a work around i have used conditional formatting (create a rule to apply no borders if the value is NULL) to remove the border from the account dimension.

Is there a work around for this situation.

[former_member186338 · Accepted solution]

If you are talking about "Apply Format to option: If a row or column axis contains more than one dimension, you can specify to which dimension you want the defined format to be applied; the inner dimension being the last dimension, the outer dimension being the first dimension in the axis." then it's not working 🙂 And to my mind will never work - different interface has to be designed to support different formatting for different dimensions in same axis.

Use conditional formatting with the formula to get a column number:

=COLUMN()=2

to format second column.