Create Dataset from MicroStrategy Cube
This article details how to create a Dataset from MicroStrategy Cube Plugin.
PREREQUISITES:
1. Create a New Dataset
Access New > Dataset > Create New
- Measured: Select the measurement interval that applies to the level of aggregation that you want in your result set
- Name: Give the Dataset a descriptive name
- Category: Specify the Category to place the Dataset
2. Complete the Data Tab
- Data Source: Select the MicroStrategy Cube Data Source
- Data collection trigger: Specify the Data collection trigger that will be used to collect data for Dataset
- Cube: Select the MicroStrategy Cube object that should serve as a basis for Dataset
-
Plugin command: Build a query listing all the data you would like to fetch from MicroStrategy Cube
- Build your query in MIQL syntax OR
- Use Visual Editor. This will automatically validate the command
- [Validate]
- [Enable & View]