1 Reply Latest reply: Oct 15, 2012 11:36 AM by Srini VEERAVALLI RSS

    OBIEE Report - Trouble finding the actual results

    967862
      Hello Experts - Good Morning.

      I have a requirement - As I am so new to OBIEE.. Trouble finding the actual results...Appriciate your time.....

      I have 3 tables - 2 dimension (Product, Customer), 1 Fact (Dollars) as below - I want to have a report as Dollars by Customer for a specific product group below is the structure and Desired result output.

      Customer Table:


      Customer ID - Customer Name
      1 - Tom
      2 - Jill
      3 - Caron



      Product Table:


      Product ID - Product Type - Product Key
      100 - DL - 28
      200 - HS - 28

      Dollars (Fact):


      Universal ID - Dollars - Customer ID - Product ID
      1001 - 2222 - 1 - 100
      1001 - 0 - 2 - 200
      1002 - 3333 - 1 - 100
      1002 - 0 - 3 - 200
      1003 - 4444 - 1 - 100
      1003 - 0 - 3 - 200

      Want to See the Result as below (Like Profit by each customer for Product Key =28)

      Customer Name - Dollars
      Tom - 0
      Jill - 2222
      Caron - 7777

      Condition: Where Product Key = 28