Deploy Tabular Model on Analysis Services instance

SQL Server Analysis Services administrator access is needed to create and configure a new Microsoft SQL Server Analysis Services (SSAS) database and model.

Prerequisites

Only SQL Server 2016 and later versions are supported. You need administrator privileges to create and configure a new Microsoft SQL Server Analysis Services (SSAS) database and model. SSAS must be installed in "Tabular Mode", with a compatibility level of 1200.

Deploy Tabular Model

1. Open the SQL Server Management Studio as an SQL Server Analysis Services administrator user and connect to the target SQL Server Analysis Services database instance.

2. Open the OIS Tabular Model.xmla file in the SQL Server Management Studio.

   note

   If you choose to open a new XMLA query window and copy-paste the XMLA code from a file (for example, using Notepad), some characters and indents, etc. may be omitted, so you may need to perform the undo operation (CTRL+Z) once in order to revert to the exact formatting of the source XMLA file.

3. Check the specifications for the connection to the Omada Data Warehouse database in the section “dataSource\ODW.BI” shown below and ensure that the connection string and credentials are correct.

   

4. Confirm that the role memberships are specified correctly.

   

   note

   The account SRVC_Omada is not fully qualified with a domain name prefix (for example, “DOMAIN1\SRVC_Omada”).

   If multiple SRVC_Omada accounts exist across multiple domains, or if errors occur as a result of the missing qualification, make sure to add the domain prefix to the account specifications (data source and role memberships) in the XMLA file before executing the deployment of the tabular model.

5. Execute the script and confirm that the following result appear:

   <return xmlns="urn:schemas-microsoft-com:xml-analysis">
   
   <root xmlns="urn:schemas-microsoft-com:xml-analysis:empty" />
   
   </return>

6. Enter the password for the SRVC_Omada user, by expanding the Omada Identity database tree in the object explorer and right click the ODW.BI connection to open the properties dialog.

7. Click the ImpersonateAccount value in the Impersonation Info setting and open the dialog for entering the account password.

   

8. In the dialog that opens, ensure that the specific user is selected and enter the account password. Click OK.

   

9. Process the database by right-clicking the database name in the object explorer and selecting Process Database.

10. In the dialog that opens, select the Process Full mode and click OK.

    

11. A processing dialog opens and after completing the processing of the database the dialog should show a single Success status row in the list.

    

12. Restart the SQL Server Analysis Services service.