MicroStrategy ONE
Select Which Datasets Determine the Dashboard's Available Values
If a dashboard contains multiple datasets, you can decide which datasets determine the values that appear in the dashboard.
Designate a dataset as primary to display all of the values in the dataset, regardless of whether they appear in other datasets. When you add a new dataset to a dashboard, it automatically becomes the primary dataset. You can have multiple primary datasets in a dashboard.
Designate a dataset as secondary to display the dataset's values if they are also available in another dataset. You can have multiple secondary datasets in a dashboard.
A dashboard contains the following datasets:
- Regional Revenue
- Regional Profit
If you place the Region, Revenue, and Profit objects on a grid, all regions appear, even if Revenue and Profit are empty. All the values for the Region attribute appear in the grid because both datasets are, by default, primary datasets.
If you change the Regional Profit dataset to a secondary dataset, its values only appear if the primary dataset, Regional Revenue, contains a value. South does not appear on the grid because the primary dataset, Regional Revenue, does not contain data for the South region. Central appears, even though it does not have any Profit data, since it belongs to a primary dataset. All values appear for primary datasets, regardless of whether they appear in other datasets.
If both datasets are defined as secondary datasets, values only appear when both datasets contain values. Only Mid-Atlantic, Northeast, and Northwest appear, since they contain values in both datasets.
Select Which Datasets Determine the Available Values
- In the Datasets panel, click More
to the right of the dataset and choose Join Behavior. -
Choose Primary (outer join) to display all values in a dataset.
or
Choose Secondary (inner join) to display a dataset's values only if they are available in another dataset.
Related Topics
Introduction to Using Multiple Datasets in a Visualization
Select Which Datasets Determine the Dashboard's Available Values