MicroStrategy ONE
Accessing data in a document: The dataset
A dataset is a MicroStrategy report that is used on a document. A dataset includes all of the report's elements–attributes, custom groups, consolidations, and metrics. When data is imported from a non-MicroStrategy source in MicroStrategy Web, the data is mapped to define attributes and metrics, and then published as an Intelligent Cube. The Intelligent Cube can be used as a dataset, and its objects used as data on the document.
Datasets provide the data that appears in documents. Datasets define which information the Intelligence Server should retrieve from the data warehouse or cache. This information can include attributes, custom groups, consolidations, and metrics.
These dataset objects are all of the objects from the dataset, regardless of whether they are displayed on the report. For example, if a metric is in the Report Objects but not displayed on the grid, that metric is listed as a dataset object. This type of report is referred to as a subset report. For background information about these subset reports, including the different methods to add them to a document, see Using MicroStrategy OLAP Services reports as datasets.
When you create a new document, you can select the report or Intelligent Cube to use as the dataset. Once the document is created, you can:
-
Add another dataset to the document
-
Replace an existing dataset with another dataset
-
Replace all the datasets in the document with a single dataset
-
Remove a dataset from the document
Multiple datasets
You can create a document with multiple datasets, and you can add more datasets after you create a document. One dataset must be defined as the grouping and sorting dataset; you can group and sort only by the objects on this dataset. For details on how multiple datasets join together in a document, see Using datasets in documents. For instructions to change the grouping and sorting dataset, see Changing the grouping and sorting dataset for a document.
Intelligent Cubes as datasets
An Intelligent Cube is a multi-dimensional cube (sets of data) that allow you to use OLAP Services features on reports, as well as share sets of data across multiple reports and documents. You can use an Intelligent Cube as a dataset, allowing you to use one Intelligent Cube for many different documents, while reducing access to the data warehouse and thus maintaining performance.
When you import data using MicroStrategy Web, the imported data is saved as an Intelligent Cube.
For background information on using Intelligent Cubes as datasets, including how to add a Grid/Graph with an Intelligent Cube as a dataset, see Using Intelligent Cubes as datasets.