Expression Editor: Information panel

To set up a formula for calculating calculated fact values, use expression editor window.

Relations Formula

Relations can be used to get values by shifting relative to the current calculation point.

The expression editor window used for setting relation formula looks as follows:

Add a relation

Edit relation

Delete relation

Set up relation formula

The added relations are available for setting up calculated facts.

A calculated fact is a function of values of other facts, calculated facts, or relations.

The expression editor window used for setting calculated fact formula looks as follows:

Create a formula, by which the calculated fact will be calculated.

Setting Formula

A statement is a data element, with which actions during expression calculation are executed.

Statements are displayed on the statements panel in the expression editor.

NOTE. The operands panel in the expression area is displayed only when a calculated element formula is added.

The following are used as statements:

Calculated facts and calculated fields.
Visualizer data source fields:

Data model table fields.
Dimensions of standard cube.

SQL queries added to data model.
Relations added on the Relations tab in the expression editor window.

To insert a statement to the formula area, execute one of the operations:

Using the statements panel:

Select the statement and click the Insert into Formula button.
Double-click on the statement.
Drag the statement to the formula area.

Using the formula area:

Enter statement name in the formula area.
Click in the formula area where a statement should be inserted, press CTRL+SPACE and select the required statement on the popup panel.

To quickly search for fields, start typing part or full field name in the search string. After executing the operation the fields panel displays the fields, which names satisfy search conditions.

To set up displaying of fields, select the option in the drop-down menu of the Display Settings button:

Name. Default value. Only statement names are displayed.
Identifier. Only statement identifiers are displayed.
Name and Identifier. Statement names and identifiers are displayed in the following format: <name> (<identifier>).

To hide the statements panel, click the Hide Statements Panel button, to show the statement panel, click the Show Statements Panel button.

Features of calculated fields use in formulas:

Calculated fields that contain other calculated fields in their formulas are considered as regular calculated fields. Operations identical to operations with regular fields can be executed with these fields: editing, saving, validation, aggregation, adding to visualizers, and so on.
The saved changes of the calculated field are taken into account in calculation of other calculated field or filter based on this calculated field.
If a calculated field has become incorrect, the other calculated field or filter based on this calculated field also become incorrect. Incorrect fields will be hidden on the control panel. Visualizers that are built on data of incorrect fields become incorrect.
When the calculated field used in the formula of other calculated field or filter is deleted, a message is displayed informating that this field cannot be deleted.

A function is a sequence of operations executed with a statement during expression calculation.

A statement is a single operation executed with an operand during expression calculation.

In the expression editor functions and statements can be inserted using the functions panel or entered using the keyboard.

Functions and statements are displayed on the functions and statements panel on corresponding tabs:

To insert a function or statement to the formula area, execute one of the operations:

Using the functions and statements panel:

Select the function/statement. The description panel is displayed. Click the Insert into Formula button.
Double-click the function/statement.
Drag the function/statement to the formula area.

Using the formula area:

Enter the function/statement in the formula area.
Click in the formula area where a function or statement should be inserted, press CTRL+SPACE and select the required function/statement on the popup panel.

To quickly search for a function or statement, start typing function/statement name partially or fully in the search string. After executing the operation the functions and statements panel displays the functions/statements, which names satisfy search conditions.

To hide the functions and statements panel, click the Hide Functions and Statements Panel button, to show - click the Show Functions and Statements Panel button.

To apply the specified formula and close the expression editor window, click the Apply/Save button. The saved formula will be displayed in the formula bar in the Create Calculated Fact or Calculated Fact Settings dialog box.

Formula correctness is checked automatically during its setup. Error text is displayed to the errors panel where the place of error is specified. To put the cursor to the place of error click the errors panel.