QP_MATRIX_RULES

Details

Schema: FUSION
Object owner: QP
Object type: VIEW

Columns

Name
DYNAMIC_MATRIX_ID DYNAMIC_MATRIX_RULE_ID DYNAMIC_MATRIX_CLASS_ID ATTRIBUTE_1 ATTRIBUTE_VALUE_1 ATTRIBUTE_2 ATTRIBUTE_VALUE_2 ATTRIBUTE_3 ATTRIBUTE_VALUE_3 ATTRIBUTE_4 ATTRIBUTE_VALUE_4 ATTRIBUTE_5 ATTRIBUTE_VALUE_5 ATTRIBUTE_6 ATTRIBUTE_VALUE_6 ATTRIBUTE_7 ATTRIBUTE_VALUE_7 ATTRIBUTE_8 ATTRIBUTE_VALUE_8 ATTRIBUTE_9 ATTRIBUTE_VALUE_9 ATTRIBUTE_10 ATTRIBUTE_VALUE_10 ATTRIBUTE_11 ATTRIBUTE_VALUE_11 ATTRIBUTE_12 ATTRIBUTE_VALUE_12 ATTRIBUTE_13 ATTRIBUTE_VALUE_13 ATTRIBUTE_14 ATTRIBUTE_VALUE_14 ATTRIBUTE_15 ATTRIBUTE_VALUE_15 ATTRIBUTE_16 ATTRIBUTE_VALUE_16 ATTRIBUTE_17 ATTRIBUTE_VALUE_17 ATTRIBUTE_18 ATTRIBUTE_VALUE_18 ATTRIBUTE_19 ATTRIBUTE_VALUE_19 ATTRIBUTE_20 ATTRIBUTE_VALUE_20 ATTRIBUTE_21 ATTRIBUTE_VALUE_21 ATTRIBUTE_22 ATTRIBUTE_VALUE_22 ATTRIBUTE_23 ATTRIBUTE_VALUE_23 ATTRIBUTE_24 ATTRIBUTE_VALUE_24 ATTRIBUTE_25 ATTRIBUTE_VALUE_25

Name

DYNAMIC_MATRIX_ID

DYNAMIC_MATRIX_RULE_ID

DYNAMIC_MATRIX_CLASS_ID

ATTRIBUTE_1

ATTRIBUTE_VALUE_1

ATTRIBUTE_2

ATTRIBUTE_VALUE_2

ATTRIBUTE_3

ATTRIBUTE_VALUE_3

ATTRIBUTE_4

ATTRIBUTE_VALUE_4

ATTRIBUTE_5

ATTRIBUTE_VALUE_5

ATTRIBUTE_6

ATTRIBUTE_VALUE_6

ATTRIBUTE_7

ATTRIBUTE_VALUE_7

ATTRIBUTE_8

ATTRIBUTE_VALUE_8

ATTRIBUTE_9

ATTRIBUTE_VALUE_9

ATTRIBUTE_10

ATTRIBUTE_VALUE_10

ATTRIBUTE_11

ATTRIBUTE_VALUE_11

ATTRIBUTE_12

ATTRIBUTE_VALUE_12

ATTRIBUTE_13

ATTRIBUTE_VALUE_13

ATTRIBUTE_14

ATTRIBUTE_VALUE_14

ATTRIBUTE_15

ATTRIBUTE_VALUE_15

ATTRIBUTE_16

ATTRIBUTE_VALUE_16

ATTRIBUTE_17

ATTRIBUTE_VALUE_17

ATTRIBUTE_18

ATTRIBUTE_VALUE_18

ATTRIBUTE_19

ATTRIBUTE_VALUE_19

ATTRIBUTE_20

ATTRIBUTE_VALUE_20

ATTRIBUTE_21

ATTRIBUTE_VALUE_21

ATTRIBUTE_22

ATTRIBUTE_VALUE_22

ATTRIBUTE_23

ATTRIBUTE_VALUE_23

ATTRIBUTE_24

ATTRIBUTE_VALUE_24

ATTRIBUTE_25

ATTRIBUTE_VALUE_25

Query

