Data storage

The extended properties of the fact cube store the information on which dimensions support dynamic attributes.

For example:

<Alea:DynamicAttributes>
   <Alea:Dimension Name="ATD_Employees">
      <Alea:AttributeCube Name="ATCData_Employees" />
   </Alea:Dimension>
      <Alea:Dimension Name="ATD_Jobs">
      <Alea:AttributeCube Name="ATCData_Jobs" />
   </Alea:Dimension>
   …
</Alea:DynamicAttributes>

This information is stored:

  • Dimension is repeated for each dimension that supports dynamic attributes. The name of the dimension is stored here.
  • AttributeCube is the name of the cube that contains the attribute data.

This additional information is stored on the dynamic attribute cube:

  • Dimension is the name of the dimension that is receiving the dynamic attributes.
  • AttributeDimension is the name of the dimension holding the attributes.
  • DriverDimension is the name of the driver dimension.
  • ApplicabilityAttribute is the name of the attribute that defines if the driver dimension is applicable for this attribute. The default is true.
  • NonApplicableElement is the name of the element that is used in this dimension if the driver dimension is not applicable.
<Alea:DynamicAttributeConfiguration>
   <Alea:Dimension Name="ATD_Employee" />
   <Alea:AttributeDimension Name="ATDAttribute_Employees" />
   <Alea:DriverDimensions>
   <Alea:DriverDimension Name="ATD_Configuration sets">
      <Alea:ApplicabilityAttribute Name="Configuration set_applicable" />
      <Alea:NonApplicableElement Name="N.A." />
   </Alea:DriverDimension> 
   <Alea:DriverDimension Name="ATD_Entities">
      <Alea:ApplicabilityAttribute Name="Entity_applicable" />
      <Alea:NonApplicableElement Name="N.A." />
   </Alea:DriverDimension> 
   …
   </Alea:DriverDimensions>
</Alea:DynamicAttributeConfiguration>