Page Comparison

In O3 Designer you can define a group of parameters to use for:

• controlling the build process
• substituting values in the data sources definition

The parameter uses default values, or values assigned during the build.
Defining a build parameter includes declaring:

• the name
• the default value
• the type
• whether it is used in controlling an incremental build

Build parameter types include:

• String
• Date
• Integer
• Double
• Time

Parameter values can be constants or expressions. If you use an expression, the value must begin with an = (equal sign).
Notes

• You can use virtual fields operators and functions in the expression.

For example, you can define a parameter value as:
=today()
and its value is the date of the cube build.

• You can also use previously defined build parameters in parameter values by referencing it as ${parameter}$. For example:

DIR=C:\O3
DIR2=$DIR$\files
In this case, the value of DIR2 is C:\O3\files.

• You can also use a previously defined build parameter in an expression which assigns value to another parameter. Note that you do not enclose the previously defined parameter in $ (dollar signs) when using a parameter within an expression

CURRENT_DATE=today()
TOMORROW=AddDay(CURRENT_DATE, 1)

Use the General tab of the cube properties pane to define build parameters.

...