Star- and Snowflake Schema in MOLAP

  • ktflash

    Ten Centuries

    Points: 1144


    the difference between Star- and Snowflake obviously makes a difference in performance for ROLAP models and for processing

    time of dimensions in a MOLAP model.

    My question is, does it matter for MOLAP cubes (other than processing the dimensions)?

    Has the cube to do these joins aswell, when requested from the cube or is the data structure totally different

    Not sure how the  SSAS Cube MOLAP engine works inside, if i have a big dimension with many attributes, does the normalization matter when data requested from the cube?


    I want to be the very best
    Like no one ever was

  • Site Owners

    SSC Guru

    Points: 80373

    Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

  • heb1014

    Hall of Fame

    Points: 3790

    Hello.  Consider some research into SSAS Tabular.  One big feature of Tabular is that the model does not need to be star or even snowflake.  Tabular is all in-memory and the data are structured differently than in the relational engine.

    Plenty of documentation out there.  Best wishes!


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

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