Selecting and Setting Up Data Consumer

A consumer determines an object, to which data will be loaded after a block is calculated.

A data consumer can be selected and set up on the Consumer page in the calculation block editing wizard:

To select and set up a data consumer:

1. Select the data consumer in the drop-down list.
   The following repository objects can be used as a data consumer:

• Standard cube.

• Cube view.

• Virtual cube.

• Automatic cube.

• Time series database.

2. Select calendar role. By default calendar is considered as a calendar dimension and it cannot be used to set filtering or set up calculation formula. To work with calendar as a standard dimension, click the button next to the drop-down list to select a data consumer. Calendar will be displayed in the consumer dimension list and it can be used a standard dimension. To work with calendar as calendar dimension, release the button.

NOTE. Calendar role dimension is available, if formulas are not set for calculation block.

3. Select checkboxes of the consumer dimensions, by which filtering by elements will be executed. Filtering enables the user to calculate only dimension elements. Filtered dimensions are not use in composing block calculation formulas. Formulas are composed only for non-filtered dimensions.

4. Set up filtering by elements for the selected dimension. To do this:

• Click the Set Filter button.

• Double-click the dimension with the main mouse button.

The Set Up Filtering dialog box opens, in which determine data consumer dimension filtering settings.

5. Set up filtering by attribute links for dimension. Filtering reduces the number of elements, by which calculation is executed, based on attribute links.
   To apply this filtering type:

1. Select the dimension.

2. Click the Set Attribute Links button. The Filtering by Attribute Links dialog box opens, in which determine filtering settings. For details see the Setting Up Filtering by Attribute Links section.

As a result, the data consumer in the aggregation block will be set up.

Setting Up Data Consumer Dimension Filtering

Filtering enables the user to calculate only dimension elements. Filtered dimensions do not participate in composing block calculation formulas. Formulas are composed only for non-filtered dimensions.

To select dimension elements, by which a block should be calculated, use the Set Up Filtering dialog box:

See also:

Inserting and Setting Up Calculation Blocks