SAP Knowledge Base Article - Public

2453629 - Manual format options seem not applied for new values in table widget in SAP Analytics Cloud


  • New hierarchical entries do not take over automatically the format settings of an exsiting table. 
  • Formatting settings applied manually:
    1. Highlighting cells
    2. Apply formatting in Styling menu 


  • SAP Analytics Cloud

Reproducing the Issue

  1. Import new hierarchical entry for an existing model.
  2. Open a Story where the same model is used as the datasource of the table and some formatting rules are also applied.
  3. Observe that the newly imported entry in not formatted.
    For example: The newly imported hierarchical object is 02/02/2017 in the below example.


The formatting was applied manually by highlighting the cells and changing the formatting settings.


In 2018.11 Wave contextual formatting of tables will be implemented of SAP Analytics Cloud to make formatting easier.

You can still use formatting rules instead of manual selection of cells for formatting, the newly added data will be also formatted according to the rule.

Please have a look at our video published how formatting rules work or follow the below steps:

  1. Edit the story and switch to the Designer.
  2. Go into Styling.
  3. Scroll to the "Formatting Rules" and click on "Add Formatting Rule"
  4. In the "Styling Rule" pane define a name of the rule and click on the button: Highlight.png.
  5. Highlight measures/headers/dimensions in the table when the button has is active: Highlighted.png.
  6. Highlighted dimensions and measure values will appear in a list below the "Content" part.
  7. Define a styling you'd like to apply.

As an example: The comparison of using manual selection (mes) or formatting rule (mes2) after uploading new data:


See Also

Your feedback is important to help us improve our knowledge base.
Please rate how useful you found this article by using the star rating feature at the beginning of this article.
Thank you.


Cloud for Analytics, C4P, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, HCP, C4A, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJ, BOBJcloud, BOCloud., BICloud, BO Cloud, modelo, SBOC, default, form, lost, , KBA , LOD-ANA , SAP Analytics Cloud (SAC) , LOD-ANA-BI , Business Intelligence Functionality, Analytic Models , LOD-ANA-BR , SAC Boardroom , How To


SAP Analytics Cloud 1.0