SQL_Statement
SELECT DYNAMIC_MATRIX_ID, DYNAMIC_MATRIX_RULE_ID, MAX(DYNAMIC_MATRIX_CLASS_ID) DYNAMIC_MATRIX_CLASS_ID, MAX( CASE WHEN DIMENSION_NO='Dimension1' THEN ATTRIBUTE_NAME END) ATTRIBUTE_1, MAX( CASE WHEN DIMENSION_NO='Dimension1' THEN COLUMN_VALUE END) ATTRIBUTE_VALUE_1, MAX( CASE WHEN DIMENSION_NO='Dimension2' THEN ATTRIBUTE_NAME END) ATTRIBUTE_2, MAX( CASE WHEN DIMENSION_NO='Dimension2' THEN COLUMN_VALUE END) ATTRIBUTE_VALUE_2, MAX( CASE WHEN DIMENSION_NO='Dimension3' THEN ATTRIBUTE_NAME END) ATTRIBUTE_3, MAX( CASE WHEN DIMENSION_NO='Dimension3' THEN COLUMN_VALUE END) ATTRIBUTE_VALUE_3, MAX( CASE WHEN DIMENSION_NO='Dimension4' THEN ATTRIBUTE_NAME END) ATTRIBUTE_4, MAX( CASE WHEN DIMENSION_NO='Dimension4' THEN COLUMN_VALUE END) ATTRIBUTE_VALUE_4, MAX( CASE WHEN DIMENSION_NO='Dimension5' THEN ATTRIBUTE_NAME END) ATTRIBUTE_5, MAX( CASE WHEN DIMENSION_NO='Dimension5' THEN COLUMN_VALUE END) ATTRIBUTE_VALUE_5, MAX( CASE WHEN DIMENSION_NO='Dimension6' THEN ATTRIBUTE_NAME END) ATTRIBUTE_6, MAX( CASE WHEN DIMENSION_NO='Dimension6' THEN COLUMN_VALUE END) ATTRIBUTE_VALUE_6, MAX( CASE WHEN DIMENSION_NO='Dimension7' THEN ATTRIBUTE_NAME END) ATTRIBUTE_7, MAX( CASE WHEN DIMENSION_NO='Dimension7' THEN COLUMN_VALUE END) ATTRIBUTE_VALUE_7, MAX( CASE WHEN DIMENSION_NO='Dimension8' THEN ATTRIBUTE_NAME END) ATTRIBUTE_8, MAX( CASE WHEN DIMENSION_NO='Dimension8' THEN COLUMN_VALUE END) ATTRIBUTE_VALUE_8, MAX( CASE WHEN DIMENSION_NO='Dimension9' THEN ATTRIBUTE_NAME END) ATTRIBUTE_9, MAX( CASE WHEN DIMENSION_NO='Dimension9' THEN COLUMN_VALUE END) ATTRIBUTE_VALUE_9, MAX( CASE WHEN DIMENSION_NO='Dimension10' THEN ATTRIBUTE_NAME END) ATTRIBUTE_10, MAX( CASE WHEN DIMENSION_NO='Dimension10' THEN COLUMN_VALUE END) ATTRIBUTE_VALUE_10, MAX( CASE WHEN DIMENSION_NO='Dimension11' THEN ATTRIBUTE_NAME END) ATTRIBUTE_11, MAX( CASE WHEN DIMENSION_NO='Dimension11' THEN COLUMN_VALUE END) ATTRIBUTE_VALUE_11, MAX( CASE WHEN DIMENSION_NO='Dimension12' THEN ATTRIBUTE_NAME END) ATTRIBUTE_12, MAX( CASE WHEN DIMENSION_NO='Dimension12' THEN COLUMN_VALUE END) ATTRIBUTE_VALUE_12, MAX( CASE WHEN DIMENSION_NO='Dimension13' THEN ATTRIBUTE_NAME END) ATTRIBUTE_13, MAX( CASE WHEN DIMENSION_NO='Dimension13' THEN COLUMN_VALUE END) ATTRIBUTE_VALUE_13, MAX( CASE WHEN DIMENSION_NO='Dimension14' THEN ATTRIBUTE_NAME END) ATTRIBUTE_14, MAX( CASE WHEN DIMENSION_NO='Dimension14' THEN COLUMN_VALUE END) ATTRIBUTE_VALUE_14, MAX( CASE WHEN DIMENSION_NO='Dimension15' THEN ATTRIBUTE_NAME END) ATTRIBUTE_15, MAX( CASE WHEN DIMENSION_NO='Dimension15' THEN COLUMN_VALUE END) ATTRIBUTE_VALUE_15, MAX( CASE WHEN DIMENSION_NO='Dimension16' THEN ATTRIBUTE_NAME END) ATTRIBUTE_16, MAX( CASE WHEN DIMENSION_NO='Dimension16' THEN COLUMN_VALUE END) ATTRIBUTE_VALUE_16, MAX( CASE WHEN DIMENSION_NO='Dimension17' THEN ATTRIBUTE_NAME END) ATTRIBUTE_17, MAX( CASE WHEN DIMENSION_NO='Dimension17' THEN COLUMN_VALUE END) ATTRIBUTE_VALUE_17, MAX( CASE WHEN DIMENSION_NO='Dimension18' THEN ATTRIBUTE_NAME END) ATTRIBUTE_18, MAX( CASE WHEN DIMENSION_NO='Dimension18' THEN COLUMN_VALUE END) ATTRIBUTE_VALUE_18, MAX( CASE WHEN DIMENSION_NO='Dimension19' THEN ATTRIBUTE_NAME END) ATTRIBUTE_19, MAX( CASE WHEN DIMENSION_NO='Dimension19' THEN COLUMN_VALUE END) ATTRIBUTE_VALUE_19, MAX( CASE WHEN DIMENSION_NO='Dimension20' THEN ATTRIBUTE_NAME END) ATTRIBUTE_20, MAX( CASE WHEN DIMENSION_NO='Dimension20' THEN COLUMN_VALUE END) ATTRIBUTE_VALUE_20, MAX( CASE WHEN DIMENSION_NO='Dimension21' THEN ATTRIBUTE_NAME END) ATTRIBUTE_21, MAX( CASE WHEN DIMENSION_NO='Dimension21' THEN COLUMN_VALUE END) ATTRIBUTE_VALUE_21, MAX( CASE WHEN DIMENSION_NO='Dimension22' THEN ATTRIBUTE_NAME END) ATTRIBUTE_22, MAX( CASE WHEN DIMENSION_NO='Dimension22' THEN COLUMN_VALUE END) ATTRIBUTE_VALUE_22, MAX( CASE WHEN DIMENSION_NO='Dimension23' THEN ATTRIBUTE_NAME END) ATTRIBUTE_23, MAX( CASE WHEN DIMENSION_NO='Dimension23' THEN COLUMN_VALUE END) ATTRIBUTE_VALUE_23, MAX( CASE WHEN DIMENSION_NO='Dimension24' THEN ATTRIBUTE_NAME END) ATTRIBUTE_24, MAX( CASE WHEN DIMENSION_NO='Dimension24' THEN COLUMN_VALUE END) ATTRIBUTE_VALUE_24, MAX( CASE WHEN DIMENSION_NO='Dimension25' THEN ATTRIBUTE_NAME END) ATTRIBUTE_25, MAX( CASE WHEN DIMENSION_NO='Dimension25' THEN COLUMN_VALUE END) ATTRIBUTE_VALUE_25 FROM (SELECT DYNAMIC_MATRIX_DIMENSION_NAME AS ATTRIBUTE_NAME, ATTRIBUTE_TYPE, COLUMN_VALUE , b.DYNAMIC_MATRIX_RULE_ID, a.DYNAMIC_MATRIX_ID, a.DYNAMIC_MATRIX_CLASS_ID, 'Dimension' \|\| (row_number() over (partition BY b.DYNAMIC_MATRIX_RULE_ID, a.DYNAMIC_MATRIX_ID order by DISPLAY_SEQUENCE_NUM)) AS DIMENSION_NO FROM (SELECT DimensionsTL.DYNAMIC_MATRIX_DIMENSION_NAME, 'VALUE_' \|\|MatrixDimensionsB.DATA_TYPE_CODE \|\|InheritedDimensions.MAP_TO_RULE_COL_NUM AS ATTRIBUTE_TYPE, DIMENSION_TYPE, MatrixDimensionsB.DISPLAY_SEQUENCE_NUM AS DISPLAY_SEQUENCE_NUM, InheritedDimensions.DYNAMIC_MATRIX_ID, MatrixDimensionsB.DYNAMIC_MATRIX_CLASS_ID FROM QP_MATRIX_DIMENSIONS_B MatrixDimensionsB, QP_MATRIX_INHERITED_DIMENSIONS InheritedDimensions, QP_MATRIX_DIMENSIONS_TL DimensionsTL WHERE MatrixDimensionsB.DYNAMIC_MATRIX_DIMENSION_ID = InheritedDimensions.DYNAMIC_MATRIX_DIMENSION_ID AND MatrixDimensionsB.DYNAMIC_MATRIX_DIMENSION_ID = DimensionsTL.DYNAMIC_MATRIX_DIMENSION_ID AND DimensionsTL.LANGUAGE = USERENV('LANG') ) a, (SELECT COLUMN_NAME, COLUMN_VALUE, DYNAMIC_MATRIX_RULE_ID, DYNAMIC_MATRIX_ID FROM (SELECT NVL(TO_CHAR(VALUE_NUMBER1),' ') VALUE_NUMBER1, NVL(TO_CHAR(VALUE_NUMBER2),' ') VALUE_NUMBER2, NVL(TO_CHAR(VALUE_NUMBER3),' ') VALUE_NUMBER3, NVL(TO_CHAR(VALUE_NUMBER4),' ') VALUE_NUMBER4, NVL(TO_CHAR(VALUE_NUMBER5),' ') VALUE_NUMBER5, NVL(TO_CHAR(VALUE_NUMBER6),' ') VALUE_NUMBER6, NVL(TO_CHAR(VALUE_NUMBER7),' ') VALUE_NUMBER7, NVL(TO_CHAR(VALUE_NUMBER8),' ') VALUE_NUMBER8, NVL(TO_CHAR(VALUE_NUMBER9),' ') VALUE_NUMBER9, NVL(TO_CHAR(VALUE_NUMBER10),' ') VALUE_NUMBER10, NVL(TO_CHAR(VALUE_NUMBER11),' ') VALUE_NUMBER11, NVL(TO_CHAR(VALUE_NUMBER12),' ') VALUE_NUMBER12, NVL(TO_CHAR(VALUE_NUMBER13),' ') VALUE_NUMBER13, NVL(TO_CHAR(VALUE_NUMBER14),' ') VALUE_NUMBER14, NVL(TO_CHAR(VALUE_NUMBER15),' ') VALUE_NUMBER15, NVL(TO_CHAR(VALUE_NUMBER16),' ') VALUE_NUMBER16, NVL(TO_CHAR(VALUE_NUMBER17),' ') VALUE_NUMBER17, NVL(TO_CHAR(VALUE_NUMBER18),' ') VALUE_NUMBER18, NVL(TO_CHAR(VALUE_NUMBER19),' ') VALUE_NUMBER19, NVL(TO_CHAR(VALUE_NUMBER20),' ') VALUE_NUMBER20, NVL(TO_CHAR(VALUE_NUMBER21),' ') VALUE_NUMBER21, NVL(TO_CHAR(VALUE_NUMBER22),' ') VALUE_NUMBER22, NVL(TO_CHAR(VALUE_NUMBER23),' ') VALUE_NUMBER23, NVL(TO_CHAR(VALUE_NUMBER24),' ') VALUE_NUMBER24, NVL(TO_CHAR(VALUE_NUMBER25),' ') VALUE_NUMBER25, NVL(VALUE_STRING1,' ') VALUE_STRING1, NVL(VALUE_STRING2,' ') VALUE_STRING2, NVL(VALUE_STRING3,' ') VALUE_STRING3, NVL(VALUE_STRING4,' ') VALUE_STRING4, NVL(VALUE_STRING5,' ') VALUE_STRING5, NVL(VALUE_STRING6,' ') VALUE_STRING6, NVL(VALUE_STRING7,' ') VALUE_STRING7, NVL(VALUE_STRING8,' ') VALUE_STRING8, NVL(VALUE_STRING9,' ') VALUE_STRING9, NVL(VALUE_STRING10,' ') VALUE_STRING10, NVL(VALUE_STRING11,' ') VALUE_STRING11, NVL(VALUE_STRING12,' ') VALUE_STRING12, NVL(VALUE_STRING13,' ') VALUE_STRING13, NVL(VALUE_STRING14,' ') VALUE_STRING14, NVL(VALUE_STRING15,' ') VALUE_STRING15, NVL(VALUE_STRING16,' ') VALUE_STRING16, NVL(VALUE_STRING17,' ') VALUE_STRING17, NVL(VALUE_STRING18,' ') VALUE_STRING18, NVL(VALUE_STRING19,' ') VALUE_STRING19, NVL(VALUE_STRING20,' ') VALUE_STRING20, NVL(VALUE_STRING21,' ') VALUE_STRING21, NVL(VALUE_STRING22,' ') VALUE_STRING22, NVL(VALUE_STRING23,' ') VALUE_STRING23, NVL(VALUE_STRING24,' ') VALUE_STRING24, NVL(VALUE_STRING25,' ') VALUE_STRING25, NVL(TO_CHAR(VALUE_DATE1,'YYYY-MM-DD'),' ') VALUE_DATE1, NVL(TO_CHAR(VALUE_DATE2,'YYYY-MM-DD'),' ') VALUE_DATE2, NVL(TO_CHAR(VALUE_DATE3,'YYYY-MM-DD'),' ') VALUE_DATE3, NVL(TO_CHAR(VALUE_DATE4,'YYYY-MM-DD'),' ') VALUE_DATE4, NVL(TO_CHAR(VALUE_DATE5,'YYYY-MM-DD'),' ') VALUE_DATE5, NVL(TO_CHAR(VALUE_DATE6,'YYYY-MM-DD'),' ') VALUE_DATE6, NVL(TO_CHAR(VALUE_DATE7,'YYYY-MM-DD'),' ') VALUE_DATE7, NVL(TO_CHAR(VALUE_DATE8,'YYYY-MM-DD'),' ') VALUE_DATE8, NVL(TO_CHAR(VALUE_DATE9,'YYYY-MM-DD'),' ') VALUE_DATE9, NVL(TO_CHAR(VALUE_DATE10,'YYYY-MM-DD'),' ') VALUE_DATE10, NVL(TO_CHAR(VALUE_DATE11,'YYYY-MM-DD'),' ') VALUE_DATE11, NVL(TO_CHAR(VALUE_DATE12,'YYYY-MM-DD'),' ') VALUE_DATE12, NVL(TO_CHAR(VALUE_DATE13,'YYYY-MM-DD'),' ') VALUE_DATE13, NVL(TO_CHAR(VALUE_DATE14,'YYYY-MM-DD'),' ') VALUE_DATE14, NVL(TO_CHAR(VALUE_DATE15,'YYYY-MM-DD'),' ') VALUE_DATE15, NVL(TO_CHAR(VALUE_DATE16,'YYYY-MM-DD'),' ') VALUE_DATE16, NVL(TO_CHAR(VALUE_DATE17,'YYYY-MM-DD'),' ') VALUE_DATE17, NVL(TO_CHAR(VALUE_DATE18,'YYYY-MM-DD'),' ') VALUE_DATE18, NVL(TO_CHAR(VALUE_DATE19,'YYYY-MM-DD'),' ') VALUE_DATE19, NVL(TO_CHAR(VALUE_DATE20,'YYYY-MM-DD'),' ') VALUE_DATE20, NVL(TO_CHAR(VALUE_DATE21,'YYYY-MM-DD'),' ') VALUE_DATE21, NVL(TO_CHAR(VALUE_DATE22,'YYYY-MM-DD'),' ') VALUE_DATE22, NVL(TO_CHAR(VALUE_DATE23,'YYYY-MM-DD'),' ') VALUE_DATE23, NVL(TO_CHAR(VALUE_DATE24,'YYYY-MM-DD'),' ') VALUE_DATE24, NVL(TO_CHAR(VALUE_DATE25,'YYYY-MM-DD'),' ') VALUE_DATE25, NVL(TO_CHAR(VALUE_TIMESTAMP1,'YYYY-MM-DD HH:MM:SS'),' ') VALUE_TIMESTAMP1, NVL(TO_CHAR(VALUE_TIMESTAMP2,'YYYY-MM-DD HH:MM:SS'),' ') VALUE_TIMESTAMP2, NVL(TO_CHAR(VALUE_TIMESTAMP3,'YYYY-MM-DD HH:MM:SS'),' ') VALUE_TIMESTAMP3, NVL(TO_CHAR(VALUE_TIMESTAMP4,'YYYY-MM-DD HH:MM:SS'),' ') VALUE_TIMESTAMP4, NVL(TO_CHAR(VALUE_TIMESTAMP5,'YYYY-MM-DD HH:MM:SS'),' ') VALUE_TIMESTAMP5, NVL(TO_CHAR(VALUE_TIMESTAMP6,'YYYY-MM-DD HH:MM:SS'),' ') VALUE_TIMESTAMP6, NVL(TO_CHAR(VALUE_TIMESTAMP7,'YYYY-MM-DD HH:MM:SS'),' ') VALUE_TIMESTAMP7, NVL(TO_CHAR(VALUE_TIMESTAMP8,'YYYY-MM-DD HH:MM:SS'),' ') VALUE_TIMESTAMP8, NVL(TO_CHAR(VALUE_TIMESTAMP9,'YYYY-MM-DD HH:MM:SS'),' ') VALUE_TIMESTAMP9, NVL(TO_CHAR(VALUE_TIMESTAMP10,'YYYY-MM-DD HH:MM:SS'),' ') VALUE_TIMESTAMP10, NVL(TO_CHAR(VALUE_TIMESTAMP11,'YYYY-MM-DD HH:MM:SS'),' ') VALUE_TIMESTAMP11, NVL(TO_CHAR(VALUE_TIMESTAMP12,'YYYY-MM-DD HH:MM:SS'),' ') VALUE_TIMESTAMP12, NVL(TO_CHAR(VALUE_TIMESTAMP13,'YYYY-MM-DD HH:MM:SS'),' ') VALUE_TIMESTAMP13, NVL(TO_CHAR(VALUE_TIMESTAMP14,'YYYY-MM-DD HH:MM:SS'),' ') VALUE_TIMESTAMP14, NVL(TO_CHAR(VALUE_TIMESTAMP15,'YYYY-MM-DD HH:MM:SS'),' ') VALUE_TIMESTAMP15, NVL(TO_CHAR(VALUE_TIMESTAMP16,'YYYY-MM-DD HH:MM:SS'),' ') VALUE_TIMESTAMP16, NVL(TO_CHAR(VALUE_TIMESTAMP17,'YYYY-MM-DD HH:MM:SS'),' ') VALUE_TIMESTAMP17, NVL(TO_CHAR(VALUE_TIMESTAMP18,'YYYY-MM-DD HH:MM:SS'),' ') VALUE_TIMESTAMP18, NVL(TO_CHAR(VALUE_TIMESTAMP19,'YYYY-MM-DD HH:MM:SS'),' ') VALUE_TIMESTAMP19, NVL(TO_CHAR(VALUE_TIMESTAMP20,'YYYY-MM-DD HH:MM:SS'),' ') VALUE_TIMESTAMP20, NVL(TO_CHAR(VALUE_TIMESTAMP21,'YYYY-MM-DD HH:MM:SS'),' ') VALUE_TIMESTAMP21, NVL(TO_CHAR(VALUE_TIMESTAMP22,'YYYY-MM-DD HH:MM:SS'),' ') VALUE_TIMESTAMP22, NVL(TO_CHAR(VALUE_TIMESTAMP23,'YYYY-MM-DD HH:MM:SS'),' ') VALUE_TIMESTAMP23, NVL(TO_CHAR(VALUE_TIMESTAMP24,'YYYY-MM-DD HH:MM:SS'),' ') VALUE_TIMESTAMP24, NVL(TO_CHAR(VALUE_TIMESTAMP25,'YYYY-MM-DD HH:MM:SS'),' ') VALUE_TIMESTAMP25, DYNAMIC_MATRIX_ID, DYNAMIC_MATRIX_RULE_ID FROM QP_MATRIX_RULES ) UNPIVOT( COLUMN_VALUE FOR (COLUMN_NAME) IN(VALUE_NUMBER1,VALUE_NUMBER2,VALUE_NUMBER3,VALUE_NUMBER4,VALUE_NUMBER5, VALUE_NUMBER6,VALUE_NUMBER7,VALUE_NUMBER8,VALUE_NUMBER9,VALUE_NUMBER10,VALUE_NUMBER11,VALUE_NUMBER12,VALUE_NUMBER13,VALUE_NUMBER14,VALUE_NUMBER15, VALUE_NUMBER16,VALUE_NUMBER17,VALUE_NUMBER18,VALUE_NUMBER19,VALUE_NUMBER20,VALUE_NUMBER21,VALUE_NUMBER22,VALUE_NUMBER23,VALUE_NUMBER24,VALUE_NUMBER25,VALUE_STRING1,VALUE_STRING2,VALUE_STRING3,VALUE_STRING4,VALUE_STRING5,VALUE_STRING6,VALUE_STRING7,VALUE_STRING8,VALUE_STRING9,VALUE_STRING10,VALUE_STRING11,VALUE_STRING12,VALUE_STRING13,VALUE_STRING14,VALUE_STRING15,VALUE_STRING16,VALUE_STRING17,VALUE_STRING18,VALUE_STRING19,VALUE_STRING20,VALUE_STRING21,VALUE_STRING22,VALUE_STRING23,VALUE_STRING24,VALUE_STRING25,VALUE_DATE1,VALUE_DATE2,VALUE_DATE3,VALUE_DATE4,VALUE_DATE5,VALUE_DATE6,VALUE_DATE7,VALUE_DATE8,VALUE_DATE9,VALUE_DATE10,VALUE_DATE11,VALUE_DATE12,VALUE_DATE13,VALUE_DATE14,VALUE_DATE15,VALUE_DATE16,VALUE_DATE17,VALUE_DATE18,VALUE_DATE19,VALUE_DATE20,VALUE_DATE21,VALUE_DATE22,VALUE_DATE23,VALUE_DATE24,VALUE_DATE25,VALUE_TIMESTAMP1,VALUE_TIMESTAMP2,VALUE_TIMESTAMP3,VALUE_TIMESTAMP4,VALUE_TIMESTAMP5,VALUE_TIMESTAMP6,VALUE_TIMESTAMP7,VALUE_TIMESTAMP8,VALUE_TIMESTAMP9,VALUE_TIMESTAMP10,VALUE_TIMESTAMP11,VALUE_TIMESTAMP12,VALUE_TIMESTAMP13,VALUE_TIMESTAMP14,VALUE_TIMESTAMP15,VALUE_TIMESTAMP16,VALUE_TIMESTAMP17,VALUE_TIMESTAMP18,VALUE_TIMESTAMP19,VALUE_TIMESTAMP20,VALUE_TIMESTAMP21,VALUE_TIMESTAMP22,VALUE_TIMESTAMP23,VALUE_TIMESTAMP24,VALUE_TIMESTAMP25) ) ) b WHERE a.ATTRIBUTE_TYPE = b.COLUMN_NAME AND a.DYNAMIC_MATRIX_ID = b.DYNAMIC_MATRIX_ID ) GROUP BY DYNAMIC_MATRIX_ID, DYNAMIC_MATRIX_RULE_ID

