Analysis for Office has a default style set named ‘SAP Blue’.
Besides the default style set you can select the ‘ Black and White’ or the ‘Tradeshow Plus’ Styles.
If these Styles don’t fit with your company style just follow this Step-by-Step Guide to create your own style set.
Go to Analysis for Office tab
Open a random BO or BW report.
Go back to the Analysis TAB and select ‘ STYLES’.
Export and Import options are meant for XML files. If you are familiar with XML files you can export the default Style set and modify it with your own colour codes and import the file again. The XML file can be modified in Notepad.
In this article we will discuss the first two options, ‘Save Style Set’ and ‘Apply Style Set’ .
In this example we use the default style set as depicted below. The style which we will create will include the Just-BI colours, the same style as on our website www.just-bi.nl.
Move your cursor to the analysis report and select a cell of the dimension in the rows or columns.
Than go to the ‘Home’ Tab in Excel and select ‘Cell Styles’.
This will give you the cell styles which are available to be modified.
This is an useful overview to see the colour assignments to component in the report.
In this example I will just modify a view Cell Styles to show you how simple it is to create your own Style set.
In the appendix I’ve embedded all the definitions of the cells above.
Now select a cell with figures and go to Cell Styles again, as indicated in step 5.
Tip: hover over the Cell Style to see the change in real-time on the selected cell.
Go back to Cell Style ‘ SAPDataCell’ and right mouse click to modify the cell style.
In the next popup of the cell you can specify the Cell Style settings. (For the XML you can find the colour code as well; in this case it’s RGB 31 73 125, SAPDataCell).
The format button allows you to change the format setting of the cell.
Go to the ‘Font’ Tab and change the colour of the font. We choose grey for our company style. This means that report figures will show as grey in our case.
After selecting the font colour, we will modify the border colour to grey as well.
Repeat step 8 and 9 for Cell Style ‘SAPDataTotalCell’ to show the totals in the same font colour as bold and the cell border.
The image below shows the report before and after the changes we’ve made in step 8 to 10.
Repeat Step 8-9 for Cell styles:
– SAPDimensionCell => Header of the dimension
– SAPMemberTotalCell => Total of dimension
– SAPMemberCell => Member of the dimension
When you changed the Cell Styles correctly; the colour of the dimensions in the row and columns should have the same colour as shown below. The figures reflect the ones chosen in step 8-9.
Saving the style set
Go the Analysis Tab > Styles > Save Style Set >, <customer name>_<area>
If the Style Set is applicable for all kind of data, you can check the option ‘Set as Default’. This Style will always be selected when you run Analysis reports. After selecting this style you have to execute Refresh All in the Analysis ribbon to apply the changes.
NB: To delete the Style sets, go to the styles and select: Delete User Style Set.
Step 13 (Optional)
If you didn’t check the option ‘Set as Default’ you can apply this style set to your reports.
Go to Styles > Apply Style > Set and select your own Style set (JUST-BI_FIN) will be activated for the analysis reports.