Definition of variables

  Previous topic Next topic JavaScript is required for the print function Mail us feedback on this topic! Mail us feedback on this topic!  

A Variable is an object that can have a value. We can use the Variables in expressions (mathematical functions), or we can directly display their values in the selected report file, or we can export it to another system or database using a custom data exporter module.

 

variables

 

The variables can be divided into two basic groups:

constant type variables (the text variables entered by the user and the constant number variables belong to this group)
active variables (quantitative, CSV, ODBC variables)

Constant type variable

The variable represents only a single value, which we assign during entry, or settings (in case of variable entered by the user at the moment of running). This value will not change during the evaluation of the expression; the system will use this value.

Active variable

The active variable is a complex object, which runs a query through a data resource connection (optional ODBC connection, SQL Server, CVS file, etc.) on the basis of the set  parameters, then - also with the possibility of parameterization - performs an operation on the data of the table as a result of the query, and give a single value as result.

We can use the value of the variables for the evaluation of expressions, or directly as the parameter of the output report or the add-in.

 

The types of variables are as follows:

 

Quantity
Constant
CSV
ODBC
String
User Input

 

Example for the entry of the variable:

 

BI_func2