Post reply

SSAS tabular mode Vs SSRS

  • November 20, 2013 at 4:09 pm

    #301561

    Hi,

    If we use SSAS Tabular mode, then don't we need to use SSRS?

    So end users directly user SQL Data tools and work with the data?

    What is the purpose of SSAS Tabular mode?

  • November 21, 2013 at 12:45 am

    #1668036

    Tabular is just like SSAS Multidimensional: it provides an analytic abstraction layerto end users to allow easier analytic reporting and analysis.

    The difference is that Tabular compresses data using column store and that it loads all data into memory.

    You can build reports with SSRS on top of Tabular, or you could use Excel/PerformancePoint/Power View to create dashboards and reports on top of Tabular.

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

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

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