Properties

Data Tab

Data Series

Here you can link up to 32 Data Series (in the Properties Tab you can link up to 32 Data Series) from the Data Source that you want to display by clicking the corresponding button   and then choosing a column or row in the following window.

The Checkbox next to the Deviation/Series determines its visibility in the table. Change the name of the Deviation/Series by clicking on it. The given names are used as column headers in the table.

Use the input field following the series selection button to enter a Data Type for the Data Series. The selected Data Type will be displayed as a bar beneath the corresponding column header (styled as configured on the tab Data Types). Specified data types are internally converted to capital letters to eliminate problems with faulty inputs.

It’s possible to visualize deviations of two Data Series within the graphomate tables with so called micro charts. The deviation configuration is integrated in this tab: Use the dropdown boxes to choose Data Series for the calculation of deviations according to the formulas on the right. Click the button abs/% to select absolute – visualized by bars – and percentage deviation – visualized by pins.

Note:

If display attributes are added in the initial view these are automatically inserted as additional columns in the table (between the row titles and the actual data). The heading of the attribute column is then the attribute dimension. Showing and hiding the attributes is only possible in the initial view.

The micro charts In deviation columns are formatted automatically according to the chosen Data Type: bar and pin elements use the Data Type of DataSeries1/ACT, the axis – if Semantic Axis is activated on the Helper tab – uses the Data Type of DataSeries2/BUD.

By clicking the green buttons  you are able to add a new Deviation Series or a new Data Series. By clicking the red button  which appears behind each series while hovering over the line, the according series is deleted. Series 1 and 2 are not removed by clicking the delete button, but only cleared in order to assign a new Data Series.  

With the dotted area in front of each line you can drag and drop the according data assignment to a new position. The resulting order is used as a column layout for the table.

Title

Enter a title for your table at this point. If the Checkbox is activated, the Title will be shown. Line breaks are adopted. In addition, the Title can be formatted with HTML tags and (in-line)CSS.

Appearance Tab

Labels

Select the appearance of the font of the table.

Font Size

Sets the font size. The font size influences  implicitly the dimensioning of the table. Therefore parameters are specified in the unit "fs" (font size) in order to be dependent on the font size. Some of these parameter values can be maintained via the Properties.

Font Family

Sets the font family. Choose between Arial, Lucida Console, Tahoma and Verdana via the drop-down box.

Text Color

Sets the color of the text (including the Titel text). If a hierarchy is used within the table, the color defined in the section Hierarchy Nodes (or by the Property Node Style Color) is set for those elements. If a DataType is assigned to a column and the option Apply Data Types to Cells (in the section Columns) activated, the specified color of the corresponding Data Type is applied for the entire column and thus overrules the text color that is specified here.

Value Format

Select the format of the table values:

• Basic: Select the format of the absolute and percentage values according the guidelines of numeral.js.
  Locale sets the label country format in the Basic mode. DE, FR, EN and AUTO are available options. Choosing AUTO the Locale is retrieved from the Data Source.

• Extended: If a fixed format is preferred, put the format for absolute and percentage values here. Choosing a “(“ in the box Negative Sign will show negative values in brackets: (1234). The parameter in the box Scaling is used as a divisor for scaling the data label. The resulting “format string” can also be set via scripting language.

Note:

Set the Use Formatted Data property in the Standard Properties to "true" if you want to show the data according to format of the Data Source.

Hierarchy Nodes

Here you can control Color and font style of the Hierarchy Nodes in the table. The Color overrules the font color set in the section Text Color.

Columns

Show Data Types in Header activates bars in the column headers showing the Data Type. Apply Data Types to Cells sets the color of the corresponding Data Type for the whole column and overrules all other color settings.

Rows

Row headers of the first column can be aligned to the right by activating the Checkbox Title Alignment Right.

Deviations

Set the colors for deviations. If positive deviations between values are not regarded as positive, for example for comparisons of actual vs. budget costs, activate the Checkbox Invert.

Outlier Mode

Choose the appearance of the outliers here. In the mode Short the outliers are shown as small triangles on the axis. In the mode Long they are drawn over the entire available area – according to the rules by IBCS.

Behavior Tab

Scaling

The default Auto scales the table according to the Min and Max-values of all selected data.  

The deviation charts of several tables can be scaled identically by using the same Comparison Group, which is activated by the Checkbox. The Comparision Group will then be shown during design time on the top right corner of the table. That way the Min and Max of the data basis in this group is used.

Comparision Groups are used globally within the BIApp, i. e. also charts in the graphomate charts are scaled identically by using the same Comparison Group abbreviation.

Alternatively it is possible to set the Min and Max scaling values under Manual. Chart Min values > “0” cut the value axis. Retrieve values proposes valid values!

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 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).

