Viewing Analytic Model Properties

This topic provides an overview of the Analytic Model Viewer.

Use the Analytic Model Viewer page (PTATSRCHPG2) to search for existing analytic models.

If you have already created an analytic instance and do not need to change any of its settings, you can use the Analytic Model Viewer to search for, load, and open the analytic instance. (If the instance is not loaded, clicking its name both loads and opens it; if it is loaded, clicking its name opens the instance.) When you open an analytic instance, the Analytic Model Viewer opens to a Properties tab, which displays the parts, properties, and data of the current analytic instance.

See Creating, Deleting, and Copying Analytic Instances, Loading and Unloading Analytic Instances.

Image: Analytic Model Viewer, Properties tab

This example illustrates the fields and controls on the Analytic Model Viewer - Properties tab. Definitions for the fields and controls appear following the example.

Analytic Model Viewer, Properties tab

Field or Control

Definition

Part browser

Contains hierarchies that you use to view and debug the parts of the current analytic instance. This part browser is similar to the one in PeopleSoft Application Designer. For example, if you drill into a cube collection it expands to display the specific cube collections in the current analytic instance. You can then expand each cube collection further into data cubes and dimensions. When you click the name of any part, its associated properties appear on the right side of the page, in the Part Property dialog.

See PeopleSoft Application Designer Window Components for Creating Analytic Model Definitions.

Part Properties dialog

Displays the properties of the selected part of the current analytic instance.

Analytic grid

Displays the data for the part selected in the Part browser. For example, if you select the Product Sales data cube, an analytic grid displaying Product Sales data appears. You can update the data in the analytic grid and recalculate the analytic instance. This analytic grid looks and feels like the analytic grid that you add to PeopleSoft pages to display data from the analytic server. You can use it to view, edit, and drag and drop data from an analytic model.

See Understanding Analytic Grid Design, Working with Analytic Grids.

Debugging tab

Contains options that enable you to audit the selected data cube, or from one to three data cubes from the selected cube collection. You can use this feature to view All Causes, All Effects, All Inputs, Circular System, Direct Causes, and Direct Effects. Like the Properties tab, the Debugging tab includes a Part browser, a Part Property dialog, and an analytic grid. In addition, it displays an audit grid that displays the audited data when you click the View button.

Use the Analytic Model Viewer - Properties page (PTACEMDLVWR) to view the properties and data of the selected part through the PeopleSoft Pure Internet Architecture.

Image: Analytic Model Viewer - Properties page

This example illustrates the fields and controls on the Analytic Model Viewer - Properties page. Definitions for the fields and controls appear following the example.

Analytic Model Viewer - Properties page

Field or Control

Definition

Resolve circular formulas

Indicates whether circular formulas will be resolved.

See Working with Circular Formulas and Circular Systems.

Maximum iteration in value

Indicates maximum iteration in value.

Maximum change in value

Indicates maximum change in value.

Warning circular formulas

Specifies whether the model contains circular formulas.

Notes

Lists notes related to this analytic model that the developer entered when creating the model.

See Entering Notes for an Analytic Model Definition's Parts.

Reload Model

Reloads the analytic model.

PeopleSoft recommends that you reload the analytic model after you update the analytic model definition so that you can view the resulting changes.

This topic discusses how to:

  • View cube collections and cube collection properties.

  • Debug cube collections.

  • Sort and filter cube collections.

See Purpose of Analytic Type Definitions, Relationship of Record Attributes to Data Caching Behavior, Synchronization Order.

Viewing Cube Collections and Cube Collection Properties

To view cube collections and cube collection properties:

  1. Select PeopleTools > Utilities > Administration > Analytic Model Viewer.

  2. Select a cube collection whose properties you want to view.

    A Cube Collection Properties panel appears showing the properties of the selected cube collection.

    Note: The analytic grid underneath the Cube Collection Properties panel displays the cube collection data itself. You can drag and drop data cubes and dimensions within this grid; or view selected slices of your data by choosing from the slice bar.

See Understanding Analytic Grid Design, Creating a New Analytic Model Definition.

Image: Analytic Model Viewer - Properties page, Cube Collection Properties panel

This is an example of the Cube Collection Properties panel within the Analytic Model Viewer - Properties page.

Analytic Model Viewer - Properties page, Cube Collection Properties panel

Field or Control

Definition

Dimensions

Lists all of the dimensions that are attached to the data cubes within the cube collection.

Main Record

Lists the main record to which the cube collection is mapped.

Aggregate Record

Lists the aggregate record that stores the cube collection's aggregate data, if applicable.

Notes

Lists notes related to this cube collection that the developer entered when creating the model.

See Entering Notes for an Analytic Model Definition's Parts.

Filter/Sort Criteria

Click to displays a secondary window enabling you to filter and/or sort a selected dimension within the cube collection.

