Creating a Plan from a Data Source

You can create plans from data in Analytics. This can be useful when you want to use existing data to create new plans. For example, you might want to use this year's actuals to create next year's budget.

WorkGrid uses input data sources to establish a link between the plan and the Analytics dataset. Before creating the plan, you must create and configure the data source for the dataset that you want to use to create the plan.

Note:

To create a plan with data from Analytics, you must:

  • Be assigned the CRM Analytics Platform User permission set.
  • Have access to the Analytics dataset that you want to use to create the plan.

To create a plan from a data source:

  1. From the Plans tab, click New. The New Plan wizard displays.
  2. Select Data Source.
  3. Click Next.
  4. Enter a unique name for the plan.
  5. [Optional] Enter a description for the plan.
  6. Search for and select the data source that is linked to the Analytics dataset you want to use to create your plan.
  7. [Optional] Select the Delete Obsolete Plan Data checkbox to delete obsolete dimensions, measures, cell values, adjustments, and comments from the plan when you run the Update from Analytics process. For more information, see Updating a Plan with the Latest Data from Analytics and Mass Update From Analytics Process.
  8. [Optional] Search for and select a rate table to link to the plan.
  9. If you intend to use a measure that is not linked to a unit of measure and all the values of the measure in the plan have the same unit, select the dimension that contains the code of the unit in the Default Unit Dimension field. For example, the dimension might contain the ISO code of the currency that the values are in. Otherwise, leave the Default Unit Dimension field empty.
  10. [Optional] In the Output Data Source field, search for and select an output data source.
  11. Click Next. The Configure Plan Filters page of the wizard displays. This page enables you to define the filters applied to the dataset when retrieving data from Analytics.

  12. [Optional] Define the dataset filters. To do this:

    1. Search for and select the dimension whose values you want to filter.
    2. Select the operator used when applying the filter. For more information about the available options, see Operators.

    3. Depending on the operator that you selected, do one of the following:

      • If you selected "Equals" or "Does Not Equal", search for and select the values.
      • If you selected "Contains", "Does Not Contain", or "Starts With", enter the value that you want to use.
      • If you selected "Is Null" or "Is Not Null", proceed to the next step.
    4. To add more filters, click Add Filter and then repeat steps a-c.
    5. Select the filter logic you want to use to filter the data from a data source. For more information about the available options, see Filter Logic Options.
    6. If you select Custom Logic, define the logic you want to apply by entering a value in the Custom Logic field. For more information, see Custom Logic.

  13. Click Next. The Build a Plan page of the wizard displays. This page enables you to set up the structure of your plan. After you add a dimension and a measure, a preview of the plan structure displays.

    Note:

    Only the dimensions and measures that are mapped to the data source are available.

  14. Define the plan table view. This determines whether the plan table displays as a treeClosed One of the available plan table views. Tree view establishes a hierarchy by grouping together rows that contain the same row-level dimension values, starting from the top level. You can only reorder rows within their respective groups. Tree view is suitable for plans that contain rows with a clear hierarchy. or a gridClosed One of the available plan table views. Grid view displays row-level dimensions as a standard table, populating each dimension value in each row. You can reorder rows without restrictions. Grid view is suitable for plans that contain rows without a clear hierarchy and plans where the hierarchy is not important.. For more information about the available views, see Plan Table Views.

    Do one of the following:

    • To display the plan in grid view, under Table View, select Grid.
    • To display the plan in tree view, leave Tree selected.

  15. Define column-level dimensions. For more information, see Column and Row Dimensions. To define column-level dimensions:

    1. From the Dimensions panel, drag the dimension that you want to use as the top-level column group, for example, Year, and drop it into the Columns section.

      Tip:

      Instead of dragging and dropping, you can click Show Menu next to the dimension name and then click Add to Plan.

    2. Repeat the previous step to add more column-level dimensions, for example, Quarter, Period, and so on.
    3. If required, drag the dimensions to your required position within the Columns section to reorder them.

  16. Define row-level dimensions. For more information, see Column and Row Dimensions. To define row-level dimensions:

    1. From the Dimensions panel, drag the dimension that you want to use as the first-level row dimension, for example, Company, and drop it into the Rows section.

      Tip:

      Instead of dragging and dropping, you can click Show Menu next to the dimension name and then click Add to Plan.

    2. Repeat the previous step to add more row-level dimensions, for example, Trial Balance 1, GLA, and so on.
    3. If required, drag the dimensions to your required position within the Rows section to reorder them.

  17. Define measures. To do this:

    1. Click the Measures tab to display the Measures panel.

    2. If you configured the plan to display as a grid, under Measures Position, do one of the following:

      • Leave Columns selected to display measures as columns.
      • Select Rows to display measures as rows.

      For more information, see Measures Position.

    3. From the Measures panel, drag the first measure that you want to use, for example, Dual, and drop it into the Measures section. A preview of the plan now displays.

      Tip:

      Instead of dragging and dropping, you can click Show Menu next to the measure name and then click Add to Plan.

    4. Repeat the previous step to add more measures, for example, Home and so on.

  18. If you want your plan to have a measure pair, define the measure pair. For more information about measure pairs, see Measure Pairs. To define a measure pair:

    1. In the Measures section, next to the name of the measure you want to mark as primary, click Show Menu and then click Mark as Primary Measure.
    2. In the Measures section, next to the name of the measure you want to mark as secondary, click Show Menu and then click Mark as Secondary Measure.
    Warning:

    If the two measures have different units of measure, the plan must be linked to a rate table that contains the relevant conversion rates. If you haven't done so already, go back and select a rate table.

  19. Click Next. The Configure KPI Summary Cards page of the wizard displays. This page enables you to configure KPI summary cards to be displayed in your plan.

  20. [Optional] Configure a new KPI summary card. To do this:

    1. Click Create and configure custom KPI summary cards. to display the New KPI Summary Card window.

    2. Add a formula. To do this:

      1. Click inside the Formula Builder bar.
      2. Click Switch to Builder Mode.
      3. Click Add Function. This adds a new segment to the formula.
      4. Select the function type. For more information about the available types, see Functions.
      5. Select the filters that you want to apply and click Done.
      6. For the first filter that you selected, leave "=" selected to include the value that you select in the next step. Otherwise, select "!=" to exclude the value but include all other values.
      7. Select the value that is included or excluded by the filter.
      8. Repeat steps vi and vii for all the remaining filters that you selected.
      9. If the plan contains multiple measures, select the measure that you want to include or exclude.

    3. [Optional] Add a numeric value. To do this:

      1. Click Add Value. This adds an operator and a new segment.
      2. Select the mathematical operation that you want to perform between the two segments. For more information about the available operators, see Operators.
      3. Enter a numeric value.
    4. Click Apply.
    5. Enter a title.

    6. [Optional] Select a unit of measure. Select Default Plan Unit if you want the summary card to display the plan's default unit of measure. If no option is selected, the summary card won't display any units of measure.

      Warnings:
      • If your plan contains a measure pair, you must select Default Plan Unit for the KPI summary cards whose values are expected to be displayed in any of the measures that make up that pair. Otherwise, the unit might not be correct when switching between the primary and secondary measure.
      • Ensure that the rate table that defines the exchange rates for your plan units is updated to avoid any errors.
      Note:
      • Units of measure whose Unit Type field is defined as Currency display the org's currency code. For example: USD 29,072.00

      • Units of measure whose Unit Type field is defined as any other value display one of the following, in this order of priority:

        • The symbol prefix, if it has a value. For example: #250.
        • The symbol suffix, if the symbol prefix is blank. For example: 29,07%.
        • The code, if both the symbol prefix and suffix are blank.
    7. Click Add. The KPI summary card is now created.
    8. [Optional] Repeat step 20 to create additional KPI summary cards. You can manage your cards from the Summary Cards grid.
    9. [Optional] Use drag-and-drop to reorder the KPI summary cards. They will be displayed sequentially from left to right, mirroring the top-to-bottom order they are arranged in within the grid.
    Warning:

    Summary card calculations exclude relationship values. Only cell values defined in the plan are aggregated when calculating card totals. As a result, summary card values might differ from totals shown elsewhere in the plan when relationships contribute to those values.

  21. Click Next. The Configure Dimension Value Mapping page of the wizard displays. This page enables you to define the dimension value transformations that are applied while retrieving data from Analytics. For example, you might want to use the current year's actuals to create next year's budget. In that case, you might want to transform 2024 to 2025 in the Financial Year dimension.

  22. [Optional] Define the dimension value mappings. To do this:

    1. Search for and select the dimension whose value you want to map to a new value. For example, select "Financial Year".
    2. Select the value from the Analytics dataset that you want to map to a new value. For example, enter "2026".
    3. Enter the new value that you want to use in your plan. For example, enter 2027.
    4. To add more transformations, click Insert Row and then repeat steps a-c.

  23. [Optional] To create a relationship for the new plan:

    1. Click Add.
    2. Select the parent scenario you want to use. Only plans with at least one valid parent or child scenario are displayed.
    3. From the Type column, select a relationship type.
    4. Click Save. The new relationship displays in the Plan Relationships table. Unique columns in the child plan are added as new columns to the parent plan.

  24. [Optional] If you want to change the placement of your child plan within the parent plan, select your desired plan and click Edit Details. The Edit Details page of the wizard displays.

    1. If necessary, enter a new relationship name. The relationship name is prepopulated by the parent scenario name and does not affect the child plan's placement.
    2. Select a subtotal level. The subtotal level determines the placement of the child plan, the lowest level of analysis, within the parent structure.
    3. After changing the placement of your child plans, a preview shows on the Edit Details page. Review your changes and click Save.

  25. After you have defined the structure of your plan, click Save.

    Warning:

    This step cannot be undone. When a plan is created, its structure cannot be changed.

The plan is now created. For the next steps, see Plan Table Overview.

Note:

If your plan is configured to display dimension IDs and the dimension IDs are mapped to the dimension value in Analytics, WorkGrid displays the dimension values in the grid. When a dimension value has the same name as another dimension value, a tooltip appears containing the dimension ID.