• 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

1 Comment

 
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
1 Comment
Loft Boarding link
2/28/2024 05:37:05 pm

Great insights on optimizing storage for multidimensional cubes! Your breakdown on various options is helpful. Have you explored how loft boarding can enhance storage space for households with limited room? It could be interesting to delve into loft boarding solutions as an efficient storage solution. Looking forward to more discussions on maximizing space utilization.

Reply



Leave a Reply.

    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