Home » Developer & Programmer » Data Integration » Crossing hierarhies
icon5.gif  Crossing hierarhies [message #173462] Mon, 22 May 2006 10:47
GOster
Messages: 1
Registered: May 2006
Location: Russia
Junior Member

Hi!

I've got "goods" dimension. This dimension includes two hierarchies: countries and firms. I need to view a report with axes - country and firm. How can I do that?
I have decision for one firm and one country:

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'
           )
       );


But that doesn't work for several members.

Thanks.
Previous Topic: VLD-2771: System privileges may not allow extraction from source BPS_MV_GROUPMEMB
Next Topic: OWB - access remote table using DB link
Goto Forum:
  


Current Time: Fri Mar 29 01:16:03 CDT 2024