0 Replies Latest reply: Oct 17, 2012 10:23 PM by 967314 RSS

    Snowflake schema in OBIEE 11g

      Hi Friends,

      We have a requirement where in we have something like below:

      IPID CID Account

      1000 100 10
      1000 100 20
      1000 100 30
      1000 200 40
      2000 300 50
      2000 300 60

      so the fact table would have the key for Account number(lowest level of granularity) and hence will be directly joined.

      Please help me with your inputs on what would be the pros n cons of doin a snowflake join or how else can we better implement this.

      PS : we have balancs calculated at the Account level in the fact table and we need to also calculate the balance at CID and IPID level.