Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Model scd by using role-playing?

I have this model, but I am unable to find if its “correct”, and what is the technical name for it.

 

I am using Power BI, and for example, I have a Clients table:

 

 

 

 

In my model (cube) I have it twice; I will have tables: Client and Client Current

 

 

Data sources:

The source for Client is  (Select * from client)

The source for Client Current is  (Select * from client where Valid=1)

 

 

 

And of course in my fact I have:

 

 

 

 

What is the name for this setup?  (one connects through client_surrogate key and the other from client_anotherkey)

 

 

 

I could be wrong, but I see SCD type 2 as a subset of ‘Role-Playing dimensions’?

 

1 Reply

  • v-easonf-msft's avatar
    v-easonf-msft
    Community Support

    Hi, Anonymous 

    Not fully sure what is your question.

    Can you tell us a bit more about what exactly you were doing?

    Best Regards,
    Community Support Team _ Eason