Viewing cubes (dimensional reporting)

Cube-based reporting is a feature of Infor Landmark Technology that allows for two or more dimensional reporting.

(More information about cube reporting is available in the Infor Rich Client User Guide in the Infor Landmark Technology help.)

Prerequisite procedure: Enabling the Analytics Grid application

Before you view Infor Process Automation data in a cube, you must first perform the one-time procedure of enabling the grid application that creates cubes.

  1. From a command window in the Infor Landmark environment, run the following commands:

    managegrid enableanalytics <data_area> gridHost

    Be sure to type "gridHost" as the literal string gridHost; do not use the name of the grid host.

    Note: 

    If you want to disable cube reporting, use this command:

    managegrid disableanalytics <data_area>

  2. The Analytic Cube Grid node must be started before the cube is created:

    managegrid start LmrkLEA-<data_area>

Creating the cube

You will perform this procedure any time you regenerate data that you want to view in a cube.

  1. Navigate to command window in the Infor Landmark environment.

  2. To create cubes for both processes and tasks, specify:

    createcube <data_area>

  3. To create a cube for only either processes or tasks, type the appropriate command:

    createcube <data_area> PfiProcessReport

    or

    createcube <data_area> PfiTaskReport

Simple cube reporting example

Suppose you noticed that workunits were running slowly and you suspected that the process that generated the workunits needed to be streamlined. By default, Infor Process Automation includes "process version" as one of its dimensions for cube reporting. You can use this dimension to compare processing time for multiple versions of a process.

In the example that follows, the following steps were taken:

  • The process "Multiple Version Process" was updated and saved with a new version number.

  • The Process Report Cube was run.

    (Access the Process Server Administrator and select Reporting > Process Reporting > Process Report Cube.)

    Version 2 of the process executed in 22 seconds instead of 57.

    Cube report showing a process with two versions

Setting up dimensions

Infor Process Automation provides several dimensions that you can manipulate to manage the results. To view or change the default dimensions, follow these steps:

  1. Access the Process Server Administrator and select Reporting > Process Reporting > Process Report Cube (or Task Reporting > Task Report Cube).

  2. From the toolbar, select Dimensions.

  3. On the Dimensions form, you can add Available Dimensions to the Dimension Tree or remove dimensions from the tree. You can also suppress zeros from the output.

Viewing cube report data

Before you perform this procedure, you must have generated report data and created a cube (earlier procedures).

  1. Access the Process Server Administrator and select Reporting > Process Reporting > Process Report Cube (or Task Reporting > Task Report Cube).

    Process or task cube reports display on the screen.