• Home
  • Modeling for BI
  • DBA
  • Azure
  • SSIS
  • SSAS
  • SSRS - Reporting
  • PBI - Analytics
  • Consulting
  • About
Microsoft Data & AI

SQL Server Analysis Services

Multidimensional Cube Storage Options

5/24/2015

0 Comments

 
I initially compiled this table in a Power Point slide deck when I was studying for my MCSE BI, so most likely the original source is from a Microsoft textbook, but you can also easily find this same information on TechNet. 
(https://technet.microsoft.com/en-us/library/ms174532(v=sql.110).aspx).

I am posting this table for you because I often just want the abbreviated version and I appreciate the table view.
Picture
A few more notes on "cached" vs "DirectQuery", and DirectQuery Properties.
Picture
Picture
0 Comments

    Categories

    All
    Cache
    DBA
    Excel
    Extended Events
    HOLAP
    MOLAP
    Multidimensional
    ROLAP
    Server Mode
    SSAS
    Tabular

    RSS Feed

    Tweets by @SqlServerSME
Powered by Create your own unique website with customizable templates.
  • Home
  • Modeling for BI
  • DBA
  • Azure
  • SSIS
  • SSAS
  • SSRS - Reporting
  • PBI - Analytics
  • Consulting
  • About