DBA Data[Home] [Help]

VIEW: OLAPSYS.DBA$OLAP2UDIM_ATTR_USES

Source

View Text - Preformatted

select owner, dimension_name, dim_attribute_name, level_name, lvl_attribute_name
from olapsys.dba$olap_dim_attr_uses
union all
select owner, dimension_name, dim_attribute_name, level_name, lvl_attribute_name
from dba$olap2_dim_attr_uses
with read only
View Text - HTML Formatted

SELECT OWNER
, DIMENSION_NAME
, DIM_ATTRIBUTE_NAME
, LEVEL_NAME
, LVL_ATTRIBUTE_NAME FROM OLAPSYS.DBA$OLAP_DIM_ATTR_USES UNION ALL SELECT OWNER
, DIMENSION_NAME
, DIM_ATTRIBUTE_NAME
, LEVEL_NAME
, LVL_ATTRIBUTE_NAME FROM DBA$OLAP2_DIM_ATTR_USES WITH READ ONLY