Favorite View data
The Favorite View data is designed to use Favorite Views as the starting point for creating or copying data.
- This functionality is limited Favorite View data works within one version of M3 DMP (unlike Dataset data manager)
- Favorite View data can copy between two Pivot sheets (Grids).
- Favorite View data will copy from the first
period included in the FROM favorite view to the first period in the TO favorite view.
This means if the 2 Favorite Views have different start periods, it gives the opportunity to move data in time.
To run, you must set up these items:
- Configuration
A drop down list that consists of saved configurations or setup which can be selected. It has ellipsis button next to the Configuration name which allows you to edit, delete or copy the configuration.
- Actions
- Options
check box is switched on by default. It marks To Favorite View measure cells as updated to allow it to be exported later in the process. If To Favorite View measure is not to be exported, you can leave the option off.
- From \ To Favorite View
This drop down list consists of favorite view items and their measure. There is an ellipsis button next to the Favorite view drop downs to open a new screen of the view for inspection.
- Distribution
You configure this field for Keys and Periods, when From View is aggregated or has fewer keys than To View.
- Key Distribution - Use this option to break down values from the matched level (text in green in button the detailed key in the To View. Values can be Proportional, Even, Same, and By Measure.
- Periods Distribution - This option
defines how the copy is distributed in periods. Your choices are:
Direct Select this option to copy the first period value in From View to first period of To View and the same for the remaining periods. By Source Measure or By Destination Measure Select these options to copy and distribute values in the same relation as the selected source or destination measure. Redistributed by Source measure This is a special function. When selected, the From View value is not copied but instead, the value in the To View is redistributed using the weight of the source measure.