SSAS 2008R2 Dimension Usage Query

  • This should be a Regular relationship.

    The composite key could give troubles though.

    I think it is best to introduce surrogate keys between those tables. It will make configuration a lot easier.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • The composite key could give troubles though.

    I think it is best to introduce surrogate keys between those tables. It will make configuration a lot easier.

    Normally I don't add something just to say I agree, but this point is so important, I want to reinforce it. I would even say the use of anything other than surrogate keys in dimension tables is not a sound design.

Viewing 2 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply