SAC Data BindingSince our 2024.1.0 release for the SAC, we use the SAC Builder Panel to assign data. As soon as you drag our widget on the canvas, a dialogue opens to assign a model. To then assign measures and dimensions, open the builder panel via the -icon, in our overlay UI or the right side panel in the SAC. If you would like to change the model later, click on the -icon on the right and select the data model you want to use. MeasuresDetermine which measures should be depicted in the graphomate matrix. Now you can also create Calculated Measures within the dialogue. RowsSpecify here which dimensions should be shown in rows. This can now also handle explicit hierarchies. ColumnsSpecify here which dimensions should be shown in columns. FilterHere you can define (background) filters for dimension values. You can now filter within hierarchies and exclude members. Open Property SheetThis button opens our component menu, called the graphomate property sheet (GPS). | |
CalculationDeviationsThis property can be used to calculate deviations. It is a list, where each individual item represents the calculation of a new deviation member. The variances are calculated as follows: Absolute: Minuend - Subtrahend Please note: At this point the values for deviations are only calculated. You have the possibility to visualize these calculated values on the tab "Chart Specific". Deviations Pop-UpYou can create new variances using the sign. Each configuration has the following properties:
Calculated MembersCalculate additional columns, rows or members using formula input. Calculated Members Pop-UpYou can create new calculated members using the sign. Each configuration has the following properties:
You can find a detailed description of the syntax here
N + RestDefine how many elements should be mapped as Top N or Bottom N with Rest representation. N + Rest Pop-Up (Top 3)You can create new groups for N + rest using the - sign. Each configuration has the following properties:
Sort ConfigurationsHere you can sort members of dimensions. Measures are also interpreted as a dimension and can be sorted accordingly. Sort Configurations Pop-upYou can use the sign to create a new sort order for a dimension. Each configuration has the following properties:
Calculated AggregationYou can create aggregations that differ from the standard for certain dimensions. Use this, for example, to create a different aggregations for each column. Calculated Aggregation Pop-Up
Aggregation TypeThe graphomate matrix calculates aggregations for displaying hierarchy nodes, if the host environment doesn’t provide them. Aggregation Node NameAt this point, a separate name can be assigned to the aggregation elements - e.g. "Sum" or Total" or also "Europe". Following Result NodesChange the position of the totals to precede or follow its child nodes. Additional Axes (formerly Hyper Axis) ConfigNew hyper axes can be created here. These are additional axes of the data projection (in addition to the known Columns and Rows axes of a normal, two-dimensional projection). This allows multiple data values to be assigned to a cell of the matrix to display in-cell visualizations, like sparklines, from multiple values. Additional Axes (formerly Hyper Axis) Config Pop UpYou can create new hyper axes using the - sign. Each configuration has the following properties:
| |
Scenario DefinitionThis property determines the appearance of the scenarios - also known as Data Types. Scenario Definition Pop-UpEach scenario has the following characteristics:
Import/ExportCopy this string to use scenarios in other graphomate components. | |
Scenario AssignmentScenarios in Column HeadersThis property ensures that the scenarios are displayed as bars below the column headers. You can use the sign to create assignments of scenarios to dimension members. Scenario Assignment Pop-UpThis property assigns scenarios to data cells. Each configuration has the following properties:
| |
Data SelectionSelection Type Specify how cells can be selected by the user. The following modes are available:
|
Manage space
Manage content
Integrations