Skip to main content
SUBMITTED

Create ‘Master Dimensions’ and Link/Synchronize Them to Semantic Layer / Deliver Instances

Related products:TimeXtender Data Integration
  • November 13, 2025
  • 3 replies
  • 54 views

bas.hopstaken
TimeXtender Xpert
Forum|alt.badge.img+5

It was a bit difficult to come up with a good title for this idea, but I think it could be a very valuable feature. Let me explain what I mean.

In many cases, you build dimension tables in the MDW/Prepare instance that are used in almost every SSL/Deliver instance. Examples include dimensions such as Date, Item, Customer, and so on.

When you add a column to one of these dimensions and want this column to be available in all SSL/Deliver instances, you currently have to add it manually to each one, which can be a lot of work.

It would be great if we could define a kind of Master Dimension and link the SSL/Deliver instances to it. Whenever something is added or changed in this Master Dimension, the update would automatically be applied to all linked SSL/Deliver instances.

3 replies

Forum|alt.badge.img+1
  • Contributor
  • November 14, 2025

This would also save a ton of work with calculationgroups.
I suppose the issue with these would be the field mappings, but maybe this could be resolved with some inspiration from snippets and parameters


andri
Contributor
Forum|alt.badge.img+1
  • Contributor
  • November 14, 2025

I put in a feature request for this six years ago: Copy table structure between semantic models | Community
Lets hope it gets some momentum now :)


  • Contributor
  • December 11, 2025

I think Informatica Powercenter (long time ago) had a ‘Propagate’ option on a column, meaning: add the column to all instances of the table (object). That way you are in control.