Skip to main content

Edit Fields

Fields in a cube define the dimensions and measures available for analysis.
You can edit an existing field to rename it, change its type between dimension and measure, or remove it. You can also create calculated fields that derive new values based on scripts and existing data. When you add or edit a field, it appears in the Dimensions and Measures Fields List on the right side of the Data Source Editor.

Edit a field​

  1. In the Dimensions and Measures Fields List on the right, right-click the field you want to modify.
  2. Select Edit Field.
  3. Update the description name if needed.
  4. Change the type between Dimension and Measure.
  5. Click Save.
  6. In the Options panel, select Save Data Source.

Add a calculated field​

  1. In the Dimensions and Measures Fields List on the right, click Add Calculated Field.
  2. Complete the calculated field builder properties and build the expression.
  3. Click Validate to check if the SQL Syntax for the calculation is correct.
  4. Click Save.
  5. In the Options panel, select Save Data Source.

Calculated field builder​

FieldDescription
DescriptionText label for identifying the calculated field.
TypeField category, either dimension or measure.
Type.NET data type to store the calculated field result.
ScriptExpression used to calculate the field value.
Code helpersTool buttons above the script editor that insert operators, brackets, or keywords quickly.
Scripts KeywordsTabs that group building blocks for your expression:

  • Functions – Perform standard calculations or data transformations using math or text functions.
  • BI Functions – Apply business intelligence logic, such as period-over-period comparisons or trend analysis.
  • Statements – Control the logic and structure of your expression such as CASE for conditional rules.
  • Operators – Add, compare, assign, or combine values using logical or arithmetic symbols.
  • Constants – Insert fixed values that do not change, such as numerical thresholds or static text.
  • Objects – Use advanced elements such as Hyperlink or special script functions to enhance interactivity or dynamic output.
TablesList of tables available in the data source to use in the script.
OthersAdditional elements such as:

  • Global Variables – Predefined global values.
  • Special Variables – Context-sensitive or system-generated values.
ValidateAction that checks whether the script is correctly written and executable.