Skip to content

Command Group - Dimension > Formula

Formulas manage calculated structures consisting of items and sums within a dimension. This group contains commands for defining aggregation logic and maintaining formulas through dedicated operations.

CommandDescription
Check Formula InputChecks if a formula input function is valid.
Clear FormulaRemoves all items and sums from a formula. The items of the dimension are not deleted.
Consolidate FormulaConsolidates a formula.
Copy FormulaCopies a formula.
Create FormulaCreates a formula.
Create Formula ItemAdds an item to a formula.
Create Formula SumCreates a formula sum.
Delete FormulaDeletes one or multiple formulas.
Delete Formula ItemDeletes one or multiple formula items.
Delete Formula SumDeletes one or multiple formula sums.
Edit FormulaEdits a formula.
Edit Formula ItemEdits a formula item.
Edit Formula SumEdits a formula sum.
Export FormulaExports a formula to a text file. The text file is saved on the server.
Import FormulaImports a formula from a text file. The text file is loaded from the server.
Set Formula ItemsSets the items and sums of a formula.
Show FormulaShows a formula.
Show Formula ItemShows an item or sum of a formula.
Show Formula ItemsShows the items and sums of a formula.
Show FormulasShows the formulas.