• 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

Finding Your SSAS Installed Server Mode

5/24/2015

0 Comments

 
Picture
You can read up on how to do this on MSDN here (https://msdn.microsoft.com/en-us/library/gg471594.aspx), but below is a quick summary.

The easiest option is to connect to SQL Server Management Studio and note the icon next to the server name in Object Explorer.










An alternative is the read the XML in the MSMDSRV.INI file searching for “DeploymentMode”.
                0 = multidimensional
                1 = PowerPivot for SharePoint
                2 = Tabular

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