Data table

Properties

You can assign a name and a description of a data table here, and connect the table to a data source.

Query-type

There are several ways of retrieving information from a database: Queries, procedures, database tables and relations.

Queries
You can create a query yourself here.

Procedures
You can select a procedure from the data source here.

Database table
You can choose a database table from the data source here.

Relations
You can create a data table that is made up of several existing tables here. You can also connect data from different data sources.

Zero value mode
State how fields with ZERO (0) are to be processed/displayed

 

 

Columns

All the columns in the data table are displayed here. You can also add columns manually, with data that you calculate yourself, in addition to the columns that are retrieved using queries. Display: If the column is to be displayed when the data table is displayed on the dashboard. You can also change this when you design the visual element/KPI based on the data table. Refer to separate chapter about this.

Display
Check this if the column should be displayed when creating new visualizations. This can be changed when designing a dashboard.

Table name
The name of the table to which the column belongs.

Column name
Name of the column.

Alias name
Name unique to the column.

Title
The name that is displayed as the column heading. Click on the pencil icon to enter the title as you wish it to appear to the end-user in all the languages that are in the solution..

SQL Data type
The type of data that the value from the database represents.

Data type
The type of data that the value in the column represents.

Allow grouping
State if it is permitted to group data based on this column. In some instances it is not appropriate to allow grouping.

Allow HTML
Wether the colum shall display/render HTML code or just output as text.

Show in grouping
If you the column is visible the the grouping dialog. Goes for both Analyze Editor and when the dashboard is ran (runtime).

Aggregation
How number values are to be processed when the data in the column is grouped. What you define here will be used as the default, but the settings can be changed when you create visualisations, and the end-user can change (but not save) this in the end-user interface.

Chart usage
If any graph should use the data in the column as values or as categories. You can also specify a colour that the column will use on the chart. Click the icon to open a dialog where you can set the colour either by selecting it or typing in values. If you choose automatic, the default colour will be used.

Expression
Opens a dialog box where you can enter an expression using Business Analyze Scripting Engine. For example, an expression can retrieve values from another column and multiply it by a percentage. Refer to separate chapter on Business Analyze Scripting Engine.

Opens a dialog where you can type in an extension to the value displayed in the column (i.e. $ or %). To add an extension after the value, you can just type in the text directly. If you want the extension before the value in the cell, you must type in the extension followed by “[value]”.


Example: $ [value] à$ 100
Example: Nok [value] ,- à Nok 100,-

Use the tag “[columnname]” to insert the name of the column.

 

Parameters
Opens a dialog box where you can state which parameters/filters should be connected to a column. When you have added a parameter, you can state whether the value in the column is to be equal to it (=), less than (<), greater than (>), less than or equal to (<=) or greater than or equal to (>=) the selected parameter.

Opens a dialog where you can configure what to display then the column has empty data points. When you activate empty data points, you must choose what parameter that will get data to fill in the empty data points (as text or value).

 

Calculated columns

Calculated columns are columns that include expressions that are executed in the database. When you click on “Add to the calculated column”, a new row is created in the table below. You can then see the properties that this column will have. The alias name of the column is automatically generated.

Click on the “x” to right of the table to delete the calculated column.

 

 

Caching

It may be necessary to enable caching of the data table in some instances. In many instances, this can increase the speed at which the data is read and displayed to the end user. The drawback is that data that is cached is not in real-time. Therefore, it is important to consider how often data needs to be updated, and set the settings accordingly.

When you enable caching, you can set a series of settings, how often and when the data table should be cached and the columns indexed.

You are also able to see the status of the previous update if caching is active by clicking .

You can specify the frequency of the caching in minutes, days, weeks or months.

Per minute
Select a start date for the caching, and if applicable, an end date, if you wish to stop the caching after a given period of time. Repeat for each one: State the number of minutes between each update. You can also confine the updates to run only on weekdays.

Daily
Select a start date for the caching, and, if applicable, an end date, if you wish to stop the caching after a given period of time. Repeat for each one: State the number of days between each update. You can also confine the updates to run only on weekdays.

Weekly
Select a start date for the caching, and, if applicable, an end date, if you wish to stop the caching after a given period of time. Repeat for each one: State the number of weeks between each update. You can also specify the days in an active week that you wish the updates to run.

Monthly
Select a start date for the caching, and, if applicable, an end date, if you wish to stop the caching after a given period of time. Choose if the update is to run during the specified months, and specify which days in the month (“This month”) or if the update is to run during a specific week in the month, and specify which days of the week (“In this week in this month”)

Indexing of columns
Indexing of columns assist in increasing the speed at which the data is read from the data table. You can add as many indexes as you wish. If you click on “Add to indexing”, a new row is created in the table below. Click on the plus “icon” to add indexed and included columns. Select this option if you want an index to be unique or clustered; only one index can be clustered.

 

Preview

You can view a preview of the data here. The list only displays the first 25 rows.