MicroStrategy ONE

MicroStrategy for QlikView

This connector allows you to retrieve datasets from cubes and reports in MicroStrategy and inject them into QlikView. You can import datasets with up to two million rows and 10+ columns.

All users attempting to the QlikView connector in MicroStrategy 2019 Update 2 must be assigned the Use Application Qlik privilege, directly or as part of a User Group or Security Role. This privilege can be found in the Client-Application-Qlik privilege group.

You must enable CORS (Cross-Origin Resource Sharing) settings on the Library server to use the connector.

Install the Connector

  1. Download and extract the connector zip file.
  2. From File Explorer, go to C: > Program Files > Common Files and create a new folder labeled QlikTech.
  3. Create a new folder labeled Custom Data inside the QlikTech folder from step 2.
  4. Place the extracted connector file inside the new Custom Data folder.

Use the Connector

  1. Open a new QlikView document and select File > Edit Script.
  2. Open the Database drop-down and select QvMstrDatasetConnector.exe.

  3. Click Connect. The Connect to MicroStrategy Dataset window will appear.
  4. Enter your API Server URL and environment credentials.

    Your REST API URL is your environment URL with /MicroStrategyLibrary/ added at the end.

  5. Click Connect to Server.
  6. Select a project and dataset to import into Qlik.

  7. Click Select Dataset.
  8. Select the objects and filters you want to import.

    This feature is only available for cubes. If you choose to import a report, you will be asked to proceed to the Data Preview tab.

  9. Click Generate Preview. You will be shown the first 50 rows of data from your import.

  10. Click Finish.
  11. Click Select from the Data tab to generate a select statement.

  12. Confirm the attributes you want to import from the Create Select Statement window and click OK.
  13. Click Reload.

  14. Select the fields you want displayed the Listboxes from the Sheet Properties window and select OK to complete the import.

You can update the dataset at any time with the connector by going to File > Reload from your QlikView menu bar.