eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

VIEW: QPR.QPR_CUBE_DIMS#

Source

View Text - Preformatted


select CUBE_DIM_ID CUBE_DIM_ID, CUBE_ID CUBE_ID, PRICE_PLAN_ID PRICE_PLAN_ID, TEMPLATE_FLAG TEMPLATE_FLAG, SEEDED_FLAG SEEDED_FLAG, PRICE_PLAN_DIM_ID PRICE_PLAN_DIM_ID, DIM_SEQ_NUM DIM_SEQ_NUM, MAPPING_VIEW_NAME MAPPING_VIEW_NAME, MAP_COLUMN MAP_COLUMN, USER_MAPPING_VIEW_NAME USER_MAPPING_VIEW_NAME, USER_MAP_COLUMN USER_MAP_COLUMN, AGGMAP_NAME AGGMAP_NAME, SET_LEVEL_FLAG SET_LEVEL_FLAG, DIM_EXPRESSION_TYPE DIM_EXPRESSION_TYPE, DIM_EXPRESSION DIM_EXPRESSION, DIM_OPCODE DIM_OPCODE, 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_CUBE_DIMS"

View Text - HTML Formatted

SELECT CUBE_DIM_ID CUBE_DIM_ID
, CUBE_ID CUBE_ID
, PRICE_PLAN_ID PRICE_PLAN_ID
, TEMPLATE_FLAG TEMPLATE_FLAG
, SEEDED_FLAG SEEDED_FLAG
, PRICE_PLAN_DIM_ID PRICE_PLAN_DIM_ID
, DIM_SEQ_NUM DIM_SEQ_NUM
, MAPPING_VIEW_NAME MAPPING_VIEW_NAME
, MAP_COLUMN MAP_COLUMN
, USER_MAPPING_VIEW_NAME USER_MAPPING_VIEW_NAME
, USER_MAP_COLUMN USER_MAP_COLUMN
, AGGMAP_NAME AGGMAP_NAME
, SET_LEVEL_FLAG SET_LEVEL_FLAG
, DIM_EXPRESSION_TYPE DIM_EXPRESSION_TYPE
, DIM_EXPRESSION DIM_EXPRESSION
, DIM_OPCODE DIM_OPCODE
, 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_CUBE_DIMS"