SQL_Statement

SELECT DYNAMIC_MATRIX_ID,

DYNAMIC_MATRIX_RULE_ID,

MAX(DYNAMIC_MATRIX_CLASS_ID) DYNAMIC_MATRIX_CLASS_ID,

MAX(

CASE

WHEN DIMENSION_NO='Dimension1'

THEN ATTRIBUTE_NAME

END) ATTRIBUTE_1,

MAX(

CASE

WHEN DIMENSION_NO='Dimension1'

THEN COLUMN_VALUE

END) ATTRIBUTE_VALUE_1,

MAX(

CASE

WHEN DIMENSION_NO='Dimension2'

THEN ATTRIBUTE_NAME

END) ATTRIBUTE_2,

MAX(

CASE

WHEN DIMENSION_NO='Dimension2'

THEN COLUMN_VALUE

END) ATTRIBUTE_VALUE_2,

MAX(

CASE

WHEN DIMENSION_NO='Dimension3'

THEN ATTRIBUTE_NAME

END) ATTRIBUTE_3,

MAX(

CASE

WHEN DIMENSION_NO='Dimension3'

THEN COLUMN_VALUE

END) ATTRIBUTE_VALUE_3,

MAX(

CASE

WHEN DIMENSION_NO='Dimension4'

THEN ATTRIBUTE_NAME

END) ATTRIBUTE_4,

