Multiple Dataset Favorite View

The Multiple Dataset Favorite View functionality allows you to consolidate several Datasets into one view in order to see values and changes across Dataset boundaries. The views structure is determined by the master Dataset.

A Master Dataset is the governing Dataset in a Multiple Dataset Favorite View scenario. The measures defined in the Master Dataset controls whatever is displayed in the Favorite View. Only definitions from this Dataset will determine what definitions would be available for a Favorite View.

There are two conditions which need to be fulfilled to work with Master Datasets:

  1. The Period types of the Datasets forming a Multiple Dataset should be identical
  2. At least one key in the Datasets must match, it must be possible to aggregate to the same keys.

Once the master Dataset is selected, you can consolidate additional Datasets with the master Dataset in multiple Dataset favorite view. The keys matching after aggregation, for example, time filter, included measures, etc. defines which Datasets that can be consolidated.

The condition that a Dataset is available to be included in a multiple Dataset Favorite View is now independent from the sequence of keys in the Dataset compared to the master Dataset. The requirements for multiple Dataset Favorite Views regarding the keys in the included Datasets are:

  • There are some common keys in the Datasets
  • Only common are chosen at the aggregation level.

A potential scenario for using Multiple Dataset Favorite View could be when a customer wants to create a Performance Report based on a full overview of all data in the company, and thus need to consolidate several Datasets around specific keys.

The ability to consolidate Datasets depends on aggregation level.

This table displays an example to demonstrate this ability.

Master Dataset Master Dataset Aggregation Level Available Datasets Aggregation Level
K1, K2 K2 K2