Applies To: SQL Server 2016
Analysis Services is an analytical database server that hosts Tabular models, multidimensional cubes, and data mining models that you can access from reports, spreadsheets, and dashboards.
Analysis Services is multi-instance, which means that you can install more than one copy of Analysis Services on a single computer, or run new and old versions side-by-side. Any instance you install runs in one of three modes, as determined during setup: Multidimensional and Data Mining, Tabular, or SharePoint. If you want to use multiple modes, you'll need a separate instance for each one.
After you install the server in a particular mode, you can use it host solutions that conform to that mode. For example, a tabular mode server is required if you want tabular model data access over the network.
SQL Server Setup no longer installs the model designers or management tools used for solution design or server administration. In this release, tools have a separate installation, which you can get from the following links:
You'll need both Management Studio and SQL Server Data Tools to work with Analysis Services instances and data. Tools can be installed anywhere, but be sure to configure ports on the server before attempting a connection. See Configure the Windows Firewall to Allow Analysis Services Access for details.
The following list shows you which pages in the SQL Server Installation wizard are used to install Analysis Services.
Select Analysis Services from the Feature Tree in Setup.
On the Analysis Services Configuration page, be sure to select Tabular Mode if you want a Tabular instance. Otherwise, the default is Multidimensional and Data Mining mode.
Multidimensional and Data Mining mode uses MOLAP as the default storage for models deployed to Analysis Services. After deploying to the server, you can configure a solution to use ROLAP if you want to run queries directly against the relational database rather than storing query data in an Analysis Services multidimensional database .
Tabular mode uses the xVelocity in-memory analytics engine (VertiPaq), which is the default storage for tabular models that you deploy to Analysis Services. 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.
Memory management and IO settings can be adjusted to get better performance when using non-default storage modes. See Server Properties in Analysis Services for more information.
SQL Server Setup includes a parameter (ASSERVERMODE) that specifies the server mode. 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 must be less than 17 characters.
All placeholder account values must be replaced with valid accounts and password.
ASSERVERMODE is case-sensitive. All values must be expressed in upper case. The following table describes the valid values for ASSERVERMODE.
|MULTIDIMENSIONAL||This is the default value. If you do not set ASSERVERMODE, the server is installed in Multidimensional server mode.|
|POWERPIVOT||This value is optional. In practice, if you set the ROLE parameter, the server mode is automatically set to 1, making ASSERVERMODE optional for a Power Pivot for SharePoint installation. For more information, see Install Power Pivot from the Command Prompt.|
|TABULAR||This value is required if you are installing Analysis Services in Tabular mode using command line setup.|
Determine the Server Mode of an Analysis Services Instance
Convert an in-memory Tabular Database to DirectQuery in SQL Server Management Studio (SSMS)
Tabular Modeling (SSAS)