Home » Developer & Programmer » Warehouse Builder » 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: Sat Aug 30 21:17:44 CDT 2014

Total time taken to generate the page: 0.09712 seconds