• I don't think there is a hard-coded limit.

    But if your number of dimensions is going over 30, you might want to investigate of some dimensions can't be combined.

    Regarding facts: if they are calculated facts based upon other facts in the same table, leave them out. The reporting layer can do that as well.

    If all the facts are valid measurements of your business process, you don't have too many facts.

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