For each row in a fact table I have a Client Key and a Final Client key.
(‘Final Client’ is sort of a ‘Parent’ of a ‘Client’.)
In the backend I only have the Fact table and DimClient.
Fact:
- Client Key
- Final Client Key
Client:
- Client Key
I always join to Client… I use Client or Final Client Key depending on what I want to retrieve…
I am trying to model it in SSAS to later consume it from excel and/or power bi…
My question is: what is more performant and better in terms of modeling… To consume DimClient twice in SSAS, one as Client and one as Final Client (and then create 2 different relationships). Or is it better to consume DimClient once, and then use a calculated table to create Final Client?