Post-Installation Configuration

This guide provides instructions on important procedures that you should do after a successful installation. Please follow the sequence of the procedures to setup the Analysis Server with Single Sign-On.

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

2. Web Site Binding to HTTPS. Use these instructions to create web site 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.

   • Keycloak - Keycloak Admin Console - Application Registration. Use these instructions to register the Analysis Server application to your Keycloak 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.

   • Keycloak - Application Settings Configuration for Keycloak - SSO. Use these instructions to configure the Analysis Server for a successful Single Sign-On authentication using Keycloak 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.

6. 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
   
   
   important

   When using Microsoft SQL Server 2025 (Standard, Business, or Enterprise Edition) as the database server for a fresh installation or an upgrade, compatibility is supported only with the following Analysis Server versions:

   • 10.2.600
   • 9.19.660
   • 9.17.710
   
   

7. 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

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

9. 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 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)

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

11. 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.

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

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

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

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