The dimension CUST_REG_DIM and the hierarchy CUST_REG_HIER inside the Analytic Workspace are accessible to relational SQL queries via views which are created by the AWM tool. Figures 11 and 12 below show relevant details about these views: The view CUST_REG_DIM_VIEW … Continue reading Oracle Query Rewrite to Cube-Organized Materialized Views – Page 2