Important:

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, the labels of zero values are hidden – both in the table itself and in the deviation charts.

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.

Note:

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.

Excption 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.

Note:

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.
• 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.

Note:

The Shape  “micro pies” visualizes a part-towhole relation. The colored part is calculated as the percentage of each cell value of the total value.

• Number Format: Wendet das gewählte Number Format auf die Selektion an (basic oder extended).
• Data Type: Zeichnet die in den Data Types festgelegte Notation in den Zeilentitel. Einschränkungen: Wirkt nur auf den Zeilentiteln. Als Target muss also 0 oder all gewählt werden.
• Content Editable: Versieht die entsprechenden Zellen mit einem farbigen Hintergrund und erlaubt die Eingabe von neuen Werten. Bei Eingabe eines neuen Wertes wird das Event On Input Changed ausgelöst.
• Deviation Color: Erlaubt die Invertierung der Deviation Color für ausgewählte Zellen. Es sind keine weiteren Konfigurationen nötig bzw. möglich. Einschränkungen: Diese Option hat daher keine Auswirkungen auf Spalten, die keine Abweichungen (Deviations) enthalten.
• CSS Class: Versieht die selektierten Zellen mit einer (oder mehreren) CSS-Klasse(n). Soll mehr als eine Klasse vergeben werden, ist dies durch Eingabe einer kommaseparierten Liste möglich (bspw.: class1,class2,class3).
• CSS: Versieht die selektierten Zellen mit einem oder mehreren CSS-Properties. Einschränkungen: Es ist nicht garantiert, dass alle Properties angewendet werden; das ist abhängig davon, welche anderen Einstellungen in der Tabelle vorgenommen wurden (bspw. ist die Schriftfarbe an drei anderen Stellen konfigurierbar, die jeweils mit einer Priorität versehen sind und bei der die höchst-priorisierte zur Anzeige führt). Das CSS ist wie folgt anzugeben:
  • Für eine Property: color:red
  • Für mehrere Properites: color:red,background:grey,font-family:MS Comic Sans

Über den roten Knopf löschen Sie Row Formats, über den grünen legen Sie weitere an.

Context Menu Tab

In diesem Tab können Sie einstellen, welche Optionen im Kontextmenü angezeigt werden. Aktivierte Checkboxen werden im Kontextmenü angezeigt. Mit der obersten Checkbox kann das gesamte Kontextmenü initial aktiviert werden. Ein aktives Kontextmenü lässt sich zur Laufzeit per Rechtsklick auf die Komponente öffnen und die aktivierten der folgenden Aktionen lassen sich ausführen.

Sorting

Hier lassen sich die Daten für die im Aufriss befindlichen Dimensionen auf- oder absteigend sortieren.

Filters

Ermöglicht die Filterung der Daten nach einzelnen Membern aller Dimensionen.

Context Sensitive Filters

Zeigt korrespondierende Filter zu der Dimension, auf der das Kontextmenü geöffnet wurde.

Filter and Hide

Zusätzlich zum Filtern wird hier auch die dazugehörige Dimension aus dem Aufriss entfernt.

Clear Filters

Ermöglicht das Entfernen von zuvor vergebenen Filtern.

Drilldown

Fügt der Tabelle eine weitere Dimension hinzu.

Drillup

Entfernt eine Dimension aus der Tabelle (dies kann dazu führen, dass die Tabelle nicht mehr angezeigt werden kann).

Zero Display

Legt die Anzeige von Nullwerten in der Tabelle fest.

Member Display

Auswahl der Anzeige der Membernamen (Text oder Key).

Position For Totals

Ist standardmäßig deaktiviert, da diese Option bei den graphomate tables keine Auswirkung hat. Auch eine Aktivierung führt zu keiner Änderung. Position For Totals wirkt sich nur auf die graphomate charts aus.

Total Display

Ermöglicht das Ein- und Ausblenden der Summen der einzelnen Dimensionen.

Custom Events

Über die Standard Properties lassen sich bis zu 10 eigene Skripte festlegen, die über die einzelnen Custom Events aufgerufen werden können. In den Additional Properties können dann eigene Bezeichnungen für die Skripte festgelegt werden.

Hinweis:

Die einzelnen Optionen führen verschiedene Aktionen auf der Data Source aus, jedoch ohne diese zu verändern.

Alle Änderungen lassen sich durch das neu Laden des Dashboards wieder rückgängig machen.

Info Tab

An dieser Stelle finden Sie Hinweise auf die genutzte Version der graphomate tables sowie einen Link, mit dem Sie uns über Fehler und Feature-Wünsche informieren können. Unter Credits finden Sie eine Übersicht der von uns genutzten freien Bibliotheken.