Previous Topic: Cell ValuesNext Topic: MATRIX (Planning Matrices)


Planning Tasks

The following table directs you to the PI table explanation that contains SQL for each Planning task listed. In general, the tasks select all occurrences of a Planning object within a model or all occurrences on the X or Y axis of a matrix.

If You Want to Select

See This PI Table

The activity clusters of a model

ACTIVITY_CLUSTER

The activity clusters on the Y axis

ACTIVITY_CLUSTER

The business goals for a model

BUS_GOAL

The business goals on the X axis

BUS_GOAL

The business objectives of a model

BUS_OBJECTIVE

The business objectives on the Y axis

BUS_OBJECTIVE

The computing/communication facilities of a model

FACILITY

The computing/ communication facilities on the X axis

FACILITY

The critical success factors of a model

CRITICAL_SUCCESS

The critical success factors on the X axis

CRITICAL_SUCCESS

The current databases or data stores of a model

CURRENT_DATA

The current databases or the data stores on the X axis

CURRENT_DATA

The current effects of each current information system

CURRENT_EFFECT

The current information systems of a model

CURRENT_INFO_SYS

The current information systems on the X axis

CURRENT_INFO_SYS

The data clusters of a model

DATA_CLUSTER

The data clusters on the X axis

DATA_CLUSTER

The entity types along each axis and the corresponding cell value

CELL_VALUE

The entity types along the X axis

MATRIX_USAGE_X

The entity types along the Y axis

MATRIX_USAGE_Y

The hardware/software environments of a model

ENVIRONMENT

The hardware/software environments on the X axis

ENVIRONMENT

The information needs of a model

INFORMATION_NEED

The information needs on the Y axis

INFORMATION_NEED

The locations of business assets of a model

BUS_LOCATION

The locations of business assets on the X axis

BUS_LOCATION

All the system‑defined matrices and the classes on the X and Y axes

MATRIX

All the user‑defined matrices and the classes on the X and Y axes

MATRIX

The organizational units of a model

ORGANIZAT_UNIT

The organizational units on the X axis

ORGANIZAT_UNIT

Each system‑defined matrix and system‑defined classes on each axis and the corresponding PI table name for each class

OBJECT_CLASS

All the user‑defined classes

OBJECT_CLASS

All the object classes

(system- and user‑defined)

OBJECT_CLASS

All the matrices that have the object class ENTITY_TYPE on the X axis

OBJECT_CLASS

All the matrices that have the object class ENTITY_TYPE on the X axis

OBJECT_CLASS

The user‑defined classes on the X and Y axes, and the user‑defined objects on both axes of a user‑defined matrix

USER_DEF_OBJECT

The performance measures of a model

PERFORM_MEASURE

The performance measures on the Y axis

PERFORM_MEASURE

The strategies on the X axis

STRATEGY

The strategies of a model

STRATEGY

The tactics for a model

TACTIC

The tactics on the X axis

TACTIC