TRUECHART Knowledge Base Live Search
This document describes the first steps on how to use TRUECHART in Jedox.
TRUECHART4JEDOX requires that the TRUECHART Service is installed and accessible from the Jedox environment. Also, you need to define a data range on your worksheet, which has at least two columns that include the TRUECHART configuration.
Add TRUECHART to your worksheet
Add a new custom widget via the top menu by clicking on “Tools” → “Widget” → “Custom Widget…”.
In the upcoming dialog select the HTML radio button in the content field and open the editor.
Paste the following HTML into the editor and hit the save button.
In the source field, select the range where TRUECHART finds its configuration and the data model.
How to configure TRUECHART
TRUECHART reads all of the configurations from the first two columns of the data range. The first column defines the configuration key and the second one defines the value of that specific key.
It is mandatory that you specify at least the service configuration to use TRUECHART. After the initialization process changing that part of the configuration has no impact. When you like the update the configuration afterward, a reload is required.
The configuration parameters are case sensitive. If you add values in the first two columns that are not defined as keywords TRUECHART will ignore that, so commenting your configuration is possible.
TRUECHART4JEDOX needs a connection to the TRUECHART Service to store the defined chart and comments.
The document name identifies the save status in the TRUECHART Service. So the definition of the chart will be used, of the document name.
TRUECHART4JEDOX can not know if you like to update an existing chart definition or if you like to create a new one, so you need to make sure that you use a unique identification to not overriding an existing chart.
The document title is displayed the TRUECHART Management Console for identifying the chart definition.
The document location is the folder to which the chart definition is appended to at the TRUECHART Management Console.
Insert the host on which the TRUECHART Service is running.
The parameter service port defines the port number of the TRUECHART Service. In a default installation that port will be
This parameter defines the path of TRUECHART Service in the URL. In a default TRUECHART installation that is
The user name is used to identify the user to the TRUECHART Service.
Jedox will remove some special characters when it passes data to a custom widget. One of the characters is '\'. So we recommend using the email address as a user name.
To use TRUECHART for charting, you need to specify where the data model can be found. This configuration needs to be added to the first two columns of the data range.
Start defining a data model with the keyword
DataModel and the name of the model. The next two rows have to include the keywords
Measure and the columns where the data is located. We have specified that this first row of the dimension or measure will be used as the name of that specific data column.
Dimensions will be ordered by hierarchy. TRUECHART assumes that the last defined dimension has the lowest hierarchy. TRUECHART takes this column as a reference when preparing the data model for charting.
To define a data column there are 3 different ways:
Adding only one column by defining its id started counting with 1 at the left column. So if your range starts in the column right of the configuration 3 is a valid value.
Adding a range by defining a start and an end column with the '-' sign in between e.g. 3-5 means that it will include the columns 3, 4 and 5.
Combining that two way for multiple ranges and columns e.g. 3; 5-7 will include all columns from 3 to 7 but not column 4.
Make sure that all columns defined for the data range are specified in the TRUECHART widget.
TRUECHART4JEDOX fills up the data model by taking the last defined dimension column as a reference column. If this column has empty fields the whole data row will not be displayed in your chart. In case attributes (Jedox) with empty fields will be used as the last dimension, specified as the lowest hierarchy, resulting in no data will be displayed in TRUECHART.
Adding variables to TRUECHART
To define BI variables you can proceed similar to the data model.
Start defining a variable range by the keyword
Variables. In the next two rows, you need to define in which columns the Name and the Value of the variables can be found. Different from the data model for each of these keywords only one column is supported.