3 Replies Latest reply on Nov 28, 2013 10:16 AM by .

    OBIEE 10G answers - 2 facts with different dimensions

    nianzhang

      E.g.

      fact 1: sales.

      Related dimensions: branch, time, product

       

      fact 2: promotions:

      Related dimensions: branch, time, promotion code

       

      Both of these two facts and related dimensions are star schemas.

       

      Both facts alone run OK.

       

      What I want:

      branch, time, promotion code, sales, promotions

       

      In SQL it would be something like (pseudo code):

      select t1.*, t2.promotion code, t2.promotions

      from

      (

      select branch, time, sales

      from branch, time, sales

      where --joins and filters

      ) t1

       

      left outer join

       

      (

      select branch, time, promotion code, promotions

      from branch, time, promotion code, promotions

      where --joins and filters

      ) t2

      on t1.branch = t2.branch

      and t1. time = t2.time

       

      I am not sure is this doable in OBIEE, or should I just use SQL?