SQL Server 2014 Enterprise Edition: Server Setup: Analysis Services Configuration

Although the default option is "Multidimensional and Data Mining Mode" Microsoft actually recommends for new projects "Tabular Mode". According to the Model Features overview Multidimensional supports all features. Microsoft offers a white paper on choosing a Tabular or Multidimensional Modeling Experience in SQL Server 2012 Analysis Services.

  • Tabular Mode

    Tabular solutions use relational modeling constructs such as tables and relationships for modeling data, and the in-memory analytics engine for storing and calculating data.

    Because tabular is the newer solution, you might think that migrating an existing multidimensional solution to a tabular format is the correct course of action, but this is usually not the case. Tabular does not supersede multidimensional, and the two formats are not interchangeable. Unless you have a specific reason to do so, do not rebuild an existing multidimensional solution if it is already meeting the needs of your organization.

    For new projects, consider the tabular approach. It will be faster to design, test, and deploy; and it will work better with the latest self-service BI applications from Microsoft.

  • Multidimensional and Data Mining Mode

    Multidimensional and data mining solutions use OLAP modeling constructs (cubes and dimensions) and MOLAP, ROLAP, or HOLAP storage.

  • PowerPivot (Excel/SharePoint) Mode

    PowerPivot is a self-service BI solution that lets business analysts build an analytical data model inside an Excel workbook using the PowerPivot for Excel add-in. PowerPivot also uses in-memory analytics engine within Excel and on SharePoint. Because PowerPivot solutions use Excel for both data modeling and rendering, deploying a workbook on a server for centralized and controlled data access requires SharePoint and Excel Services.

Source:
Comparing Tabular and Multidimensional Solutions (SSAS)

Keywords:
Setup, Installation, Analysis Services, Analysis Services Configuration, Server Mode, Multidimensional and Data Mining Mode, Tabular Mode, SQL Server, SQL Server 2014, Microsoft

Comments

Post a Comment

Popular posts from this blog

SQL Server Setup: Windows Firewall warning (Ports)

Image
What was it again SQL server setup throws out, when you have your Windows Firewall on?! Rule "Windows Firewall" generated a warning. The Windows Firewall is enabled. Make sure the appropriate ports are open to enable remote access. See the rules documentation at http://go.microsoft.com/fwlink/?LinkId=94001 for information about ports to open for each feature. Keywords: Setup, Firewall, Ports, SQL Server, Microsoft
Read more

SQL Server 2014 Enterprise Edition: Server Setup: Feature Selection

Note: Still needs Microsoft .NET Framework 3.5. Instance Features The configuration and operation of each instance feature of a SQL Server instance is isolated from other SQL Server instances. SQL Server instances can operate side-by-side on the same computer. Database Engine Services Includes the Database Engine, the core service for storing, processing and securing data. The Database Engine provides controlled access and rapid transaction processing and also provides rich support for sustaining high availability. The Database Engine also provides support for the utility control point in the SQL Server Utility. Only Database Engine Services and Analysis Services can be clustered. SQL Server Replication Includes a set of technologies for copying and distributing data and database objects from one database to another and synchronizing between the databases for consistency. You can use replication to distribute data to different locations, and to remote a
Read more

How to read an assembly.dll.config

There is the common misconception that only a app.exe.config can be read in .NET C#. The truth is that the app.config is automatically read, while any other (correctly formed) app.config XML file can be read "manually". To open a named config file: Reference System.Configuration.dll assembly Using System.Configuration Create code like: Configuration GetDllConfiguration(Assembly targetAsm) { var configFile = targetAsm.Location + ".config"; var map = new ExeConfigurationFileMap { ExeConfigFilename = configFile }; return ConfigurationManager.OpenMappedExeConfiguration(map, ConfigurationUserLevel.None); } Sources: stackoverflow: Reading dll.config (not app.config!) from a plugin module Keywords: .NET, C#, app.config, dll.config, ConfigurationManager
Read more