Registering Model Data

The first step required in registering tables is to select measure dimensions for the Source and Destination stages. You may select the same measure for each stage, or select different measures for each stage.

Caution:

After measures have been selected for both the Source and Destination, they cannot be changed as long as Model Data Registrations or Drivers exist. To select new values for the Source Stage Measure or the Destination Stage Measure, you must delete all registrations and drivers for the selected application.

If Measures contain different types of data (for example, numerical headcount versus monetary values), the Stage Balancing report may provide incorrect results because the different value types cannot be properly distinguished.

To obtain correct results and ensure the accuracy of the results on the Stage Balance view, locate the statistical measures as follows:

  • For Vertical and Horizontal Source Tables, put all statistical measures on a joined lookup table.

  • To locate Statistical measures directly on the source table (either Vertical or Horizontal), create a new dimension called "Source Measure Types", and assign the "input" member to all non-statistical measure members.

See the following sections to create and manage :