Setting the Bursting Point of View

You can select a POV dimension and the required members to run the bursting operation in the Bursting POV Dimension.

The Global Point of View (POV) displays all the members for dimensions that are defined within a report or Book.

When you select multiple artifacts, the Bursting Designer consolidates their dimensions into a single dimension list. Queries are configured at the Bursting Definition level, and the same query configuration applies to all selected artifacts. The designer does not maintain a separate query configuration for each artifact.

To change the Bursting POV Dimension:

  1. In the POV bar, click Actions - actions and then select Change Bursting Dimension.


    Change_bursting_definition

  2. In the Change Bursting Dimension dialog box, select a dimension from the drop-down list.

    Note:

    Optionally, you can set the Bursting POV Dimension to None. The Bursting Definition will generate a single output file.


    change dimensions

    For example, you set the Bursting POV Dimension to None if you want to automate the output file for reports or books, then you can perform scheduling tasks via Narrative Reporting Commands in Working with EPM Automate.

You can select members for the Bursting POV dimension by choosing individual members, functions, and lists. You can also populate the Bursting POV dimension from the distribution (CSV) file by copying members upon upload. For more information, see Selecting the Targeted Distribution File.

Note:

When you load a Bursting Definition or add or remove artifacts, dimensions and data sources are updated automatically. New dimensions are added with default query configurations, dimensions no longer present are removed, and query configurations for existing dimensions are retained. The bursting dimension is retained if still available, and the existing data-source order is preserved. The Member Selector uses the first data source listed in Manage Data Sources. After adding or removing artifacts, review the unified dimension list and validate the definition before execution.

To select members for the Bursting POV Dimension:

  1. Create a new Bursting Definition or select an existing Bursting Definition in edit mode.

  2. In the Bursting POV Dimension, click on a dimension label to open the member selector for that dimension.

  3. In the Select Members dialog box, in the drop-down list, either select Members, Recent, or Functions to assign to the selected report or Book.

    Use the following conventions to select members.

    • Click Expand expand to drill into a parent member.

    • Click Select select to select and deselect a member.

      Note:

      A blue check mark indicates that a member is currently selected. A gray check mark when hovering over a member indicates that the member is not currently selected.

    • Click Function function next to a member to select the member using a function. See Assigning Members Using Functions.

    • Click Actions actions in the Selector Pane to sort the members.

To select members for each Global Dimension:

  1. Create a new Bursting Definition or select an existing Bursting Definition in edit mode.

  2. In the Global Dimension, click on a dimension label to open the Member Selector for that dimension.

  3. In the Select Members dialog box, in the drop-down list, either select Members or Recent to assign to the selected report or Book.

    Use the following conventions to select members.

    • Click Expand expand to drill into a parent member.

    • Click Select select to select and deselect a member.

      Note:

      A blue check mark indicates that a member is currently selected. A gray check mark when hovering over a member indicates that the member is not currently selected.

  4. Click OK.

    Note:

    Repeat steps above for any additional Global Dimensions.

Note:

  • When using substitution and user variables as selections for the Bursting Point of View, Variable values are retrieved when the system first connects to the data source. The member selector and/or POV will display the Variable’s value. When executing a Bursting Definition, the latest Variable value will be retrieved for the Reports in the Bursting Definition. If a Variable is used in the Bursting or Global POV and if the Variable value changes during a user’s session, the change will not be reflected in the Variable value displayed in the member selector or POV, until the user reconnects to a new session by logging out and logging in again.

  • For more information about using Variables in the member selector and POV, see Working with Substitution Variables and User Variables.

About Bursting Point of View Settings

The Default Setting: It is the dimension's default state when no member selections or options have been set for a POV dimension.

Selecting Multiple Members: You can select multiple members for a Bursting POV Dimension. You can use functions to define a list of members for the Bursting POV Dimension. For example, Children of Segments.

Resetting to Default: You can restore a dimension's default query and member selection after changing or revising the artifact list. To reset a dimension, select Reset to Default from the Actions menu. This action removes the query selection configured for the dimension at the Bursting Definition level and restores its default query and member selection.

Related Topics: