Expand Dataset data through Menu

  1. Select Menu > Data > Expand Dataset data.
  2. Specify the configuration name of Expand Dataset data and click Save.
    Note: This step is helpful if you run this feature as a workflow.
  3. Select Favorite view for "From" and "Expansion" sections, including its measure.
  4. Select Dataset and data type on "To" section.
  5. To set up values, select an action in the Action list.
    Action

    Select one of these:

    • Distribute by Value. When selected, this action distributes the value of From View measures and placed the data on data type of To Dataset.
    • Copy distribution values. When selected, this action transfers the values of Expansion View measure and placed the data on the data type of To Dataset.
    • Multiply by value. When selected, values in measure of From View are multiplied by values of Expansion View measure and placed on the data type of To Dataset.
    • Copy from value. When selected, values of From View measure are transferred and placed on the data type of To Dataset.
  6. If all arrows are blue and keys are set, click OK to start the expand dataset action.