MAX(

CASE

WHEN DIMENSION_NO='Dimension4'

THEN COLUMN_VALUE

END) ATTRIBUTE_VALUE_4,

MAX(

CASE

WHEN DIMENSION_NO='Dimension5'

THEN ATTRIBUTE_NAME

END) ATTRIBUTE_5,

MAX(

CASE

WHEN DIMENSION_NO='Dimension5'

THEN COLUMN_VALUE

END) ATTRIBUTE_VALUE_5,

MAX(

CASE

WHEN DIMENSION_NO='Dimension6'

THEN ATTRIBUTE_NAME

END) ATTRIBUTE_6,

MAX(

CASE

WHEN DIMENSION_NO='Dimension6'

THEN COLUMN_VALUE

END) ATTRIBUTE_VALUE_6,

MAX(

CASE

WHEN DIMENSION_NO='Dimension7'

THEN ATTRIBUTE_NAME

END) ATTRIBUTE_7,

MAX(

CASE

WHEN DIMENSION_NO='Dimension7'

THEN COLUMN_VALUE

END) ATTRIBUTE_VALUE_7,

MAX(

CASE

WHEN DIMENSION_NO='Dimension8'

THEN ATTRIBUTE_NAME

END) ATTRIBUTE_8,

MAX(

CASE

WHEN DIMENSION_NO='Dimension8'

THEN COLUMN_VALUE

END) ATTRIBUTE_VALUE_8,

