Home Forums Data Warehousing Analysis Services How different OLAP vs Dimensional Modeling? Can any one explain RE: How different OLAP vs Dimensional Modeling? Can any one explain

  • OLAP is an acronym for Online Analytical Processing. OLAP performs multidimensional analysis of business data and provides the capability for complex calculations, trend analysis, and sophisticated data modeling.

    Dimensional modeling (DM) names a set of techniques and concepts used in data warehouse design. It is considered to be different from entity-relationship modeling (ER). Dimensional Modeling does not necessarily involve a relational database.

    The 2 are related, but they're 2 different things. To ask how different they are? They 100% different. One should not be compared against the other.



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]