Hp ProLiant DL980 G7 Server Bedienungsanleitung PDF herunterladen (Seite 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.

Figure 35 (page 43) 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

1 2 ... 37 38 39 40 41 42 43 44 45 46 47 ... 81 82

Keine Kommentare

Hp ProLiant DL980 G7 Server Bedienungsanleitung Seite 42