Skip to Content
2

Analysis for Excel 2.4 - Set custom style for hierarchy nodes and data

Feb 20, 2017 at 12:03 PM

312

avatar image

Dear Experts,

I have the task to set a custom style on a workbook based on analysis for excel 2.4.

I need to set a format that applies to members AND data of all the nodes of a hierarchy except leaves, like in following image:

I want this format to be dynamic, so that, once applied, all present and future nodes of the hierarchy will obtain this formatting.

Thank you in advance, Francesco

requirement.png (14.6 kB)
10 |10000 characters needed characters left characters exceeded

Francesco - have you tried the Analysis Cell styles, and where do they not work for you?

1franc.jpg (34.9 kB)
0
* Please Login or Register to Answer, Follow or Comment.

5 Answers

Francesco Gullotta May 31, 2017 at 03:59 PM
1

Dear Cesar,

unfortunately I did not find any solution to this issue.

Regards, Francesco

Share
10 |10000 characters needed characters left characters exceeded
Francesco Gullotta Feb 20, 2017 at 02:43 PM
0

Hello Tammy,

first of all thank you for answering, if I use Analysis Cell for Hierarchy, for example SapHierarchyCell1, what I get is that I apply a format only to Hierarchy member nodes:

I also need to apply the formatting to the values of the keyfigures corresponding to those nodes, so, in my screenshot, values in the red circle should be yellow as well.

Do you know how to reach this result?

Thank you, Francesco


format1.png (3.3 kB)
Share
10 |10000 characters needed characters left characters exceeded
Tammy Powlas
Feb 20, 2017 at 06:38 PM
0

Hello Francesco - those are Member Cell styles; go to the Home page and select the Cell Styles ribbon and you will see them:


1franc2.jpg (61.7 kB)
Share
10 |10000 characters needed characters left characters exceeded
Francesco Gullotta Feb 21, 2017 at 09:10 AM
0

Thank you Tammy, I already tryied modifying SAPMemberCell but if I do that I end up getting all member cells highlighted instead of only member cells corresponding to hierarchy nodes (not leaves):

So, in my screenshot, values in the green circle are correctly paintend in yellow, because they correspond to a hierarchy node, but values in the red circle are wrongly yellow, because they correspond to a hierarchy leaf.

Thank you, Francesco


cattura.png (3.8 kB)
Share
10 |10000 characters needed characters left characters exceeded
Cesar Hernandez Martinez May 25, 2017 at 12:35 AM
0

Francesco, did you find out how to fix this? I have the same requirement. As there is only one SAPMemberCell, then the format is applied to several nodes.

Share
10 |10000 characters needed characters left characters exceeded