Basically, there are two possibilities to maintain the features of graphomate tables: with the Standard Properties Sheet, which lists all parameters in a structured list or with the Additional Properties Sheet. The latter provides a user-friendly interface. There are some special features, which can only be maintained on the Standard Properties Sheet.
The Checkboxes 
next to the features in the Additional Properties Sheet are used to control the visibility of elements.
The chosen Data Source can only be attributed to the component via drag&drop or via the Standard Properties Sheet under Data Binding.
| Info |
|---|
Clicking the F5 key reinitializes the canvas as well as the Additional Properties Sheet. This is sometimes necessary when changes in the Properties are not directly accepted in the canvas. |
|
 |
Data Types TabData Types EditorThis editor is used to define Data Types. The abbreviations can be used on the Data Tab and it is possible to format each element individually. The abbreviations are defined in the column Name. The entered Data Types are automatically converted to uppercase. Color and Fill define the appearance of the elements. Shape changes the appearance of the pin heads of the deviation charts. Navigate via mouse click through the alternative representations and view the changes in the column headers, after you assigned the corresponding Data Type. Width determines the width of the elements and is specified in percentage of the font size. The toggle button %/abs has no effect on the tables. Bold sets the font type of the column header to bold if a Data Type is assigned. With the red button next to Data Type you delete Data Types and with the green one you add new Data Types.
Data Types CSS ExportIf you want to store the defined Data Types in a centrallocation, you can extend your central CSS Stylesheet on the BI Platform accordingly. Just copy the code in the box to the end of your CSS file. Now it is no longer possible to use own Data Types because the central settings are displayed as shown in the example on the right. |
|
|
Column Width
- Auto
In Auto mode the available space (width of the component) is divided equally between the columns. - Fixed
Enter a fixed width for the columns in [px] here.
Use the property Width Per Column in the Standard Properties Sheet to set the width of each column independently.
Hierarchy
Activate the Checkbox Hierarchy to show the hierarchical order of the dimension. If you want to drilldown and roll-up within the hierarchy during runtime, activate the Checkbox Collapsible.
Preceding Hierarchy Nodes controls the position of the totals in the table: above or below the table values.
Expand to Level determine up to which hierarchy level the hierarchy is to be expanded in the start drilldown (starting with level 0).
| Info |
|---|
It’s imperative that external BW-hierarchies used in a Data Source are fully expanded, and all (sub-)totals are displayed. Failure to do so may result in misstatements! |
Suppress Zero Labels
If the Checkbox is activated, all zero values are hidden – both in the table itself and in the deviation charts.
In Cell Charts
Use drag-and-drop to move the desired series from Available Series to Series with In Cell Charts so that bar graphs are displayed in the corresponding columns to visualize the value.
Heatmap
If this option is activated, the value columns of the table are displayed as heat maps, i. e. with a colored background. For this purpose, all values of the table are mapped to a color scale, which can be set under Color Scheme.
In addition, all color scales defined via ColorBrewer can be realized in the Standard Properties. The definition of a color scheme in the Standard Property Sheet consists of two comma-separated parts: The abbreviated color scale (e.g. YlOrRd for "Yellow to Orange to Red") and the number of gradations.
| Warning |
|---|
| Both the In Cell Charts and the Heatmap can cause the bars of different columns to overlap. If this is the case, this is probably due to the fact that the width of the columns has been configured too small. Please check whether an enlargement of the column width (in particular the line title) causes the overlap to disappear. |
Helper Tab
Horizontal Grid Lines
Activate the Checkbox Horizontal Grid Lines to display these. Set the Thickness and Color of the grid lines with the following two parameters.
Sum Borders
Activate the Checkbox in order to display the Sum Borders. You can specify the Thickness and Color of the Sum Borders. With Padding a distance between the sums and the child elements is added.
| Info |
|---|
We recommend to deactivate the option Preceding Hierarchy Nodes (see Behavior Tab) when using the Sum Borders, so that the sums of elements are listed below the values. |
Deviation Axis
In this section adjustments to the Deviation Axis can be done. You can specify the Thickness of the Deviation Axis.
Semantic Axis enables to draw the deviation axis in accordance with the Data Type associated to Data Series2. The Checkbox in front of Deviation Labels controls whether the textual values should be displayed. If this option is deactivated, there are only graphical bars.
Filter Box
In the top left cell of the first row of the graphomate tables we implemented a filter function.
Activate the Checkbox Show Filter Box to make the Filter Box visible for the users. Just enter some letters or regular expressions in the Filter Box and only those table rows are shown that contain these letters. Upper and lower case is not considered.
Exception Position
Exception Position describes where the exceptions are displayed in the table. The conditions for displaying exceptions can be configured via the following Row Format Configuration. Selectable positions are: at the beginning of the cell (leading), before or after the value.
Row Format Configuration
The Row Format Cofiguration enables detailed layouting of rows and columns.
| Info |
|---|
This new layouting feature replaces the Exception Configuration, which could have been found at the same position in previous versions. The Exceptions are now just one of many styles (see below) provided by the Row Format Configuration. |
The Checkboxes in front activate the visibility of each Configuration. Enter a Name for the special Row Format Configuration in the next column. As it will be used internally and for the scripting language you should choose a unique name. Target determines the target column in which the Row Format Configuration should be displayed. Target refers to the index of the column (Target 0 describes the first column containing the row titles).
Apart from setting a single column you can even chose more columns as Target for the used Style. There are two other methods to set a range of columns: The keyword all is used to pick all columns. The second way is to enter a list of explicit column indices separated by comma (e.g. 2,3).
As there are some Styles which are not applied to all columns, please see below if the chosen Style does support layouting all columns.
The Source column is used to calculate or check the chosen Condition. You can pick a column using a single index. Unlike in older versions you can now also choose columns containing titles, attribute or deviations as Source column.
To specify the conditions that lead to the display of an Row Format click on the value under the heading Condition. Select the condition by choosing an Operator and a span.
In addition to the usual mathematical operators for value comparisons, a few other options are available:
- Alert Level
Can be used to take over an alert level from the exceptions of a BW query. Additionally you need to input an alert level index into the text field named 'Value/From' (e.g.: use '1' to apply alert level 'good 1' or '7' to apply alert level 'bad 1') - Contains
Can be used to check if a specific string (which can be specified in Value/ From) is contained with another string. It is also possible to define conditions using regular expressions. - Always
This condition will always be applied, no matter which value is specified. - Hierarchy
Can be used to select hierarchy levels. In doubt, the hierarchy level of a row can be read from the assigned CSS class. - Key
If the key entered in the value field is identical to the key of the source cell, the row format configuration is applied. - Index
Applies the configuration directly to the row with the specified index. It is possible to enter either a single index (3), a comma separated list (1,3,4,5) or a range (1..5).
This Condition together with the Source cell is used to restrict the layouting of the Target cell, so it directly controls if the Style is applied or not.
In order to define the Style of an Row Format Configuration click on the icon under the heading Style and choose between: Exception, Number Format, Data Type, Content Editable, Deviation Color, CSS Class or CSS.
Exception: By clicking Exception you are able to set the Color, the Fill and the Shape of the displayed Exception.| Info |
|---|
The Shape “micro pies” visualizes a part-to-whole relation. The colored part is calculated as the percentage of each cell value of the total value. |
- Number Format:
Choose which Value Format (basic or extended) should be applied to the target column. If you want to use the basic Value Format, it should look like a Number Format according to numeral.js, i.e."0.00a". (13 423 253 → 13.42m) The use of the extended Value Format requires an input statement with this format: "-||,|.|10^6|2|mio" . - Data Type
Draw the notation of the Data Types into the headers. Restrictions: Only works for the row title, so the Target needs to be 0 or all. - Content Editable
Enables the user to change the content of the chosen cell and signals that with a colored background. Changing the cell content triggers the event On Input Changed. - Deviation Color
Offers the possibility to invert the Deviation Color for chosen cells. There is no need for further configurations with this Style. Restrictions: This options only affects columns containing deviations.. - CSS Class
Sets the given CSS class or classes to the chosen cells. More than one class can be set by using a list separated by commas (i.e. class1,class2,class3). - CSS
Applies the given CSS properties to the chosen cells. Restrictions: There is no guarantee that all properties are applied. Some settings like the Text Color can be set in several locations, which may be considered with a higher priority (the setting with the highest priority is applied in the end). The CSS must be specified as follows, making sure that no spaces after the colons and no semicolons are used:A single property: color:red
Several properties at once: color:red,background:grey,font-family:MS Comic Sans
- Text Replacement
Replaces the selected cells with the specified text.
With the red button you delete Row Formats and with the green one you add new ones.
Context Menu Tab
In this tab you will be able to choose which options are available in the context menu. An activated checkbox means this options will be shown. The first checkbox enables or disables the context menu altogether. Once activated the context menu will be accessible during runtime by right clicking on the component. The active operations will be usable as follows.
Sorting
With Sorting data from the available dimensions can be sorted in ascending or descending order.
Filters
Allows you to filter the data by member for all available dimensions.
Context Sensitive Filters
Shows filters corresponding to the currently clicked dimension.
Filter and Hide
In addition to the normal filtering this operation also removes the corresponding dimension from our initial view.
Clear Filters
Resets previously set filters.
Drilldown
Adds another dimension to the component.
Drillup
Removes a dimension from the chart (this can cause an error which makes a reload neccessary).
Zero Display
Sets the way zero values are displayed.
Member Display
Lets you choose the way member names are displayed (text or key).
Position For Totals
Is disabled by default, since this option has no effect on the graphomate tables. Also activating the option has no effect.
Position For Totals affects only the graphomate charts.
Total Display
Enable or disable totals for each dimension.
Custom Events
There are 10 possible events which can be linked to your own scripts. These can be defined in the Standard Properties Sheet and triggered using the corresponding button in the context menu. In the Additional Properties Sheet the names for these buttons is customizable.
| Info |
|---|
All operations are executed directly on the data source, but without changing it. |
A reload resets all changes made with the context menu.
“0” cut the value axis. Retrieve values proposes valid values! Column Width
Use the property Width Per Column in the Standard Properties Sheet to set the width of each column independently. HierarchyActivate the Checkbox Hierarchy to show the hierarchical order of the dimension. If you want to drilldown and roll-up within the hierarchy during runtime, activate the Checkbox Collapsible. Preceding Hierarchy Nodes controls the position of the totals in the table: above or below the table values. Expand to Level determine up to which hierarchy level the hierarchy is to be expanded in the start drilldown (starting with level 0).
Suppress Zero LabelsIf the Checkbox is activated, all zero values are hidden – both in the table itself and in the deviation charts. In Cell ChartsUse drag-and-drop to move the desired series from Available Series to Series with In Cell Charts so that bar graphs are displayed in the corresponding columns to visualize the value. Positive values are colored according to the Positive Color, negative values corresponding to the Negative Color. The bars are provided with a transparency. The strength of the transparency can be influenced by the Bar Opacity (values between 0 and 1 are possible). In addition, you can adjust the height of the bars in relation to the size of the table cell using the Bar Height Factor (values between 0 and 1 are possible). HeatmapIf this option is activated, the value columns of the table are displayed as heat maps, i. e. with a colored background. For this purpose, all values of the table are mapped to a color scale, which can be set under Color Scheme. In addition, all color scales defined via ColorBrewer can be realized in the Standard Properties. The definition of a color scheme in the Standard Properties Sheet consists of two comma-separated parts: The abbreviated color scale (e.g. YlOrRd for "Yellow to Orange to Red") and the number of gradations.
Highlight GroupActivate the Highlight Group to match corressponding bubbles. For detailed information see Runtime Interactivity. |
|
Helper TabHorizontal Grid LinesActivate the Checkbox Horizontal Grid Lines to display these. Set the Thickness and Color of the grid lines with the following two parameters. Sum BordersActivate the Checkbox in order to display the Sum Borders. You can specify the Thickness and Color of the Sum Borders. With Padding a distance between the sums and the child elements is added.
Deviation AxisIn this section adjustments to the Deviation Axis can be done. You can specify the Thickness of the Deviation Axis. Semantic Axis enables to draw the deviation axis in accordance with the Data Type associated to Data Series2. The Checkbox in front of Deviation Labels controls whether the textual values should be displayed. If this option is deactivated, there are only graphical bars. Filter BoxIn the top left cell of the first row of the graphomate tables we implemented a filter function. Activate the Checkbox Filter Box to make the Filter Box visible for the users. Just enter some letters or regular expressions in the Filter Box and only those table rows are shown that contain these letters. Upper and lower case is not considered. Exception PositionException Position describes where the exceptions are displayed in the table. The conditions for displaying exceptions can be configured via the following Row Format Configuration. Selectable positions are: at the beginning of the cell (leading), before or after the value. |
| ||||
Row Format ConfigurationThe Row Format Cofiguration enables detailed layouting of rows and columns.
The Checkboxes in front activate the visibility of each Configuration. Enter a Name for the special Row Format Configuration in the next column. As it will be used internally and for the scripting language you should choose a unique name. Target determines the target column in which the Row Format Configuration should be displayed. Target refers to the index of the column (Target 0 describes the first column containing the row titles). Apart from setting a single column you can even chose more columns as Target for the used Style. There are two other methods to set a range of columns: The keyword all is used to pick all columns. The second way is to enter a list of explicit column indices separated by comma (e.g. 2,3). As there are some Styles which are not applied to all columns, please see below if the chosen Style does support layouting all columns. The Source column is used to calculate or check the chosen Condition. You can pick a column using a single index. Unlike in older versions you can now also choose columns containing titles, attribute or deviations as Source column. To specify the conditions that lead to the display of an Row Format click on the value under the heading Condition. Select the condition by choosing an Operator and a span. When applying comparison operators to data cells, the underlying numerical value is always considered, never the formatted string. For percentage deviations, it is the converted decimal value (50% corresponds to 0.5). In addition to the usual mathmatical operators for value comparisons, a few other options are available:
This Condition together with the Source cell is used to restrict the layouting of the Target cell, so it directly controls if the Style is applied or not. In order to define the Style of an Row Format Configuration click on the icon under the heading Style and choose between: Exception, Number Format, Data Type, Content Editable, Deviation Color, CSS Class or CSS.
With the red button you delete Row Formats and with the green one you add new ones. |
|
Context Menu TabIn this tab you will be able to choose which options are available in the context menu. An activated checkbox means this options will be shown. The first checkbox enables or disables the context menu altogether. Once activated the context menu will be accessible during runtime by right clicking on the component. The active operations will be usable as follows. SortingWith Sorting data from the available dimensions can be sorted in ascending or descending order. FiltersAllows you to filter the data by member for all available dimensions. Context Sensitive FiltersShows filters corresponding to the currently clicked dimension. Filter and HideIn addition to the normal filtering this operation also removes the corresponding dimension from our initial view. Clear FiltersResets previously set filters. DrilldownAdds another dimension to the component. DrillupRemoves a dimension from the chart (this can cause an error which makes a reload neccessary). Zero DisplaySets the way zero values are displayed. Member DisplayLets you choose the way member names are displayed (text or key). Position For TotalsIs disabled by default, since this option has no effect on the graphomate tables. Also activating the option has no effect. Position For Totals affects only the graphomate charts. Total DisplayEnable or disable totals for each dimension. Custom EventsThere are 10 possible events which can be linked to your own scripts. These can be defined in the Standard Properties Sheet and triggered using the corresponding button in the context menu. In the Additional Properties Sheet the names for these buttons is customizable.
A reload resets all changes made with the context menu. |
|
Server TabServer ConfigurationHere you can enter the Server URL to which the component should connect and from which it should retrieve the templates. The hyperlink below the buttons allows you to jump to the admin. Templating ConfigurationIf the current settings are to be saved as a template, a new template name can be entered in the input field with the name Create Template and confirmed by clicking the Save current State button. If the naming convention entered is correct, the template is saved on the server and a toast with the corresponding message is displayed in the lower part of the Additional Property Sheet. However, if the name entered does not meet the expected naming conventions, a toast with the permitted characters is displayed accordingly. Templates stored on the server can be retrieved and applied via the Template List. Just select the desired template and press the Apply button. If you want to delete a template, select the template in the list and press the Delete button. If changes have been made to the templates on the server side, the list must be updated via the Refresh List button. Changes should then be visible. |
|
|
