Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »


Data Binding

Since the QRC3 release 2022 of SAC, data can be directly linked to our custom widgets. The first step is to assign a Data Model. To do this, click on the -icon on the right and select the data model you want to use.

Measures

Determine which measures should be depicted within the chart.

Categories

Define here which dimension determines the category (X)-axis.

Series

Here you can generate several series of the above selected measure by means of a dimension - according to the characteristics of the dimension. Use this option, for example, to "break down" the key figure "Sales" according to actual and planned values by entering the dimension for scenarios here.
The chart shows two series accordingly. 

Filter

You can define (background) filters for dimension values here.

Variables

At this point you transfer values for variables.

Small Multiples

To display so-called "small multiples" use the following options.:

Split Dimension

Determine which dimension should be used as the split dimension for the calculation of the small multiples.

  • Power BI: The Small Multiples Dimension option can be found in the Visualization Pane under Values fields.
  • SAP Analytics Cloud: Dimension, whose member is used to calculate the small multiples.
  • Tableau: Dimension over whose member the small multiples are calculated.

N Count

Defines the number of charts to be displayed before the 'Rest' position.

  • The N Small Multiples before the 'Rest' position are sorted in descending order according to their respective totals starting with the largest Small Multiple.
  • If the number N exceeds the number of existing members of the split dimension, no 'Rest' position can be formed. However, the descending sorting remains.
  • If the N Count is set to "0" or "none", the order of the small multiples corresponds to the order of the split dimension members from the data source.

Min Width [px]

Defines the minimum width of each small multiple chart.

Min Height [px]

Defines the minimum height of each small multiple chart.

N + Rest

Use this option to restrict the number of members (N + Rest) of a dimension.

N + Rest Pop Up

You can define one configuration of N + rest for the graphomate charts:

  • Enable: Applies the N + Rest Confuration, when enabled.
  • Mode: Choose between top (Top) and bottom (Bottom).
  • Number n of top/bottom members: Define the number of top/bottom elements.
  • Target Dimension: The dimension for which the top/bottom members are to be determined - e. g. "Country".
  • Target Dimension Subset: Here you have to select the key figure on which base the top/bottom-N members are calculated.
  • Rest Member Name (optional): Sets a label for the rest member.
  • Description (optional): Defines a description for the set configuration.


Series

Styles

At this point you define the styling of a series. Use the Series Style pop-up to define the appearance of the data series, provided you do not use scenarios. Scenarios overwrite the Series Styles.

Import/Export

Copy this string to use Series Styles in other graphomate charts components.

Visibilities

Use the checkbox to specify which of the series should be visible in the chart.

Element Offset

The Element Offset parameter determines the displacement of the elements on the category axis relative to each other. This can be specified in percent or absolute in [px] using the switch. Negative values can also be used for displacement in the opposite direction.

Offset per Series

Der Offset kann hier pro Serie festgelegt werden.

Series Style Pop-Up

  • Color: Define the color using the colorpicker or enter a HEX code here.
  • Fill Type: The available Fill patterns are the following: filled(Filled), not filled (Empty), hatching down (Hatched Down), thick hatching down (Hatched Down Bold), hatching up (Hatched Up), thick hatching up (Hatched Up Bold), dotted (Dotted).
  • Shape: Refers to the pin heads or line points. The following shapes are available: circle, rectangle, rhomb, wedge, no symbol (none).
  • Width: Determines the width of the elements. This can be specified as a percentage of the category width or as an absolute value in [px].
  • Font Weight: Choose between normal or bold font size.

Width can only be applied to column and bar charts. 


Scenario Definition

The list element contains all definitions of scenarios in this diagram. By clicking on the + symbol a new scenario is created. When hovering over a list element, a red trash can appears, which implies that a scenario has been deleted.

Import/Export

Copy this string to use scenarios in other graphomate charts components.

Scenario Definition Pop-Up

  • Identifier: Assign a unique abbreviation for the scenario.
  • Color: Define the color using the colorpicker or enter a HEX code. 
  • Fill Type: The available Fill patterns are the following: filled(Filled), not filled (Empty), hatching down (Hatched Down), thick hatching down (Hatched Down Bold), hatching up (Hatched Up), thick hatching up (Hatched Up Bold), dotted (Dotted).
  • Shape: Refers to the pin heads or line points. The following shapes are available: circle, rectangle, rhomb, wedge, no symbol (none).
  • Width: Determines the width of the elements. This can be specified as a percentage of the category width or as an absolute value in [px].
  • Font Weight: Choose between normal or bold font size.

Scenario Assignment

The scenarios can be assigned in two ways:

  1. Scenario per element of a series (Scenarios 1, Scenarios 2 etc.)
    1. A field represents one element of the selected series. As soon as the abbreviation of the scenario is entered in a field, the series is extended by one field.
    2. Alternatively, you can click on the csv button to enter the input using a comma-separated character string (Example: AC,AC,AC,FC,FC,BU).
  2. Scenarios by Series
    1. A line corresponds to a series. Enter a data abbreviation that is used for the entire series.
    2. The + symbol can be used to assign further fields (or series) with a data abbreviation.
  3. Scenarios by Dataselection
    1. Define which data is assigned to which scenario.

The scenarios are applied in the following order of precedence:

  • Scenarios per element of a series
  • Scenarios by Series vor
  • Scenarios by Dataselection

Scenarios In Axis

If the checkbox is activated, the scenarios of the first data series are displayed in the axes if Axis Thickness is greater than or equal to 3 [px].

Scenario Legend 

If the checkbox is activated, a legend with the respective scenarios is displayed in the diagram. These can be changed later directly in the diagram by the user via a dropdown menu.

The scenario legend is only functional in connection with the property "Scenarios by Series".

Scenarios In Deviations

If the checkbox is activated, the scenarios are shown in the deviations.

Scenarios by Dataselection

This property determines which data is assigned to which scenario.

Each configuration has the following properties:

  • Scenario Id: The ID of the scenario to be used. A scenario ID used here, has to be defined in the scenario definition.
  • Filter: The selected scenario is assigned for each dimension member that is selected here using the  sign.
  • Description: Short name describing the configuration to be recognizable.

Selection

Fade Out Opacity

This value determines to what extent chart elements should be hidden that are not selected. The value starts at 0.0 (completely hidden) and goes up to 1.0 (completely visible).

  • No labels