VIEW: QPR.QPR_MEAS_AGGRS#

Source

View Text - Preformatted

select MEAS_AGG_ID MEAS_AGG_ID, CUBE_DIM_ID CUBE_DIM_ID, MEASURE_ID MEASURE_ID, PRICE_PLAN_ID PRICE_PLAN_ID, TEMPLATE_FLAG TEMPLATE_FLAG, SEEDED_FLAG SEEDED_FLAG, OVERRIDE_FLAG OVERRIDE_FLAG, AGGMAP_NAME AGGMAP_NAME, AGGMAP_CACHE_STORE AGGMAP_CACHE_STORE, AGGMAP_CACHE_NA AGGMAP_CACHE_NA, DIM_OPCODE DIM_OPCODE, SET_LEVEL_FLAG SET_LEVEL_FLAG, DIM_EXPRESSION_TYPE DIM_EXPRESSION_TYPE, DIM_EXPRESSION DIM_EXPRESSION, WEIGHTED_MEASURE_FLAG WEIGHTED_MEASURE_FLAG, WEIGHT_MEASURE_NAME WEIGHT_MEASURE_NAME, WNAFILL WNAFILL, DIVIDE_BY_ZERO_FLAG DIVIDE_BY_ZERO_FLAG, DECIMAL_OVERFLOW_FLAG DECIMAL_OVERFLOW_FLAG, NASKIP_FLAG NASKIP_FLAG, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, PROGRAM_ID PROGRAM_ID, PROGRAM_LOGIN_ID PROGRAM_LOGIN_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, REQUEST_ID REQUEST_ID from "QPR"."QPR_MEAS_AGGRS"

View Text - HTML Formatted

SELECT MEAS_AGG_ID MEAS_AGG_ID
, CUBE_DIM_ID CUBE_DIM_ID
, MEASURE_ID MEASURE_ID
, PRICE_PLAN_ID PRICE_PLAN_ID
, TEMPLATE_FLAG TEMPLATE_FLAG
, SEEDED_FLAG SEEDED_FLAG
, OVERRIDE_FLAG OVERRIDE_FLAG
, AGGMAP_NAME AGGMAP_NAME
, AGGMAP_CACHE_STORE AGGMAP_CACHE_STORE
, AGGMAP_CACHE_NA AGGMAP_CACHE_NA
, DIM_OPCODE DIM_OPCODE
, SET_LEVEL_FLAG SET_LEVEL_FLAG
, DIM_EXPRESSION_TYPE DIM_EXPRESSION_TYPE
, DIM_EXPRESSION DIM_EXPRESSION
, WEIGHTED_MEASURE_FLAG WEIGHTED_MEASURE_FLAG
, WEIGHT_MEASURE_NAME WEIGHT_MEASURE_NAME
, WNAFILL WNAFILL
, DIVIDE_BY_ZERO_FLAG DIVIDE_BY_ZERO_FLAG
, DECIMAL_OVERFLOW_FLAG DECIMAL_OVERFLOW_FLAG
, NASKIP_FLAG NASKIP_FLAG
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, PROGRAM_ID PROGRAM_ID
, PROGRAM_LOGIN_ID PROGRAM_LOGIN_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, REQUEST_ID REQUEST_ID
FROM "QPR"."QPR_MEAS_AGGRS"