Skip to Content
avatar image
Former Member

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

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)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • avatar image
    Former Member
    May 31, 2017 at 03:59 PM

    Dear Cesar,

    unfortunately I did not find any solution to this issue.

    Regards, Francesco

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 20, 2017 at 02:43 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 20, 2017 at 06:38 PM

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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 21, 2017 at 09:10 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 25, 2017 at 12:35 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded