In this article, we will detail how to create semantics for your key figures and apply them to your SAP Business ByDesign reports. What is semantics you ask? Semantic tags allow you to assign a default color/pattern to a specific key figure, which can then be applied across all of your reports within the ByDesign system. This can be a big help for users to quickly focus in on the most important key figures for your organization across multiple reports and department. For example, you may look at the key figure Invoice Order Value in different reports such as Sales Order Volume and Invoice Volume, which cross over the sales and finance departments. This also can create a consistency of key figure within one report. In ByDesign, SAP has a default set of colors for charted key figures which are assigned based on the display priority.
In this article we will be looking at the example Invoice Value in the Invoice Volume Report.
In this first ByDesign report view, Invoiced amount is the first and only key figure displayed in the chart and it is blue.
In the next example, Net Value has been added as a key figure and placed above Invoiced Amount. Now Invoiced amount is now displayed in green.
How To:
Define the Semantic Format
In this step we are defining the color and pattern which will be used to apply to the key figure of the ByDesign report in a future step.
- Navigate to Business Analytics à Semantics
- Click ‘New’.
- Enter a Name for your Semantic.
- Choose a color. A default color palette will pop up, but a full color range can be chosen by clicking on ‘More Colors’.
- Optional: Choose a pattern for the semantic if you want to display something other than a solid bar.
- Click OK
Apply Semantic to Key Figures for Charts
In this step we will apply the semantic to key figures in both chart and table type ByDesign reports
- Navigate to Business Analytics>Design Reports
- Select the report which you will apply semantics
- Click Semantics>Assign
- Scroll to the key figure which will have the new semantic coloring.
- In the semantic column, enter your previously created semantic. The color pattern should immediately appear in the Preview column.
- Click OK.
- Repeat steps 1-6 for any other report you wish to apply the same format.
Example of Sales Order Volume report with Invoiced Amount in new color scheme.
Example of Invoice Volume report with Invoiced Amount in new color scheme.
Apply Semantics to Tabular ByDesign Reports
It is also possible to impact the tabular view of reports by applying semantic coloring to column headers
- Navigate to Business Analytics>Design Reports
- Select the report which has semantic key figures enabled.
- Click Edit With>Web Browser
- Click on the View icon.
- Click on the Chart/Table Settings icon.
- Click on the Table Tab
- Toggle ‘Use Semantics’ to On
- Click Apply
- Click Save As to create a new view or Save to update an existing view
- Repeat steps 1-9 for any other view where semantics should be applied for Tabular Reports
For more helpful articles for SAP Business ByDesign like this visit our Resources page.