currently it's possible to define the default relation type at Project level.
However, we use relations differently in DSA and MDW :
- in DSA we setup relations with warnings on business keys and use those relations in lookups
- in MDW, where we do SK-lookups, we don't setup relations and set the join-condition in the lookup (we always use history dimensions).
- in MDW, we do create relations on the surrogate keys (also role-playing), but these should be of the type 'relation only'. These relations make the setup of the semantic layer easier because TX will suggest the relation.
So, for these reasons we'd like to setup the default relation type on the database :
- DSA : relation with warning
- MDW : relation only
Can this be implemented ?