You can assign a name and a description of a data table here, and connect the table to a data source.
There are several ways of retrieving information from a database: Queries, procedures, database tables and relations.
You can create a query yourself here.
You can select a procedure from the data source here.
You can choose a database table from the data source here.
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
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.
Check this if the column should be displayed when creating new visualizations. This can be changed when designing a dashboard.
The name of the table to which the column belongs.
Name of the column.
Name unique to the column.
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.
The type of data that the value in the column represents.
State if it is permitted to group data based on this column. In some instances it is not appropriate to allow grouping.
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).
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.
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.
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.
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 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.
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.
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.
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.
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.
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.
You can view a preview of the data here. The list only displays the first 25 rows.