MAX(

CASE

WHEN DIMENSION_NO='Dimension9'

THEN ATTRIBUTE_NAME

END) ATTRIBUTE_9,

MAX(

CASE

WHEN DIMENSION_NO='Dimension9'

THEN COLUMN_VALUE

END) ATTRIBUTE_VALUE_9,

MAX(

CASE

WHEN DIMENSION_NO='Dimension10'

THEN ATTRIBUTE_NAME

END) ATTRIBUTE_10,

MAX(

CASE

WHEN DIMENSION_NO='Dimension10'

THEN COLUMN_VALUE

END) ATTRIBUTE_VALUE_10,

MAX(

CASE

WHEN DIMENSION_NO='Dimension11'

THEN ATTRIBUTE_NAME

END) ATTRIBUTE_11,

MAX(

CASE

WHEN DIMENSION_NO='Dimension11'

THEN COLUMN_VALUE

END) ATTRIBUTE_VALUE_11,

MAX(

CASE

WHEN DIMENSION_NO='Dimension12'

THEN ATTRIBUTE_NAME

END) ATTRIBUTE_12,

MAX(

CASE

WHEN DIMENSION_NO='Dimension12'

THEN COLUMN_VALUE

END) ATTRIBUTE_VALUE_12,

MAX(

CASE

WHEN DIMENSION_NO='Dimension13'

THEN ATTRIBUTE_NAME

END) ATTRIBUTE_13,

MAX(

CASE

WHEN DIMENSION_NO='Dimension13'

THEN COLUMN_VALUE

END) ATTRIBUTE_VALUE_13,

MAX(

CASE

WHEN DIMENSION_NO='Dimension14'

THEN ATTRIBUTE_NAME

END) ATTRIBUTE_14,

MAX(

CASE

WHEN DIMENSION_NO='Dimension14'

THEN COLUMN_VALUE

END) ATTRIBUTE_VALUE_14,

MAX(

CASE

WHEN DIMENSION_NO='Dimension15'

THEN ATTRIBUTE_NAME

END) ATTRIBUTE_15,

MAX(

CASE

WHEN DIMENSION_NO='Dimension15'

THEN COLUMN_VALUE

END) ATTRIBUTE_VALUE_15,

MAX(

CASE

WHEN DIMENSION_NO='Dimension16'

THEN ATTRIBUTE_NAME

END) ATTRIBUTE_16,

