Skip to content

Parameterization

This page shows how to parameterize the Xtract BWCube component using SSIS variables directly in the component and by using SSIS expressions to set Data Flow Properties.

Parameterization using SSIS Variables

SSIS variables store values that an SQL Server Integration Services package and its containers, tasks, and event handlers can use at runtime. The following settings in the Xtract BWCube component allow entry of an SSIS variable:

  • BEx variables: for BEx variables of type Multiple Single, enter a single SSIS variable, set a delimiter for custom property DelimiterForMultipleSSISVariableValues and enter multiple single values in the SSIS variable separated by the delimiter.
  • Dimension Filters: the SSIS variable can be filled with multiple single entries separated by comma.
  • MDXVariable: enter an SSIS variable and fill the SSIS variable with the complete MDX statement.

Use SSIS Variables with @-Notation

To use SSIS variables in input fields of the component, place an @ symbol before the variable name.

  1. Choose an input field that supports SSIS variables.
  2. Instead of entering a fixed a value, enter a variable name using the @-notation, e.g., @vDate.
  3. Create a new SSIS variable with the same name, but without the @ symbol, e.g., vDate.
  4. Make sure to select the correct data type.

You can now use the SSIS variable to set dynamic input values for the input field.

Custom Properties of Xtract BWCube

The Custom Properties are properties that are unique to the component. When parameterizing the component using SSIS variables, the Custom Properties are overwritten.

The Custom Properties of the Xtract BWCube component are displayed in the "Properties" window.

bwcube-properties

CubeName

Corresponds to the setting Cube Name in the Xtract BWCube component.

DelimiterForMultipleSSISVariableValues

Delimiter for multiple input variables, see Parameterization using SSIS Variables.

IgnoreMDXErrors

If set to true, MDX errors do not lead to SSIS errors.

MDXVariable

Enter an SSIS variable in the MDX textbox and fill the SSIS variable with the complete MDX statement, see Parameterization using SSIS Variables.

StringConversion

Corresponds to the seeting String Conversion.

Last update: July 7, 2024