Cell Properties

Click to displays a secondary window from which you can view the properties of a specified cell. You can view cell properties for data cubes and cube collections.

See Viewing Cell Properties.

Save Recalculate

Click to recalculates the results of your analytic instance, if you modified it.

Debugging Cube Collections

Use the Analytic Model Viewer - Debugging page (PTACEMDLVWRDBG) to perform debugging tasks related to the selected data cube or cube collection.

Image: Analytic Model Viewer - Debugging page, Cube Collections

This example illustrates the fields and controls on the Analytic Model Viewer - Debugging page, Cube Collections. Definitions for the fields and controls appear following the example.

Analytic Model Viewer - Debugging page, Cube Collections

Field or Control

Definition

Select up to 3 cubes for comparison

Select from one to three cubes in the cube collection to audit.

Audit Type

Select from one of the audit types: all causes, all effects, all inputs, circular system, direct causes, direct effects.

View

Click to displays the results of the audit in an audit grid below the analytic grid.

To debug a cube collection:

  1. Select PeopleTools > Utilities > Administration > Analytic Model Viewer.

  2. Select a cube collection whose properties you want to view.

  3. Select the Debugging tab.

    The part browser, filtering and sorting features, and main grid on the Debugging tab work like those features on the Properties tab. However, this tab also enables you to audit the data.

See Auditing Data Cubes at Design Time.

Sorting and Filtering Cube Collections

Use the Filter/Sort Criteria page (PTACEDIMPROP_SEC) to filter and sort the contents of the cube collection based on a specified dimension.

Image: Analytic Model Viewer - Filter/Sort Criteria page

This example illustrates the fields and controls on the Analytic Model Viewer - Filter/Sort Criteria page. Definitions for the fields and controls appear following the example.

Analytic Model Viewer - Filter/Sort Criteria page

Note: Members are only filtered when the filter condition is met. In addition, if an aggregate member is filtered, all its children are also filtered.

Field or Control

Definition

Select Dimension

Select the dimension upon which you want to base the filter or sort.

Select Filter

Select the filter.

Apply Filter

Click to apply the selected filter.

Clear Filter

Click to clear the selected filter.

Sort

Select whether to sort by key, by name, or by neither. When you elect to sort by key, you can choose from one to three keys upon which to sort, and can choose to sort each one of those keys either ascending or descending. When you sort by name, you can choose to sort either ascending or descending.

Apply Sort

Click to apply the selected sort.

Clear Sort

Click to clear the selected sort.

Return

Click to go back to the main page.

To sort and filter cube collections:

  1. Select PeopleTools > Utilities > Administration > Analytic Model Viewer.

  2. Select a cube collection whose properties you want to view.

  3. Click the Filter/Sort Criteria button.

This topic discusses how to:

  • View data cubes and data cube properties.

  • Debug data cubes.

See Understanding Data Cubes, Creating Calculation Data Cubes, Defining Data Cube Properties.

Viewing Data Cubes and Data Cube Properties

To view data cubes and data cube properties:

  1. Select PeopleTools > Utilities > Administration > Analytic Model Viewer.

  2. Select a data cube whose properties you want to view.

    The analytic grid underneath the Cube Properties panel appears showing the data cube's values. As with cube collections, you can use drag and drop to manipulate the analytic grid. You can also view slices of your data by choosing from the drop-down lists of dimensions.

Image: Analytic Model Viewer - Properties page, Cube Properties panel

This example illustrates the fields and controls on the Analytic Model Viewer - Properties page, Cube Properties panel. Definitions for the fields and controls appear following the example.

Analytic Model Viewer - Properties page, Cube Properties panel

Field or Control

Definition

Format Type

Displays the format type of the data cube—such as Number, Char, Date, and so on. These format types are attributes of the cube and are defined within PeopleSoft Application Designer.

See Understanding the Relationship Between Field Definition Attributes and Data Cube Formats.

Virtual Cube

Indicates whether the selected data cube is a virtual cube.

See Virtual Data Cubes.

Dimensions

Lists the dimensions that are attached to the selected data cube.

Calculation Aggregate

Indicates whether the analytic calculation engine calculates aggregates for the data cube.

Rule

Displays any rules that the analytic calculation engine uses to calculate the current data cube.

Notes

Lists notes related to this data cube that the developer entered when creating the model.

See Entering Notes for an Analytic Model Definition's Parts.

Cell Properties

Click to displays a secondary window from which you can view the properties of a specified cell. You can view cell properties for data cubes and cube collections.

See Viewing Cell Properties.

Save Recalculate

Click to recalculates the results of your analytic instance if you modified it.

Debugging Data Cubes

To debug a data cube:

  1. Select PeopleTools > Utilities > Administration > Analytic Model Viewer.

  2. Select a data cube whose properties you want to view.

  3. Select the Debugging tab.