MAX(

CASE

WHEN DIMENSION_NO='Dimension16'

THEN COLUMN_VALUE

END) ATTRIBUTE_VALUE_16,

MAX(

CASE

WHEN DIMENSION_NO='Dimension17'

THEN ATTRIBUTE_NAME

END) ATTRIBUTE_17,

MAX(

CASE

WHEN DIMENSION_NO='Dimension17'

THEN COLUMN_VALUE

END) ATTRIBUTE_VALUE_17,

MAX(

CASE

WHEN DIMENSION_NO='Dimension18'

THEN ATTRIBUTE_NAME

END) ATTRIBUTE_18,

MAX(

CASE

WHEN DIMENSION_NO='Dimension18'

THEN COLUMN_VALUE

END) ATTRIBUTE_VALUE_18,

MAX(

CASE

WHEN DIMENSION_NO='Dimension19'

THEN ATTRIBUTE_NAME

END) ATTRIBUTE_19,

MAX(

CASE

WHEN DIMENSION_NO='Dimension19'

THEN COLUMN_VALUE

END) ATTRIBUTE_VALUE_19,

MAX(

CASE

WHEN DIMENSION_NO='Dimension20'

THEN ATTRIBUTE_NAME

END) ATTRIBUTE_20,

MAX(

CASE

WHEN DIMENSION_NO='Dimension20'

THEN COLUMN_VALUE

END) ATTRIBUTE_VALUE_20,

MAX(

CASE

WHEN DIMENSION_NO='Dimension21'

THEN ATTRIBUTE_NAME

END) ATTRIBUTE_21,

MAX(

CASE

WHEN DIMENSION_NO='Dimension21'

THEN COLUMN_VALUE

END) ATTRIBUTE_VALUE_21,

MAX(

CASE

WHEN DIMENSION_NO='Dimension22'

THEN ATTRIBUTE_NAME

END) ATTRIBUTE_22,

MAX(

CASE

WHEN DIMENSION_NO='Dimension22'

THEN COLUMN_VALUE

END) ATTRIBUTE_VALUE_22,

MAX(

CASE

WHEN DIMENSION_NO='Dimension23'

THEN ATTRIBUTE_NAME

END) ATTRIBUTE_23,

MAX(

CASE

WHEN DIMENSION_NO='Dimension23'

THEN COLUMN_VALUE

END) ATTRIBUTE_VALUE_23,

MAX(

CASE

WHEN DIMENSION_NO='Dimension24'

THEN ATTRIBUTE_NAME

END) ATTRIBUTE_24,

MAX(

CASE

WHEN DIMENSION_NO='Dimension24'

THEN COLUMN_VALUE

END) ATTRIBUTE_VALUE_24,

MAX(

CASE

WHEN DIMENSION_NO='Dimension25'

THEN ATTRIBUTE_NAME

END) ATTRIBUTE_25,

MAX(

CASE

WHEN DIMENSION_NO='Dimension25'

THEN COLUMN_VALUE

END) ATTRIBUTE_VALUE_25

FROM

