Creating Database Instance in MicroStrategy for MDX Connection

Applies to: Kyvos Enterprise  Kyvos Cloud (SaaS on AWS) Kyvos AWS Marketplace

Kyvos Azure Marketplace   Kyvos GCP Marketplace Kyvos Single Node Installation (Kyvos SNI)

Kyvos supports the MicroStrategy product suite using XMLA/MDX connectivity. Using MicroStrategy, you can create a data source and publish the Kyvos semantic model for analysis.

To create a MicroStrategy Database Instance, perform the following steps.

1. Connect to the Project Source and double-click Administration. Then, click Configuration Managers > Database Instances. This displayed existing database instances (if any), as shown in the following figure.

   Open

   

2. Right-click to access the context menu. Here, click New > Database Instance, as shown in the following figure.

   Open

   

    

3. In the displayed Database Instances dialog box, enter the Database instance name.

4. From the Database connection type drop-down list, select the Microsoft Analysis Services 2012 and 2014 (MDX Cube Provider) or Later option.

5. Click the New button. This displays the Database Connections dialog box with the newly created DSN.

6. Click the Advanced tab, and delete the USE_MTOM mentioned in the Additional connection string. Click OK.

7. Enter the Database connection name in the corresponding field.

8. From the Local system ODBC Data sources list, select the ODBC data source (DSN) that was created for Spark SQL.

9. Click the New. The Database Logins dialog box is displayed.

10. Enter your credentials and click OK. This creates the database instance for the project warehouse.