以表格模式安裝 Analysis ServicesInstall Analysis Services in Tabular Mode

如果您安裝 Analysis Services 以使用新表格式模型功能,則必須在支援該模型類型的伺服器模式下安裝 Analysis Services。If you are installing Analysis Services to use the new tabular modeling features, you must install Analysis Services in a server mode that supports that type of model. 此伺服器模式為表格式,並會在安裝期間設定。The server mode is Tabular, and it is configured during installation.

在此模式下安裝伺服器之後,即可用來裝載您在表格式模型設計師中建立的方案。After you install the server in this mode, you can use it host solutions that you build in tabular model designer. 如果您想透過網路存取表格式模型資料,則需要表格模式伺服器。A tabular mode server is required if you want tabular model data access over the network.

您可以在 [安裝精靈] 或命令列安裝程式中指定表格模式。You can specify Tabular mode in the Installation Wizard or in a command line setup. 下列各節將描述各種方法。The following sections describe each approach.

安裝精靈Installation Wizard

下列清單顯示 [SQL Server 安裝精靈] 中,用來在表格模式下安裝 Analysis Services 的頁面:The following list shows you which pages in the SQL Server Installation wizard are used to install Analysis Services in Tabular mode:

  1. 從安裝程式的 [功能樹狀目錄] 中,選取 [Analysis Services]Select Analysis Services from the Feature Tree in Setup.

    顯示 Analsyis Services 的安裝功能樹狀結構Setup feature tree showing Analsyis Services

  2. 在 Analysis Services 組態 頁面上,請務必選取表格式模式On the Analysis Services Configuration page, be sure to select Tabular Mode.

    使用 Analysis Services 組態選項的 [設定] 頁面Setup page with Analysis Services config options

表格模式使用 xVelocity 記憶體中分析引擎 (VertiPaq),這是您部署至 Analysis Services 之表格式模型的預設儲存引擎。Tabular mode uses the xVelocity in-memory analytics engine (VertiPaq), which is the default storage for tabular models that you deploy to Analysis Services. 將表格式模型方案部署至伺服器之後,您可以選擇設定表格式方案,以使用 DirectQuery 磁碟儲存體作為記憶體繫結之儲存引擎的替代儲存體。After you deploy tabular model solutions to the server, you can selectively configure tabular solutions to use DirectQuery disk storage as an alternative to memory-bound storage.

命令列安裝程式Command Line Setup

SQL Server 安裝程式包含可指定伺服器模式的新參數 (ASSERVERMODE)。SQL Server Setup includes a new parameter (ASSERVERMODE) that specifies the server mode. 下列範例說明在表格式伺服器模式下安裝 Analysis Services 的命令列安裝程式。The following example illustrates a command line setup that installs Analysis Services in Tabular server mode.

  
Setup.exe /q /IAcceptSQLServerLicenseTerms /ACTION=install /FEATURES=AS /ASSERVERMODE=TABULAR /INSTANCENAME=ASTabular /INDICATEPROGRESS/ASSVCACCOUNT=<DomainName\UserName> /ASSVCPASSWORD=<StrongPassword> /ASSYSADMINACCOUNTS=<DomainName\UserName>   

INSTANCENAME 必須少於 17 個字元。INSTANCENAME must be less than 17 characters.

所有預留位置帳戶值都必須取代成有效的帳戶和密碼。All placeholder account values must be replaced with valid accounts and password.

使用所提供的範例命令列語法時,不會安裝 SQL Server Management Studio 或 SQL Server Data Tools (SSDT)SQL Server Data Tools (SSDT) 之類的工具。Tools such as SQL Server Management Studio or SQL Server Data Tools (SSDT)SQL Server Data Tools (SSDT) are not installed using the example command line syntax that is provided. 如需有關加入功能的詳細資訊,請參閱從命令提示字元安裝 SQL Server 2014For more information about adding features, see Install SQL Server 2014 from the Command Prompt.

ASSERVERMODE 會區分大小寫。ASSERVERMODE is case-sensitive. 所有值都必須以大寫形式表示。All values must be expressed in upper case. 下表描述 ASSERVERMODE 的有效值。The following table describes the valid values for ASSERVERMODE.

Value 描述Description
MULTIDIMENSIONALMULTIDIMENSIONAL 這是預設值。This is the default value. 如果您未設定 ASSERVERMODE,伺服器會以多維度伺服器模式安裝。If you do not set ASSERVERMODE, the server is installed in Multidimensional server mode.
POWERPIVOTPOWERPIVOT 此為選擇性的值。This value is optional. 實際上,如果您設定 ROLE 參數,即會自動將伺服器模式設為 1,使得 ASSERVERMODE 成為 PowerPivot for SharePoint 安裝的選用參數。In practice, if you set the ROLE parameter, the server mode is automatically set to 1, making ASSERVERMODE optional for a PowerPivot for SharePoint installation. 如需詳細資訊,請參閱 < 從命令提示字元安裝的 PowerPivotFor more information, see Install PowerPivot from the Command Prompt.
TABULARTABULAR 如果您使用命令列安裝程式,在表格模式下安裝 Analysis Services,則需要此值。This value is required if you are installing Analysis Services in Tabular mode using command line setup.

另請參閱See Also

判斷 Analysis Services 執行個體的伺服器模式 Determine the Server Mode of an Analysis Services Instance
設定 In-memory 或 DirectQuery 表格式模型資料庫的存取權 Configure In-Memory or DirectQuery Access for a Tabular Model Database
表格式模型化(SSAS 表格式)Tabular Modeling (SSAS Tabular)