SELECT level1_desc as DSB_DESC, level1_value as DSB_SR_LEVEL_PK, level1_value as DSB_LEVEL_VALUE, level1_attribute1 as DSB_ATTRIBUTE1, level1_attribute2 as DSB_ATTRIBUTE2, level1_attribute3 as DSB_ATTRIBUTE3, level1_attribute4 as DSB_ATTRIBUTE4, level1_attribute5 as DSB_ATTRIBUTE5, instance_id as INSTANCE_ID from qpr_dimension_values WHERE dim_code='DSB' and hierarchy_code = 'DISC_BAND'
SELECT LEVEL1_DESC AS DSB_DESC
, LEVEL1_VALUE AS DSB_SR_LEVEL_PK
, LEVEL1_VALUE AS DSB_LEVEL_VALUE
, LEVEL1_ATTRIBUTE1 AS DSB_ATTRIBUTE1
, LEVEL1_ATTRIBUTE2 AS DSB_ATTRIBUTE2
, LEVEL1_ATTRIBUTE3 AS DSB_ATTRIBUTE3
, LEVEL1_ATTRIBUTE4 AS DSB_ATTRIBUTE4
, LEVEL1_ATTRIBUTE5 AS DSB_ATTRIBUTE5
, INSTANCE_ID AS INSTANCE_ID
FROM QPR_DIMENSION_VALUES
WHERE DIM_CODE='DSB'
AND HIERARCHY_CODE = 'DISC_BAND'
|
|
|