This discussion is archived
1 Reply Latest reply: Oct 15, 2012 9:36 AM by Srini VEERAVALLI RSS

OBIEE Report - Trouble finding the actual results

967862 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points