Examples

The fact data is stored in the fact cube. This cube contains dimensions which can be categorized as dimensions with dynamic attributes, driver dimensions and other dimensions.

The dimensions with dynamic attributes are the dimensions where the dynamic attributes should be available on the elements. For dimension attributes it would be enough to know the element name and the attribute name to read the attribute value for that element. In the case of a dimension with dynamic attributes the value of the attribute is valid only in the context of a cell. But it does not depend on all dimensions of the cube, but just on the driver dimensions or a subset hereof.

For example, the Employees dimension in the cube and the attribute should be Bonus in %. But in different scenarios (elements of the scenario dimension), an employee has different bonus rates. Therefore, the bonus rates cannot be stored in the dimension attributes.

This table shows the employee bonus example:

Scenario Optimistic
Measure Base Salary
              
Months
Employee Bonus in % January February March
IT 8.300 8.300 8.300
  Claus Mayer 20% 3.000 3.000 3.000
  Reinhold Ebermann 10% 2.500 2.500 2.500
  Thomas Musterman 40% 2.800 2.800 2.800
              
              
Scenario Pessimistic
Measure Base Salary
              
Months
Employee Bonus in % January February March
IT 8.300 8.300 8.300
  Claus Mayer 10% 3.000 3.000 3.000
  Reinhold Ebermann 2% 2.500 2.500 2.500
  Thomas Musterman 10% 2.800 2.800 2.800

Depending on the selection of an element in the scenario dimension, the values of the dynamic attribute changes.

Limitation: The dynamic attribute Bonus in % can only be returned if the driver dimension scenario is in the slicer of the request.

In this example the scenario dimension is in the column header. Therefore, it is not possible to show a value for the attribute as different ones are defined for the different scenarios.

This table shows the scenario dimension example:

Months January
Measure Base Salary
           
Scenario
Employee Bonus in % Optimistic Pessimistic
IT 8.300 8.300
  Claus Mayer 3.000 3.000
  Reinhold Eberman 2.500 2.500
  Thomas Musterman 2.800 2.800