| Table of Contents | ||
|---|---|---|
|
Conditional Formatting
You can use conditional formatting to highlight important values or unexpected results in your data
- Choose Conditional Formatting New in the Display Group Tab and click New
The New Conditional Formatting dialog box appears.
- In the Name field, enter a name for the new conditional format.
- In the Based on list, select the measure you want to apply the conditional format to.
- In the Format list, select the style you want to use for highlighting values. The following styles are available:
- Background: the cells background is colored.
- Values: the text of the cells is colored.
- Status Symbol: a symbol is displayed in the cells.
- Trend Ascending: a colored arrow (green to red) is displayed in the cells.
- Trend Descending: a colored arrow (red to green) is displayed in the cells.
- Trend Grey: a grey arrow is displayed in the cells.
- Select one of the nine priorities of the style selected above. Every style consists of nine members. The numbers 1 to 9 represent the priority of the rule.
- Select one of the following operators: Between, Outside, Greater Than, Greater Than Or Equal To, Less Than, Less Than Or Equal To and Equal To and enter a threshold value or value range.
- Press Add
- Press OK to apply your rules to the crosstab.
Multiple Choice Format
The formatting can be applied to 3 places :
- Data Cells: Conditional formatting will execute to the Cells.
- Row Headers: Conditional formatting will execute to the Row Header.
- Columns Headers: Conditional formatting will execute to the Column Header.
Measures Formatting
To define the measures display, you can specify the number format for each measure in your analysis. This includes the scaling factor and the decimals used.
Number Format
Select a cell from the measure that you want to change
- Choose Measures Number Format
- In the Number Format dialog box, select the Scaling Factor and the Decimal Places that you want to use for the measure display
- Select the Display Scaling Factor and Units in the Header for All Measures check box if the scaling factor should be displayed in the crosstab
- Press OK
You can change several options on how the measures are displayed :
- Select the cell of the measure you want to change.
- Select "Measures" in the menu.
- Number Format
Scaling Factor: 1 if you want to display the number as is. 1000 if you want to display thousands.
Decimal Places: Change the default number of decimals shown (The full decimal will still be in the cell, just the display changes).
General Format
- Display of Negatives Values : several ways of displaying the negatives values. Ex : - X, (X)
- Display Zero as : several ways to display the 0 values. Ex : empty, 0 with currency...
Members Display
Members can be displayed as key, text or both. For texts, you can define which text should be displayed.
Select a member cell of a dimension to define the display for all members of this dimension.
Choose Members and the display option you want to use. You can select the following display options:
- Text: The members are displayed with their text.
- Key: The members are displayed with their key.
- Text and key: The members are displayed with their text and key.
- Key and text: The members are displayed with their key and text.
If you select a display option that contains text, you can choose between three display options for the text: Medium Text, Long Text or Text.
The default display of repeated members will be blank on the next line. If user wants to display repeated value, there is "Repeat Members" option at the design tabFor most dimensions, you can change the way it is displayed and choose between "Key" or "Text" or both.
| Info |
|---|
Not all dimensions are available in both Text but all are available in Key This (Its depends on the configuration). |
- Select your Dimension cell header that you want to display
Select « Members» in the ANALYSIS Ribon then choose your display.
Dynamic Charts
You can transform any crosstable into an excel chart.
| Note |
|---|
You can also add the chart directly from the excel menu BUT in that case, it will not be dynamic. If you add columns/rows, the chart will not be updated. For this to be dynamic, use the Analysis feature. |
Working with Style Sets
A style set is a collection of Microsoft Excel cell styles that is applied by Analysis to format the cells of a crosstab. Whenever you insert a new crosstab in a workbook, the styles in the current default style set are used to format the crosstab cells. You can change the applied style set in your analysis.
Apply a Style Set
You can apply one of the SAP style sets or any new defined style set to a workbook.
- Click on cell in the crosstab you want to add a chart to
- Click the chart button to insert the type of chart you want.
A Chart is added in your sheet, you can drag and drop and re size.
3 main types of charts :
| Info |
|---|
Once added, you can use the normal excel functionality to modify the chart. |
Working with Style Sets
Style sets are pre-saved/defined sets of formats (colors etc...). You can create your own or use one of the 3 default ones.
Apply a Style Set
To apply a style set :
- Click “Styles” button in the Setting Group Panel
- Select “Apply Style Set”.
Choose the desired Style
You can set one of the "Sets" as default for your Analysis. This set will automatically be applied to all your new workbooks: .
| Info |
|---|
Analysis comes with 3 default sets :
|
Create a new Style Set
You can customize the formatting of all cells in an analysis Crosstab and then save it as a Style Set to reuse it in other workbooks.
- Click the Home Excel ribbon
- Select the type of cell in your crosstab you want to customize
- Click “Cell Styles” button
- Right click in the highlighted cell and select “Modify”
- Select “Format”, and choose your style then click OK
- Select “Styles” in the Analysis Tab, select “Save Style Set”
| Info |
|---|
Note that the currently selected cell’s style is highlighted. You must repeat this process for all the cells you want to customize |
On the Home tab, in the Styles group, choose Cell Styles. Modify the existing cell styles or create new cell styles according to your needs with the Microsoft Excel style functionality.
- On the Analysis Design tab, in the Format group, choose Styles >> Save Style Set...
- Enter a Style Set Name
- Select the Set as Default check box if the style set should be applied as default in your workbooks. The default style set is used when you open a new workbook and insert a data source
- Press OK
Export/Import a Style Set
To Export a Style Set (XML file) :
- Apply an existing Style Set
- Click the Styles Button and Select “Export Style Set”
- Enter a name Style and save your Style Set in a file
To Import a Style Set (XML file):
- Click the Styles Button and Select “Import Style Set”
- Select your Style set and click Open
Creating a Default Workbook
- Modify the workbook to set the default format you want to keep (Apply sets, add information cells, change formatting...)
- Save your workbook Locally (excel file)
- Click "Settings"
- Select "User Settings"
- Select the "Default Workbook Location" and browse to select your own saved workbook.
| Info |
|---|
Setting a default workbook can save you time if you always to have the same formatting in the future. |
