Schema and MDX

The MDSCHEMA_PROPERTIES schema has been extended to list the dynamic attributes. A value of 16 in the PROPERTY_TYPE column marks a dynamic property.

The MDSCHEMA_DIMENSIONS schema has been extended by these columns:

  • DYNAMIC_ATTRIBUTE_TYPE

    This gives information if the dimension is connected to dynamic attributes. These are the possible values:

    • Dimension with dynamic attributes (1)
    • Driver dimension for at least one driver dimension (2)
    • Other dimension (0) - default
  • DYNAMIC_ATTRIBUTE_CUBE

    The name of the cube that holds the dynamic attribute values for a dimension with dynamic attributes

The dimension properties in MDX have been extended so that dynamic attributes can be returned as dimension properties. This works only in the case that the driver dimensions are in the slicer of the calculation, hence in the where clause. If the dimension is not mentioned at all in the MDX statement this is fine, as in that case the default element specifies the context on that dimension.

The MDSCHEMA_CUBES schema has been changed. The CUBE_TYPE column currently holds information like TAC, DAC, MDAC and USER. This has been extended by the type ATTRIBUTE to mark attribute cubes.