Skip to main content
SUBMITTED

Create and maintain conformed dimensions for semantic layers

Related products:TimeXtender Data Integration
  • March 15, 2023
  • 0 replies
  • 30 views

erik.van.mastrigt
TimeXtender Xpert
Forum|alt.badge.img+3

In the current situation many steps for dimensions have to be done for each semantic layer separately, for instance

  • New field in the dimension table in the MDW has to be added manually to all SSL models
  • Descriptions on tables/fields/measures have to be filled manually for each model
  • Idem for sort orders
  • Idem for hidden fields
  • Idem for hierarchies
  • Etc.

It would be a great time saver if some functionality exists where one can

  • Create a dimension based on a MDW-table
  • Apply all properties, descriptions, sortings etc.
  • Be able to reuse this dimension in multiple semantic layers
  • Be able to apply changes to the dimensions to all semantic layers at once.

https://www.kimballgroup.com/data-warehouse-business-intelligence-resources/kimball-techniques/dimensional-modeling-techniques/conformed-dimension/