Script Documentation for graphomate sparklines for SAP BusinessObjects Design Studio
Author: Jeanette Kulka
Rev 1.1 as of July 2016
Introduction
The graphomate sparklines extension supports the SAP Design Studio scripting language. This enables the user to dynamically interact with the add-on during runtime. Script commands include manipulation of the layout or setting of data. This document features a list of all currently available script commands. Please do not hesitate to contact us if any feature is missing. For this, you can use our online form.
Events
The following events are available. User-made scripts can be deposited on the Property Sheet under the group Events.
| Event Name | Description |
|---|---|
| On Element Clicked | Is triggered when the user clicks on an element of the chart at runtime; this event is triggered regardless of whether the zoom popup is enabled or not. In order to allow a drilldown, it is necessary to react on the user input at this point. The return values of the following functions are updated at the moment of the event:
|
Functions
The following functions are available. They can be addressed in the scripting editor of Design Studio. We differentiate between getter and setter functions as they get information from the extension or set its properties.
| Getter Name | Example | Return type | Example Return Value | Description |
|---|---|---|---|---|
getDisplayCategoryLabels() | GRAPHOMATESPARKLINES_1.getDisplayCategoryLabels(); | boolean | true | Returns if Category Labels are displayed or not. In case of true, they are shown, otherwise not. |
getDisplayLeadingValues() | GRAPHOMATESPARKLINES_1.getDisplayLeadingValue(); | boolean | true | Returns if leading values are displayed or not. |
getDisplayOverallRange() | GRAPHOMATESPARKLINES_1.getDisplayOverallRange(); | boolean | false | Returns whether Overall Range and Relative Range are displayed or not. |
getDisplayTrailingValues() | GRAPHOMATESPARKLINES_1.getDisplayTrailingValues(); | boolean | true | Returns if trailing values are displayed or not. |
getEnableRuler() | GRAPHOMATESPARKLINES_1.getEnableRuler(); | boolean | true | Returns whether the vertical helpline is currently activated or not. |
getEnableZoom() | GRAPHOMATESPARKLINES_1.getEnableZoom(); | boolean | true | Returns whether the runtime zoom function is enabled or not. |
getEnableZoomAnimation() | GRAPHOMATESPARKLINES_1.getEnableZoomAnimation(); | boolean | true | Returns whether the appearing of the zoom popup is animated or not. |
getHighlightMinMax() | GRAPHOMATESPARKLINES_1.getHighlightMinMax(); | boolean | true | Returns if maximum/minimum highlighting is turned on or off. |
getIsDataInRows() | GRAPHOMATESPARKLINES_1.getIsDataInRows(); | boolean | true | Returns the current orientation of data interpretation. |
| getSelectedMember(dimension dimensionKey) | GRAPHOMATESPARKLINES_1.getSelectedMember(); | 0D_NWI_RCOD | After the user clicked on a sparkline, this function returns the member of the specified dimension dimensionKey. The member provides different properties such as text, internalKey and externalKey. | |
| getSelectedMemberKey(string value dimensionKey) | GRAPHOMATESPARKLINES_1.getSelectedMemberKey("0D_NWI_RCOD"); | 10274 | After the user clicked on a sparkline, this function returns the Key of the member of the selected dimension dimensionKey. | |
| getSelectedMemberText(string value dimensionKey) | GRAPHOMATESPARKLINES_1.getSelectedMemberText("0D_NWI_RCOD"); | North West | After the user clicked on a sparkline, this function returns the text of the member of the selected dimension dimensionKey. The return value is similar to the function getSelectedMemberKey(). | |
getSelection() | GRAPHOMATESPARKLINES_1.getSelection(); | {} | Returns the selection currently in use. If “{}“ is returned that means that the complete resultset is used to generate sparklines. | |
getTitle() | GRAPHOMATESPARKLINES_1.getTitle(); | Switzerland,%202015%0A | Returns the current title of the sparkline component. | |
getZoomDuration() | GRAPHOMATESPARKLINES_1.getZoomDuration(); | 2000 | Returns the current duration of the zoom animation in ms. |
| Setter Name | Example | Description |
|---|---|---|
| setDisplayCategoryLabels(boolean value) | GRAPHOMATESPARKLINES_1.setDisplayLeadingValues(true); | Governs the display of leading values (the first data point of each individual sparkline). |
| setDisplayOverallRange(boolean value) | GRAPHOMATESPARKLINES_1.setDisplayOverallRange(true); | Governs whether Overall Range and Relative Range in the sparkline background are displayed. |
| setDisplayTrailingValues(boolean value) | GRAPHOMATESPARKLINES_1.setDisplayTrailingValues(true); | Governs the display of trailing values (last data point of each individual sparkline). |
| setEnableRuler(boolean value) | GRAPHOMATESPARKLINES_1.setEnableRuler(true); | Switches the vertical helpline on or off. |
setEnableZoom(boolean value) | GRAPHOMATESPARKLINES_1.setEnableZoom(true); | Switches the runtime zoom function on or off. |
| setEnableZoomAnimation(boolean value) | GRAPHOMATESPARKLINES_1.setEnableZoomAnimation(true); | With this function, the animation of the zoom popup can be switched on or off. If false is passed, the zoom popup will appear directly, without animation. |
setHighlightMinMax(boolean value) | GRAPHOMATESPARKLINES_1.setHighlightMinMax(true); | Switches the highlighting of maximum/minimum values on or off. |
setIsDataInRows(boolean value) | GRAPHOMATESPARKLINES_1.setIsDataInRows(true); | Governs the orientation of data interpretation. If true is passed, the selection will be interpreted as rows, in case of false, sparklines will be generated from the selection‘s columns. |
| setSelection(string value) | GRAPHOMATESPARKLINES_1.setSelection(“{}“); | Sets the selection to the passed string. If “{}“ is specified, the complete resultset will be used to generate sparklines. |
| setZoomDuration(float value) | GRAPHOMATESPARKLINES_1.setZoomDuration(2000); | Sets the duration of the zoom animation. Parameter needs to be passen in ms. |