VIEW: OLAPSYS.ALL$OLAP2_RUFCTTBLKYMAPS

Source

View Text - Preformatted

select flu.owner owner,
           flu.cube_name cube_name,
           flu.dim_hier_combo_id dim_hier_combo_id,
           flu.dimension_owner dimension_owner,
           flu.dimension_name dimension_name,
           flu.hierarchy_name hierarchy_name,
           flu.fact_table_owner fact_table_owner,
           flu.fact_table_name fact_table_name,
          flu.column_name column_name,
          ftg.column_name gid_column_name
   from olapsys.all$olap2_fact_level_uses flu,
        olapsys.all$olap2_dim_levels_keymaps lkm,
        olapsys.all$olap2_fact_table_gid ftg
   where
     flu.dimension_keymap_type = 'RU' and
     flu.dimension_owner = lkm.owner and
     flu.dimension_name = lkm.dimension_name and
     flu.hierarchy_name = lkm.hierarchy_name and
     flu.level_name = lkm.level_name and
     flu.owner = ftg.owner
     and flu.cube_name = ftg.cube_name
     and flu.dimension_owner = ftg.dimension_owner
     and flu.dimension_name = ftg.dimension_name
     and flu.hierarchy_name = ftg.hierarchy_name
     and flu.dim_hier_combo_id = ftg.dim_hier_combo_id
     and flu.fact_table_owner = ftg.fact_table_owner
     and flu.fact_table_name = ftg.fact_table_name
  order by flu.owner asc, flu.cube_name asc, flu.dim_hier_combo_id asc,
    flu.dimension_owner asc, flu.dimension_name asc, flu.hierarchy_name asc,
    lkm.pos desc

View Text - HTML Formatted

SELECT FLU.OWNER OWNER
, FLU.CUBE_NAME CUBE_NAME
, FLU.DIM_HIER_COMBO_ID DIM_HIER_COMBO_ID
, FLU.DIMENSION_OWNER DIMENSION_OWNER
, FLU.DIMENSION_NAME DIMENSION_NAME
, FLU.HIERARCHY_NAME HIERARCHY_NAME
, FLU.FACT_TABLE_OWNER FACT_TABLE_OWNER
, FLU.FACT_TABLE_NAME FACT_TABLE_NAME
, FLU.COLUMN_NAME COLUMN_NAME
, FTG.COLUMN_NAME GID_COLUMN_NAME
FROM OLAPSYS.ALL$OLAP2_FACT_LEVEL_USES FLU
, OLAPSYS.ALL$OLAP2_DIM_LEVELS_KEYMAPS LKM
, OLAPSYS.ALL$OLAP2_FACT_TABLE_GID FTG WHERE FLU.DIMENSION_KEYMAP_TYPE = 'RU' AND FLU.DIMENSION_OWNER = LKM.OWNER AND FLU.DIMENSION_NAME = LKM.DIMENSION_NAME AND FLU.HIERARCHY_NAME = LKM.HIERARCHY_NAME AND FLU.LEVEL_NAME = LKM.LEVEL_NAME AND FLU.OWNER = FTG.OWNER
AND FLU.CUBE_NAME = FTG.CUBE_NAME
AND FLU.DIMENSION_OWNER = FTG.DIMENSION_OWNER
AND FLU.DIMENSION_NAME = FTG.DIMENSION_NAME
AND FLU.HIERARCHY_NAME = FTG.HIERARCHY_NAME
AND FLU.DIM_HIER_COMBO_ID = FTG.DIM_HIER_COMBO_ID
AND FLU.FACT_TABLE_OWNER = FTG.FACT_TABLE_OWNER
AND FLU.FACT_TABLE_NAME = FTG.FACT_TABLE_NAME ORDER BY FLU.OWNER ASC
, FLU.CUBE_NAME ASC
, FLU.DIM_HIER_COMBO_ID ASC
, FLU.DIMENSION_OWNER ASC
, FLU.DIMENSION_NAME ASC
, FLU.HIERARCHY_NAME ASC
, LKM.POS DESC