Create Dataset from OLAP

This article will show you how to create a Dataset using an OLAP plug-in as a Data Source. It assumes that you have already established connectivity to OLAP.

1. Add a New Dataset

Access Content > Datasets

[+ New Dataset] to open the Dataset Editor.

2. Complete Info Tab

  1. Measured: Select the measurement interval that applies to the level of aggregation that you want in your result set
  2. Name: Give the Dataset a descriptive name
  3. Category: Select the category where the Dataset will be placed

3. Complete Data Tab

  1. Data Source: Select the OLAP Data Source from the dropdown menu
  2. Data collection trigger: Specify the Trigger that will be used to collect data for your Dataset
  3. Plugin command: Input an MIQL command listing all data that needs to be fetched from the server
  4. [Validate]
  5. [Enable & View]

4. Create a Report

In the Dataset Viewer access Actions > Build Report. The Report Editor opens in a separate tab. For more information on Dataset Reports creation, refer to Dataset Reports Overview.