exec dbms_aw.execute('LIMIT GOOD_DIM TO HIERARCHY DEPTH 1 SKIP 0 USING GOOD_DIM_PARENTREL ''COUNTRY_LEV_England''');
exec dbms_aw.execute('LIMIT GOOD_DIM ADD HIERARCHY DEPTH 1 SKIP 0 USING GOOD_DIM_PARENTREL ''FIRM_LEV_Reebok''');
select sum(meas)
from   table
       (
           olap_table('AWG DURATION SESSION', '', '',
           'MEASURE meas FROM CUB_QUANTITY
            DIMENSION D1 FROM GOOD_DIM WITH
                HIERARCHY GOOD_DIM_PARENTREL(GOOD_DIM_HIERLIST ''COUNTRY_HIER'')
                INHIERARCHY GOOD_DIM_INHIER
            DIMENSION D2 FROM GOOD_DIM WITH
                HIERARCHY GOOD_DIM_PARENTREL(GOOD_DIM_HIERLIST ''FIRM_HIER'')
                INHIERARCHY GOOD_DIM_INHIER'
           )
       );