HP ProLiant DL980 G7 Server User Manual
Page 42
Server modes (Multidimensional Mode, Tabular Mode, Sharepoint Mode)
When installing SQL Server Analysis Services (SSAS), you can configure one of the following three
modes of operation for Analysis Services:
•
Multidimensional Mode
Analysis Services provides online analytical processing (OLAP) and data mining functionality
for business intelligence applications. Multidimensional and data mining solutions use OLAP
modeling constructs (cubes and dimensions, availability of which requires setting up Business
Intelligence [BI]). This mode is the default mode. If you install Analysis Services using default
values, you get an instance that runs in this mode.
•
Tabular Mode
Tabular solutions use relational modeling constructs such as tables and relationships for
modeling data, and they use the xVelocity in-memory analytics engine for storing and
calculating data. When you choose Tabular mode during installation of Analysis Services,
the xVelocity engine is enabled. You can then author and deploy tabular model projects by
using the Analysis Services Tabular Project, Import from PowerPivot, or Import from Server
project templates in SQL Server Data Tools. xVelocity is not available with Analysis Services
Multidimensional and Data Mining solutions.
This mode is supported only with SQL 2012 or later versions.
•
Sharepoint Mode
This mode enables PowerPivot, a self-service BI solution that lets business analysts build an
analytical data model inside a Microsoft Excel workbook using the PowerPivot for Excel add-in.
PowerPivot also uses the xVelocity 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. You can configure this mode while installing SQL Server Analysis Services
(SSAS).
This mode is supported only with SQL 2012 or later versions.
shows a portion of the SQL Server page displaying the Analysis Services
mode types (information for the instances is not seen in this view; to display the information, click
the expand
button next to each instance name).
42
Using HP ESO