Adding a dimension to the model

You can add a new dimension with a default hierarchy to the model. You can use the added dimension to build cubes and publish to OLAP.

  1. Select Dashboards > Data Integrations > OLAP Modeling.
  2. Select the model to which to add a dimension.
  3. In the navigation tree, select Dimensions.
  4. Click Add.
  5. Specify this information:
    Name
    Specify the name of the dimension. After you add the dimension to the model, you cannot edit the dimension name.
    Default Caption
    Specify the caption for the dimension.
    Default Description
    Optionally, specify the description for the dimension.

    A default hierarchy with the same name and caption is suggested. Optionally, you can edit the hierarchy name and caption, and add a description for the hierarchy.

  6. Click Next.
  7. In the Elements Table section, select one of these options:
    Option Description
    Select Elements Table Select the elements table name from the list.
    Create Elements table An elements table is created by the system.
    If you select an elements table, ensure that it has these columns:
    • ID: Required.
    • ElementType: Optional, but recommended to support the full functionality.
    • OrderPosition: Optional, but recommended to support the full functionality.
    • DataSourceID: Optional, but recommended to support the full functionality.
    • ParentID: Optional, but recommended to support the full functionality. Used only if you do not use a separate table for relations.
    • Weight: Optional, but recommended to support the full functionality. Used only if you do not use a separate table for relations.
  8. In the Relations Table section, select one of these options:
    Option Description
    No Relations Table No relations table is used.
    Select Relations Table Select the relations table name from the list.
    Create Relations Table A relations table is created by the system.
    If you select a relations table, ensure that it has these columns:
    • ID: Required.
    • ParentID: Required.
    • Weight: Optional, but recommended to support the full functionality.
    • OrderPosition: Optional, but recommended to support the full functionality.
    • DataSourceID: Optional, but recommended to support the full functionality.
  9. Click Next.
  10. In the Translated Element Captions section, select one of these options:
    Option Description
    No Translated Element Captions No preconditions to use localized element captions are set.
    Translated Element Captions In the Attribute Table field, select an attribute table in which attribute fields for each active application language are created. A column for each language is also added to the elements table to store the attribute values.
  11. In the Security section, select one of these options:
    Option Description
    No Element Security No element security is used.
    Note: You can enable element security later when you manage the dimension properties.
    Select Element Security Table Select the name of the element security table from the list.
    Create Element Security Table An element security table is created by the system.
    An element security table is used to control element access. If you select an element security table, ensure that it has these columns:
    • ID: Required.
    • RoleName: Required.
    • HierarchyName: Optional, but recommended to support the full functionality.
    • Value: Required.
  12. Click Finish.
    The dimension is added to the model. For dimensions that have security enabled, the DAC cube with the #<DimName> name is created.
Related topics