Previous Topic: TaskNext Topic: STRATEGY


Task

Select the performance measures along the Y axis of the matrix PERFORMANCE_MEASURE/BUS_FUNCTION. Order by performance measure as specified in the toolset.

SELECT MT.NAME, Y.NAME. UY.SEQ
FROM
MODEL M,
MATRIX MT,
MATRIX_USAGE_Y UY,
PERFORM_MEASURE Y
WHERE
M.NAME = ‘my model name’
AND UY.MODEL_ID = M.ID
AND UY.MATRIX_ID = MT.ID
AND MT.NAME =‘PERFORMANCE_MEASURE/BUS_FUNCTION’
AND UY.OBJECT_ID = Y.ID
ORDER BY MT.NAME, UY.SEQ;