Technical data

Chapter 12 Understanding th e Relationship of Analytic Types to Analytic Models

Data Cube Attached Dimensions

SALARY in put data cube These d im ensions are attached to the SALA RY data cube:

• B USINESS_UN IT

• DEPTID

•EMPLID

• JOBCOD E

EXPENSE input data cube These dimensions are attached to the EXPENSE data cube:

• B USINESS_UN IT

• DEPTID

•EMPLID

• JOBCOD E

BONUS_PERCENT input data cube These dimensions are attached to the B ONUS_PERCEN T

data cube:

• B USINESS_UN IT

• DEPTID

•EMPLID

• JOBCOD E

Note. At this step in the process, you do not create the analytic model definition’s cube collections.

On the Models tab, you associate the analytic type to the QE_ACE_DGCMODEL analytic model, as shown

in this example:

Example of associating the QE_ACE_DBCPROB analytic type to the QE_ACE_DGCMODEL analytic model

Next, you open the analytic model definition and create a read/write cube collection called

QE_ACE_EMPLOYEE1_IN. On the General tab of the cube collection’s properties, you map the cube

collection to the QE_ACE_EMPL1 main record, as shown in this example: