Examples
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 |