Skip to Content
0

Analysis for Office - Conditional Formatting on Multiple dimensions

May 03 at 01:50 PM

62

avatar image
Former Member

Hi,

Does anyone know how we can achieve formatting where there are 2 or more dimensions involved. For e.g. I have Account and Org Hier in row axis and I wish to have a formatting on the data cells where I have specifically Account member 'AA' and Org Hier member 'YY'.

I can only do a formatting in Analysis for Office for members 'AA' and 'YY' separately, but not as an intersection like we could in EPM.

Thanks
-Nitin

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Tammy Powlas
May 03 at 02:39 PM
0

Hello Nitin - I can't think of anything; I recommend submitting an idea at the SAP Influence site or look at the existing related ideas and vote them up to support - https://influence.sap.com/sap/ino/#/searchcategory?type=campaign&id=889&search=conditional%252520formatting&managed=0 - logon required.

Show 2 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Sure Tammy, will do this as well.

Thanks
-Nitin

0
Former Member
Former Member

I am somehow not able to find an option to submit an improvement request. Can you help me navigate to the right place ?

influence.png (46.4 kB)
0
Venkata Subhash Medisetty
May 04 at 11:15 AM
0

Hi Nitin Nayyar,

i think this should be possible

Use the selection tab to select Account member 'AA' and Org Hier member 'YY', and maintain your definition(Condition)

hope this helps

Thanks & Regards,
Subhash


capture.png (44.7 kB)
capture1.png (36.5 kB)
Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member May 06 at 02:50 PM
0

Thanks Venkata,

Appreciate your kind help, I was aware of this feature, however, this is for a a very restricted functionality and has limitations thus not fulfilling my requirement,

1. This is only value based, and that too value only of the Key Figure in the report axis. In my case, the conditions may/may not be value based, conditions may be dimension attribute based, and may be based on the type of category selections etc. So this is not available here.

2. There is no option to lock the cells if I use this conditional formatting functionality. Say for e.g. if the category selected is 'Actual', grey out these rows and lock the cells.

3. There is a very limited formatting option in terms of colour, font, etc.

I am looking for a bit more flexible options to put such conditions. In EPM this was very simple and straight forward. In the Embedded world we would expect such functionalities to be available in AO as well now that we are working in the new BPC versions, but unfortunately its not at the moment.

Thanks,

-Nitin

Share
10 |10000 characters needed characters left characters exceeded