Skip to Content
Technical Articles
Author's profile photo Johannes Huhn

How to use styling rules in your table widget & notes on performance – SAP Analytics Cloud



The content section of a styling rule defines the application of the styling rule on the table. We can define the relevant context for the styling rule. Using the mouse button on the right top corner, we can pick and select the desired context in the table widget itself.

Using the options below we can adjust the rule:

  1. Data: The data column consists of checkboxes for each dimension in the table drill. The story designer can opt to style transactional data. If the story designer opts the checkbox. transactional data for all selected member (as part of the context) will be styled.
  2. Header: The header can also be opted. Selecting the header, will also style the members (of the chosen context). Hence the style will be visible in the master data section.
  3. Member: The shown number provides the story designer the information how many different dimension members are considered (as part of the selected context). Hovering over the number will result in displaying the selected member descriptions. Note, this number can be adjusted using the context picker on the top right corner. In case a story designer wants to modify the context, it can be adjusted directly in the table.
  4. Level: The chosen relation provides the story designer with the flexibility to style hierarchical relations of the selected context.
    1. Self: Self means, the selected member that is part of the picked context anyway. “Self”-member can be seen by hovering over the number of members (see point 3).
    2. Self & children: Using that option we can also style children of the member. In case the chosen member is a node in a hierarchy, all immediate/direct children underneath the selected member will also be styled. In other words: The style will be directly applied to the direct descendants of the picked member, too.
    3. Self & Sibling: The option to style siblings will also result in styling selected members having the same parent member in the hierarchy.
    4. Self & descendants. This option is like 4.2. Not only direct descendants will be styled, but also all hierarchy levels below will be styled, too.
    5. Children & Descendants: same as 4.2 and 4.4, but without Self 4.1
    6. All: This will style the whole context of the dimension

Cell Properties

Read-only: The applied style will make affected cells input disabled.

Editable: The applied style will make affected cells input enabled.


Notes on performance

As a best practice we recommend styling rules over ad-hoc styling. To learn more about ad-hoc styles, click here. Styling rules support CRUD (create, read, update, delete) which makes them modifiable and ready for generic use. Note, styling performs faster the less rules are defined and the less members are used in the content definition.

Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Seamus Taylor
      Seamus Taylor

      Hi Johannes,

      Thanks for the blog. One follow up question: Is it possible to apply the same styling rules to multiple tables? Not, styles, but the rules.


      Author's profile photo Lukasz Kubiak
      Lukasz Kubiak

      Hi Johannes,


      thank you for the very interesting presentation of the topic. I would have one question, could you explain how you craeted this setting marked in red?

      Author's profile photo Stefan Dufter
      Stefan Dufter


      You can get this by designing structures in the eclipse query in the lines section.

      Author's profile photo Vinoo Ganesan
      Vinoo Ganesan

      Hi Johannes,

      Thanks for nice blog.

      My template is dynamic rows based on GL and Transaction type, I would like to create Style Rule

      RULE: For Opening Balance in row:

      1 for All Opening Balance dynamic set to Read only and greyed out [Dynamic template in rows]


      I have created a rule but it is not applying dynamic to all my opening Balance , I have to go manually and select each Opening Balance row and apply the Style rule which is not acceptable for dynamic rows , Please advise any

      suggestions for dynamic rows Style where the system can recognise the member.

      Author's profile photo Marcelo Rodrigues de Jesus
      Marcelo Rodrigues de Jesus

      Great article. Congrats.