Orphans in DMR

[esar]

Hi,

I am working on a DMR model with DQM enabled. For those keys in fact table that are not present in dimension tables, the measures are aggregated under orphan categories in transformer. But in DMR approach the orphan categories are not created.
Is there a way to enforce DMR model to create orphan categories. 

[navissar]

You could use some sort of an RI mechanism, where you add a "Unavailable" category in the dim, and assign it to the unmatched keys in fact.
DMR is basically relational, so we need to come up with relational solutions.  :)

[blom0344]

Why the orphaned keys in the first place? Normally fact table keys would be created by looking up the corresponding key from the dimension. So why do you have missing dimensional keys?