Styling Rules for Tables

In SAP Analytics Cloud, styling rules allow you to make text style changes along a hierarchy, changing styles for sibling, descendant, or child members.

Styling changes that you make to the hierarchy are also applied to new members in the hierarchy.

Procedure to Apply Styling Rules

Select a table cell.
In the Styling panel, find the Styling Rules section and then select Add Styling Rule.
Provide a name for your rule.
Select the level to apply the styling to:
- Self
- Self & Children
- Self & Siblings
- Self & Descendants
- Children
- Descendants
- All
Restriction

For SAP BW, only two styling levels are currently supported: Self and All.
Select an existing style or create a new one.
Restriction

Only SAP Analytics Cloud planning-enabled models can use the read-only settings.
Set the Read-Only Settings:
- Not applied
- Read-only
- Editable
When finished, select OK.

The table cells are updated with the new style.

Styling Tips

Here are some guidelines about applying styles to your table.

Some styles are applied to the content of the cell, not the cell itself. In those cases, the cell retains it's styling even if the position changes (for example, a row is deleted or added).

Styles that are applied to cell contents include the following:

Styling child cells will only apply the style to the child cells and not their parent cells.
Having repetitive member names in the same color. This can only be done when the selected table template is the new default template.

Styles that are applied to the cells and not just their contents include the following:

Styling the whole data region.
Styling the whole header region.
Styling a whole dimension (title and members).
Styling a whole widget.
Styling parent cells in a hierarchy: the styling is automatically applied to the children.
Styling rules that change all aspects of a style.