• You can connect a fact table to as many dimension tables as you like. There's no technical limit on that.

    You just have to make sure that it make sense to link a fact table to a certain dimension.

    There are practical limits though. Having too much dimensions makes it unwieldy to browse through the cube (especially in Excel).

    Personally I try to stay below 15 dimensions, ideally below 10.

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