1 2 Previous Next 15 Replies Latest reply: Apr 8, 2013 9:22 AM by Roy O'Toole RSS

    need to pull the information from two facts and associated dimensions

      HI All, i need to pull all the columns from the two Facts and their associated dimensions, get the results.

      here is the example:

      Fact1 --> D1, D2, D3
      FACT2--> DA, DB, DC, D1

      D1 Dimension has a Join with two fact tables, as long as i'm using columns from D1 and FACT2, DA, DB, DC report works.

      but my requirement is to get the results when pulling the columns from all the dimensions and two facts like Fact1, FACT2, D1, D2, D3, DA, DB, DC

      how to achieve this requirement, can someone pls help me with this.

      your responses are much appreciated.

        1 2 Previous Next