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 |
|
Copyright © 2013 CA.
All rights reserved.
|
|