(SELECT DYNAMIC_MATRIX_DIMENSION_NAME AS ATTRIBUTE_NAME,

ATTRIBUTE_TYPE,

COLUMN_VALUE ,

b.DYNAMIC_MATRIX_RULE_ID,

a.DYNAMIC_MATRIX_ID,

a.DYNAMIC_MATRIX_CLASS_ID,

'Dimension'

|| (row_number() over (partition BY b.DYNAMIC_MATRIX_RULE_ID, a.DYNAMIC_MATRIX_ID order by DISPLAY_SEQUENCE_NUM)) AS DIMENSION_NO

FROM

(SELECT DimensionsTL.DYNAMIC_MATRIX_DIMENSION_NAME,

'VALUE_'

||MatrixDimensionsB.DATA_TYPE_CODE

||InheritedDimensions.MAP_TO_RULE_COL_NUM AS ATTRIBUTE_TYPE,

DIMENSION_TYPE,

MatrixDimensionsB.DISPLAY_SEQUENCE_NUM AS DISPLAY_SEQUENCE_NUM,

InheritedDimensions.DYNAMIC_MATRIX_ID,

MatrixDimensionsB.DYNAMIC_MATRIX_CLASS_ID

FROM QP_MATRIX_DIMENSIONS_B MatrixDimensionsB,

QP_MATRIX_INHERITED_DIMENSIONS InheritedDimensions,

QP_MATRIX_DIMENSIONS_TL DimensionsTL

WHERE MatrixDimensionsB.DYNAMIC_MATRIX_DIMENSION_ID = InheritedDimensions.DYNAMIC_MATRIX_DIMENSION_ID

AND MatrixDimensionsB.DYNAMIC_MATRIX_DIMENSION_ID = DimensionsTL.DYNAMIC_MATRIX_DIMENSION_ID

AND DimensionsTL.LANGUAGE = USERENV('LANG')

) a,

(SELECT COLUMN_NAME,

COLUMN_VALUE,

DYNAMIC_MATRIX_RULE_ID,

DYNAMIC_MATRIX_ID

FROM

(SELECT NVL(TO_CHAR(VALUE_NUMBER1),' ') VALUE_NUMBER1,

NVL(TO_CHAR(VALUE_NUMBER2),' ') VALUE_NUMBER2,

NVL(TO_CHAR(VALUE_NUMBER3),' ') VALUE_NUMBER3,

NVL(TO_CHAR(VALUE_NUMBER4),' ') VALUE_NUMBER4,

NVL(TO_CHAR(VALUE_NUMBER5),' ') VALUE_NUMBER5,

NVL(TO_CHAR(VALUE_NUMBER6),' ') VALUE_NUMBER6,

NVL(TO_CHAR(VALUE_NUMBER7),' ') VALUE_NUMBER7,

NVL(TO_CHAR(VALUE_NUMBER8),' ') VALUE_NUMBER8,

NVL(TO_CHAR(VALUE_NUMBER9),' ') VALUE_NUMBER9,

NVL(TO_CHAR(VALUE_NUMBER10),' ') VALUE_NUMBER10,

NVL(TO_CHAR(VALUE_NUMBER11),' ') VALUE_NUMBER11,

NVL(TO_CHAR(VALUE_NUMBER12),' ') VALUE_NUMBER12,

NVL(TO_CHAR(VALUE_NUMBER13),' ') VALUE_NUMBER13,

NVL(TO_CHAR(VALUE_NUMBER14),' ') VALUE_NUMBER14,

NVL(TO_CHAR(VALUE_NUMBER15),' ') VALUE_NUMBER15,

NVL(TO_CHAR(VALUE_NUMBER16),' ') VALUE_NUMBER16,

NVL(TO_CHAR(VALUE_NUMBER17),' ') VALUE_NUMBER17,

NVL(TO_CHAR(VALUE_NUMBER18),' ') VALUE_NUMBER18,

NVL(TO_CHAR(VALUE_NUMBER19),' ') VALUE_NUMBER19,

NVL(TO_CHAR(VALUE_NUMBER20),' ') VALUE_NUMBER20,

NVL(TO_CHAR(VALUE_NUMBER21),' ') VALUE_NUMBER21,

NVL(TO_CHAR(VALUE_NUMBER22),' ') VALUE_NUMBER22,

NVL(TO_CHAR(VALUE_NUMBER23),' ') VALUE_NUMBER23,

NVL(TO_CHAR(VALUE_NUMBER24),' ') VALUE_NUMBER24,

NVL(TO_CHAR(VALUE_NUMBER25),' ') VALUE_NUMBER25,

NVL(VALUE_STRING1,' ') VALUE_STRING1,

NVL(VALUE_STRING2,' ') VALUE_STRING2,

NVL(VALUE_STRING3,' ') VALUE_STRING3,

NVL(VALUE_STRING4,' ') VALUE_STRING4,

NVL(VALUE_STRING5,' ') VALUE_STRING5,

NVL(VALUE_STRING6,' ') VALUE_STRING6,

NVL(VALUE_STRING7,' ') VALUE_STRING7,

NVL(VALUE_STRING8,' ') VALUE_STRING8,

NVL(VALUE_STRING9,' ') VALUE_STRING9,

NVL(VALUE_STRING10,' ') VALUE_STRING10,

NVL(VALUE_STRING11,' ') VALUE_STRING11,

NVL(VALUE_STRING12,' ') VALUE_STRING12,

NVL(VALUE_STRING13,' ') VALUE_STRING13,

NVL(VALUE_STRING14,' ') VALUE_STRING14,

NVL(VALUE_STRING15,' ') VALUE_STRING15,

NVL(VALUE_STRING16,' ') VALUE_STRING16,

NVL(VALUE_STRING17,' ') VALUE_STRING17,

NVL(VALUE_STRING18,' ') VALUE_STRING18,

NVL(VALUE_STRING19,' ') VALUE_STRING19,

NVL(VALUE_STRING20,' ') VALUE_STRING20,

NVL(VALUE_STRING21,' ') VALUE_STRING21,

NVL(VALUE_STRING22,' ') VALUE_STRING22,

NVL(VALUE_STRING23,' ') VALUE_STRING23,

NVL(VALUE_STRING24,' ') VALUE_STRING24,

NVL(VALUE_STRING25,' ') VALUE_STRING25,

NVL(TO_CHAR(VALUE_DATE1,'YYYY-MM-DD'),' ') VALUE_DATE1,

NVL(TO_CHAR(VALUE_DATE2,'YYYY-MM-DD'),' ') VALUE_DATE2,

NVL(TO_CHAR(VALUE_DATE3,'YYYY-MM-DD'),' ') VALUE_DATE3,

NVL(TO_CHAR(VALUE_DATE4,'YYYY-MM-DD'),' ') VALUE_DATE4,

NVL(TO_CHAR(VALUE_DATE5,'YYYY-MM-DD'),' ') VALUE_DATE5,

NVL(TO_CHAR(VALUE_DATE6,'YYYY-MM-DD'),' ') VALUE_DATE6,

NVL(TO_CHAR(VALUE_DATE7,'YYYY-MM-DD'),' ') VALUE_DATE7,

NVL(TO_CHAR(VALUE_DATE8,'YYYY-MM-DD'),' ') VALUE_DATE8,

NVL(TO_CHAR(VALUE_DATE9,'YYYY-MM-DD'),' ') VALUE_DATE9,

NVL(TO_CHAR(VALUE_DATE10,'YYYY-MM-DD'),' ') VALUE_DATE10,

NVL(TO_CHAR(VALUE_DATE11,'YYYY-MM-DD'),' ') VALUE_DATE11,

NVL(TO_CHAR(VALUE_DATE12,'YYYY-MM-DD'),' ') VALUE_DATE12,

NVL(TO_CHAR(VALUE_DATE13,'YYYY-MM-DD'),' ') VALUE_DATE13,

NVL(TO_CHAR(VALUE_DATE14,'YYYY-MM-DD'),' ') VALUE_DATE14,

NVL(TO_CHAR(VALUE_DATE15,'YYYY-MM-DD'),' ') VALUE_DATE15,

NVL(TO_CHAR(VALUE_DATE16,'YYYY-MM-DD'),' ') VALUE_DATE16,

NVL(TO_CHAR(VALUE_DATE17,'YYYY-MM-DD'),' ') VALUE_DATE17,

NVL(TO_CHAR(VALUE_DATE18,'YYYY-MM-DD'),' ') VALUE_DATE18,

NVL(TO_CHAR(VALUE_DATE19,'YYYY-MM-DD'),' ') VALUE_DATE19,

NVL(TO_CHAR(VALUE_DATE20,'YYYY-MM-DD'),' ') VALUE_DATE20,

NVL(TO_CHAR(VALUE_DATE21,'YYYY-MM-DD'),' ') VALUE_DATE21,

NVL(TO_CHAR(VALUE_DATE22,'YYYY-MM-DD'),' ') VALUE_DATE22,

NVL(TO_CHAR(VALUE_DATE23,'YYYY-MM-DD'),' ') VALUE_DATE23,

NVL(TO_CHAR(VALUE_DATE24,'YYYY-MM-DD'),' ') VALUE_DATE24,

NVL(TO_CHAR(VALUE_DATE25,'YYYY-MM-DD'),' ') VALUE_DATE25,

NVL(TO_CHAR(VALUE_TIMESTAMP1,'YYYY-MM-DD HH:MM:SS'),' ') VALUE_TIMESTAMP1,

NVL(TO_CHAR(VALUE_TIMESTAMP2,'YYYY-MM-DD HH:MM:SS'),' ') VALUE_TIMESTAMP2,

NVL(TO_CHAR(VALUE_TIMESTAMP3,'YYYY-MM-DD HH:MM:SS'),' ') VALUE_TIMESTAMP3,

NVL(TO_CHAR(VALUE_TIMESTAMP4,'YYYY-MM-DD HH:MM:SS'),' ') VALUE_TIMESTAMP4,

NVL(TO_CHAR(VALUE_TIMESTAMP5,'YYYY-MM-DD HH:MM:SS'),' ') VALUE_TIMESTAMP5,

NVL(TO_CHAR(VALUE_TIMESTAMP6,'YYYY-MM-DD HH:MM:SS'),' ') VALUE_TIMESTAMP6,

NVL(TO_CHAR(VALUE_TIMESTAMP7,'YYYY-MM-DD HH:MM:SS'),' ') VALUE_TIMESTAMP7,

NVL(TO_CHAR(VALUE_TIMESTAMP8,'YYYY-MM-DD HH:MM:SS'),' ') VALUE_TIMESTAMP8,

NVL(TO_CHAR(VALUE_TIMESTAMP9,'YYYY-MM-DD HH:MM:SS'),' ') VALUE_TIMESTAMP9,

NVL(TO_CHAR(VALUE_TIMESTAMP10,'YYYY-MM-DD HH:MM:SS'),' ') VALUE_TIMESTAMP10,

NVL(TO_CHAR(VALUE_TIMESTAMP11,'YYYY-MM-DD HH:MM:SS'),' ') VALUE_TIMESTAMP11,

NVL(TO_CHAR(VALUE_TIMESTAMP12,'YYYY-MM-DD HH:MM:SS'),' ') VALUE_TIMESTAMP12,

NVL(TO_CHAR(VALUE_TIMESTAMP13,'YYYY-MM-DD HH:MM:SS'),' ') VALUE_TIMESTAMP13,

NVL(TO_CHAR(VALUE_TIMESTAMP14,'YYYY-MM-DD HH:MM:SS'),' ') VALUE_TIMESTAMP14,

NVL(TO_CHAR(VALUE_TIMESTAMP15,'YYYY-MM-DD HH:MM:SS'),' ') VALUE_TIMESTAMP15,

NVL(TO_CHAR(VALUE_TIMESTAMP16,'YYYY-MM-DD HH:MM:SS'),' ') VALUE_TIMESTAMP16,

NVL(TO_CHAR(VALUE_TIMESTAMP17,'YYYY-MM-DD HH:MM:SS'),' ') VALUE_TIMESTAMP17,

NVL(TO_CHAR(VALUE_TIMESTAMP18,'YYYY-MM-DD HH:MM:SS'),' ') VALUE_TIMESTAMP18,

NVL(TO_CHAR(VALUE_TIMESTAMP19,'YYYY-MM-DD HH:MM:SS'),' ') VALUE_TIMESTAMP19,

NVL(TO_CHAR(VALUE_TIMESTAMP20,'YYYY-MM-DD HH:MM:SS'),' ') VALUE_TIMESTAMP20,

NVL(TO_CHAR(VALUE_TIMESTAMP21,'YYYY-MM-DD HH:MM:SS'),' ') VALUE_TIMESTAMP21,

NVL(TO_CHAR(VALUE_TIMESTAMP22,'YYYY-MM-DD HH:MM:SS'),' ') VALUE_TIMESTAMP22,

NVL(TO_CHAR(VALUE_TIMESTAMP23,'YYYY-MM-DD HH:MM:SS'),' ') VALUE_TIMESTAMP23,

NVL(TO_CHAR(VALUE_TIMESTAMP24,'YYYY-MM-DD HH:MM:SS'),' ') VALUE_TIMESTAMP24,

NVL(TO_CHAR(VALUE_TIMESTAMP25,'YYYY-MM-DD HH:MM:SS'),' ') VALUE_TIMESTAMP25,

DYNAMIC_MATRIX_ID,

DYNAMIC_MATRIX_RULE_ID

FROM QP_MATRIX_RULES

) UNPIVOT( COLUMN_VALUE FOR (COLUMN_NAME) IN(VALUE_NUMBER1,VALUE_NUMBER2,VALUE_NUMBER3,VALUE_NUMBER4,VALUE_NUMBER5, VALUE_NUMBER6,VALUE_NUMBER7,VALUE_NUMBER8,VALUE_NUMBER9,VALUE_NUMBER10,VALUE_NUMBER11,VALUE_NUMBER12,VALUE_NUMBER13,VALUE_NUMBER14,VALUE_NUMBER15, VALUE_NUMBER16,VALUE_NUMBER17,VALUE_NUMBER18,VALUE_NUMBER19,VALUE_NUMBER20,VALUE_NUMBER21,VALUE_NUMBER22,VALUE_NUMBER23,VALUE_NUMBER24,VALUE_NUMBER25,VALUE_STRING1,VALUE_STRING2,VALUE_STRING3,VALUE_STRING4,VALUE_STRING5,VALUE_STRING6,VALUE_STRING7,VALUE_STRING8,VALUE_STRING9,VALUE_STRING10,VALUE_STRING11,VALUE_STRING12,VALUE_STRING13,VALUE_STRING14,VALUE_STRING15,VALUE_STRING16,VALUE_STRING17,VALUE_STRING18,VALUE_STRING19,VALUE_STRING20,VALUE_STRING21,VALUE_STRING22,VALUE_STRING23,VALUE_STRING24,VALUE_STRING25,VALUE_DATE1,VALUE_DATE2,VALUE_DATE3,VALUE_DATE4,VALUE_DATE5,VALUE_DATE6,VALUE_DATE7,VALUE_DATE8,VALUE_DATE9,VALUE_DATE10,VALUE_DATE11,VALUE_DATE12,VALUE_DATE13,VALUE_DATE14,VALUE_DATE15,VALUE_DATE16,VALUE_DATE17,VALUE_DATE18,VALUE_DATE19,VALUE_DATE20,VALUE_DATE21,VALUE_DATE22,VALUE_DATE23,VALUE_DATE24,VALUE_DATE25,VALUE_TIMESTAMP1,VALUE_TIMESTAMP2,VALUE_TIMESTAMP3,VALUE_TIMESTAMP4,VALUE_TIMESTAMP5,VALUE_TIMESTAMP6,VALUE_TIMESTAMP7,VALUE_TIMESTAMP8,VALUE_TIMESTAMP9,VALUE_TIMESTAMP10,VALUE_TIMESTAMP11,VALUE_TIMESTAMP12,VALUE_TIMESTAMP13,VALUE_TIMESTAMP14,VALUE_TIMESTAMP15,VALUE_TIMESTAMP16,VALUE_TIMESTAMP17,VALUE_TIMESTAMP18,VALUE_TIMESTAMP19,VALUE_TIMESTAMP20,VALUE_TIMESTAMP21,VALUE_TIMESTAMP22,VALUE_TIMESTAMP23,VALUE_TIMESTAMP24,VALUE_TIMESTAMP25) )

) b

WHERE a.ATTRIBUTE_TYPE = b.COLUMN_NAME

AND a.DYNAMIC_MATRIX_ID = b.DYNAMIC_MATRIX_ID

)

GROUP BY DYNAMIC_MATRIX_ID,

DYNAMIC_MATRIX_RULE_ID