Google
 

Thursday, August 21, 2008

Associations - Add new members

When you create an Association and there is no corresponding dimension mapping in target, you need to select all of the source dimension members. There is a Select All option, however this just creates a list of members to copy.

What happens when you add a member to the dimension? You need to update the association.

Instead of going into the modeler, this appears that it can be automated by adding to the AssociationDimensionScope table with some creative NativeSQL rules to pull from an associated D_ dimension table by label for labels not in the association. Or you could create a trigger on the dimension table... but triggers can cause problems so this isn't recommended.

Apparently this will be adjusted in a later version currently in testing to convert associations to PEL language, allowing for .members syntax rather than hard-coded associations.

No comments: