Post-Installation Configuration

This guide provides instructions on important procedures that you should do after a successful installation of Analysis Server.

If Analysis Server was installed with Single Sign-On (SSO) enabled, complete the SSO-specific configuration steps before proceeding with the common post-installation configuration steps.

SSO-Specific Configuration

Complete this section only if Analysis Server was installed with Single Sign-On (SSO) enabled.

1. Import SSL Certificate. Use these instructions to successfully import a valid SSL certificate.

2. Website Binding to HTTPS. Use these instructions to create website binding to https to host the Analysis Server.

3. Please follow the instructions for application registration for the specific OIDC (OpenID Connect):

   • Azure (Microsoft Entra ID) - Azure Portal Configuration - Application Registration. Use these instructions to register the Analysis Server application to your Azure Active Directory.

   • Zitadel - Zitadel Management Console - Application Registration. Use these instructions to register the Analysis Server application to your Zitadel instance.

   • Okta - Okta Admin Console - Application Registration. Use these instructions to register the Analysis Server application to your Okta instance.

4. Please follow the instructions for application setting configuration for the specific OIDC (OpenID Connect):

   • Azure (Microsoft Entra ID) - Application Settings Configuration for Azure - SSO. Use these instructions to configure the Analysis Server for a successful Single Sign-On authentication using Azure (Microsoft Entra ID).

   • Zitadel - Application Settings Configuration for Zitadel - SSO. Use these instructions to configure the Analysis Server for a successful Single Sign-On authentication using Zitadel instance.

   • Okta - Application Settings Configuration for Okta - SSO. Use these instructions to configure the Analysis Server for a successful Single Sign-On authentication using Okta instance.

5. Administration Tab Access Configuration. Use these instructions to configure users and groups that will have access to the Analysis Server web interface Administration tab.

Common Post-Installation Configuration

Complete the following steps for all Analysis Server installations.

1. Create and Deploy SQL Database. Background processes of the Analysis Server use an SQL Server database. Furthermore, the successful rendering of the web interface requires the creation and deployment of the SQL and OLAP databases.

   • Creating SQL Database
   • Deploying SQL Database

2. Create and Deploy OLAP Database. OLAP database is used to successfully create reports using the Analysis page and some other external reporting tools.

   • Creating OLAP Database
   • Deploying OLAP Database

3. Switch to Columnstore. It is recommended to switch to Columnstore Index to maximize the features and improvements that Columnstore offers.

4. Install and Configure SSRS. Use these instructions to properly set up and configure Analysis Server Reporting Services.

   note

   The Analysis Server service account should have access to the SSRS installation. The System User role is enough.

   • Install SSRS. Perform this step only if SSRS was not installed during the process of meeting the installation requirements for Analysis Server.

   • Configure Reporting Services Settings (ConfigureAll)

5. Verify that the Analysis Server code location is successfully loaded. Follow these instructions:

   a. Access the Data Processing GUI by navigating:

   • With Ingress: https://<ingress-uri>/dagster-webserver or use the link in the navigation menu.

     

     Data Processing GUI Link

   • Without Ingress: http://localhost:27910/dagster-webserver

   b. In the left navigation, click Deployment. Make sure that the Status of analysisserver code location is Loaded.

   

   Analysis Server Code Location

   NOTE

   Click View Error to see the error logs for troubleshooting.

6. Access the Web Interface. After creating and deploying the SQL and OLAP databases, the Analysis Server web interface will be accessible.

7. Set the Core Server Database Path. Use these instructions to set the Core Server database path for Analysis Server data loading.

   warning

   Make sure to locate the configuration key Root.Etl.CoreDatabasePath.

8. Configure Mapping Sources. Use these instructions to set up the mappings for Active Directory information and user to groups mapping.

9. Configure Time Zones. Use these instructions to set up the proper Time Zones to use in processing the data and reporting.

10. Synchronize Core Server Data. Use these instructions to load and process data from the Core Server into the Analysis Server database.

11. Review and Apply HTTP/TLS Recommendations. Use these instructions to apply recommended HTTP/TLS security hardening.