cancel
Showing results for 
Search instead for 
Did you mean: 

EPM Formatting sheet Inner/Outer dimension

sap_user62
Active Participant
0 Kudos

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.

Accepted Solutions (1)

Accepted Solutions (1)

former_member186338
Active Contributor
0 Kudos

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.

Answers (3)

Answers (3)

sap_user62
Active Participant
0 Kudos

Thanks Vadim.

The original report has bigger drill down in the profit centers with other formatting too. When we print the report it does not look good, as the formatting gets extended to the empty cells of the first row

When we specify "format on inner dimension" we expect it to be formatting on a single inner dimension. not both the dimensions. (i hope that is what it means)

former_member186338
Active Contributor
0 Kudos

"When we specify "format on inner dimension"" - how? what do you mean?

sap_user62
Active Participant
0 Kudos

In the epmformating sheet, there is a radio button, which shows formatting to inner dimension or outer dimension.

sap_user62
Active Participant
0 Kudos

Thanks Vadim for your reply.

Attached is the screen shot of a simple report with expected result and the actual result with the formatting sheet selection. capture.png

Currently I am using conditional formatting to remove formatting of the first dimension in the row structure.

I will check if I can update the tag for this question.

Thanks

Ed.

former_member186338
Active Contributor
0 Kudos

But why do you expect the mentioned result?

former_member186338
Active Contributor
0 Kudos

Sorry, but do you really think that it's possible to help you without clear screenshots? Or you have no time?

P.S. And the question tag is incorrect, has to be: EPM Add-In for Excel