VIEW: OLAPSYS.ALL$OLAP2_AGGREGATION_USES

Source

View Text - Preformatted

select
  aggop.owner owner,
  aggop.cube_name cube_name,
  aggop.dimension_owner dimension_owner,
  aggop.dimension_name dimension_name,
  aggop.hierarchy_name hierarchy_name,
  aggop.dim_hier_combo_id dim_hier_combo_id,
  aggop.aggregation_name aggregation_name,
  aggop.aggregation_order aggregation_order,
  aggwb.table_owner table_owner,
  aggwb.table_name table_name,
  aggwb.column_name column_name
from olapsys.all$olap2_agg_operator_uses aggop,
     olapsys.all$olap2_agg_weightby_uses aggwb
where aggop.owner = aggwb.owner (+) and
      aggop.cube_name = aggwb.cube_name (+) and
      aggop.dimension_owner = aggwb.dimension_owner (+) and
      aggop.dimension_name = aggwb.dimension_name (+) and
      aggop.hierarchy_name = aggwb.hierarchy_name (+)
with read only

View Text - HTML Formatted

SELECT AGGOP.OWNER OWNER
, AGGOP.CUBE_NAME CUBE_NAME
, AGGOP.DIMENSION_OWNER DIMENSION_OWNER
, AGGOP.DIMENSION_NAME DIMENSION_NAME
, AGGOP.HIERARCHY_NAME HIERARCHY_NAME
, AGGOP.DIM_HIER_COMBO_ID DIM_HIER_COMBO_ID
, AGGOP.AGGREGATION_NAME AGGREGATION_NAME
, AGGOP.AGGREGATION_ORDER AGGREGATION_ORDER
, AGGWB.TABLE_OWNER TABLE_OWNER
, AGGWB.TABLE_NAME TABLE_NAME
, AGGWB.COLUMN_NAME COLUMN_NAME FROM OLAPSYS.ALL$OLAP2_AGG_OPERATOR_USES AGGOP
, OLAPSYS.ALL$OLAP2_AGG_WEIGHTBY_USES AGGWB WHERE AGGOP.OWNER = AGGWB.OWNER (+) AND AGGOP.CUBE_NAME = AGGWB.CUBE_NAME (+) AND AGGOP.DIMENSION_OWNER = AGGWB.DIMENSION_OWNER (+) AND AGGOP.DIMENSION_NAME = AGGWB.DIMENSION_NAME (+) AND AGGOP.HIERARCHY_NAME = AGGWB.HIERARCHY_NAME (+) WITH READ ONLY