Note: You can also audit data cubes at design time.

See Auditing Data Cubes at Design Time.

Image: Analytic Model Viewer - Debugging page, Data Cube panel

This example illustrates the fields and controls on the Analytic Model Viewer - Debugging page, Data Cube panel. Definitions for the fields and controls appear following the example.

Analytic Model Viewer - Debugging page, Data Cube panel

Field or Control

Definition

Cell Properties

Click to displays a secondary window from which you can view the properties of a specified cell. You can view cell properties for data cubes and cube collections.

Audit Type

Select from one of the audit types: all causes, all effects, all inputs, circular system, direct causes, direct effects.

View

Displays the results of the audit in an audit grid below the analytic grid.

See Auditing Data Cubes at Design Time.

Use the Cell Properties page (PTACECELLPROP_SEC) to view cell properties for designated member of the selected dimension.

Image: Analytic Model Viewer - Cell Properties page

This example illustrates the fields and controls on the Analytic Model Viewer - Cell Properties page. Definitions for the fields and controls appear following the example.

Analytic Model Viewer - Cell Properties page

Field or Control

Definition

Select Cube

Choose which data cube in the selected cube collection you want to view.

Note: The Select Cube option is enabled only if you activated the Analytic Model Viewer - Cell Properties page while viewing a cube collection.

Dimension Name

Displays the names of dimensions attached to the selected cube.

Member

Enter the member in the selected dimension whose properties you want to view.

Display Properties

Click to displays the properties—including cell type, calculation, calculation dimensions, reason for calculation choice, and rule—of the selected cell.

Return

Click to go back to the main page.

To view cell properties:

  1. Select PeopleTools > Utilities > Administration > Analytic Model Viewer.

  2. Select a data cube whose properties you want to view.

  3. Select the Debugging tab.

  4. Click the Cell Properties button.

This topic discusses how to view dimension properties.

See Understanding Dimensions, Creating a New Dimension.

Use the Tree Properties page (PTACETREE_SEC) to view the properties of the tree attached to the selected dimension.

Image: Analytic Model Viewer - Properties page, Dimension Properties panel

This example illustrates the fields and controls on the Analytic Model Viewer - Properties page, Dimension Properties panel. Definitions for the fields and controls appear following the example.

Analytic Model Viewer - Properties page, Dimension Properties panel

Field or Control

Definition

Total Member Name

Displays a different value depending on a fairly complex set of factors.

See Defining Dimension Properties.

Aggregate Rule

Displays the user function that calculates the dimension's aggregate fields, if applicable.

See Defining Dimension Properties, Working with Overrides.

Notes

Lists notes related to this dimension that the developer entered when creating the model.

See Entering Notes for an Analytic Model Definition's Parts.

Dimension Members

Underneath the Dimension Properties panel are the dimension members. In many cases, you see a simple list of dimension members. In some cases, however, a hierarchy has been created for the dimension and you see a tree-like structure. In this case, you open and close each branch and leaf, and see each member of this hierarchy.

Tree Properties

Click to display a secondary page that displays additional properties of the selected tree, including:

  • Tree name

  • Node name

  • Start level

  • Discard level

  • SetID

  • Record name

  • Effective date

To view dimension properties:

  1. Select PeopleTools > Utilities > Administration > Analytic Model Viewer.

  2. Select a dimension whose properties you want to view.

    After you select a dimension in the part browser, a Dimension Properties panel appears showing the properties of the selected dimension.

This topic discusses how to view user functions.

See Understanding Rules, Formulas, and User Functions, Defining and Editing User Functions.

To view user function properties:

  1. Select PeopleTools > Utilities > Administration > Analytic Model Viewer.

  2. Select a user function whose properties you want to view.

    The Analytic Model Viewer - Properties page, User Function Properties panel appears.

Image: Analytic Model Viewer - Properties page, User Function Properties panel

This example illustrates the fields and controls on the Analytic Model Viewer - Properties page, User Function Properties panel. Definitions for the fields and controls appear following the example.

Analytic Model Viewer - Properties page, User Function Properties panel

Field or Control

Definition

Rule

Displays the user function's rule.

Notes

Lists notes related to this user function that the developer entered when creating the model.

See Entering Notes for an Analytic Model Definition's Parts.

This topic discusses how to view organizer properties.

See Organizers, Creating Organizers.

To view organizer properties:

  1. Select PeopleTools > Utilities > Administration > Analytic Model Viewer.

  2. Select an organizer whose properties you want to view.

    The Analytic Model Viewer - Properties page, Organizer Properties panel appears.

Image: Analytic Model Viewer - Properties page, Organizer Properties panel

This example illustrates the fields and controls on the Analytic Model Viewer - Properties page, Organizer Properties panel.

Analytic Model Viewer - Properties page, Organizer Properties panel