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 ID - Customer Name
1 - Tom
2 - Jill
3 - Caron
Product ID - Product Type - Product Key
100 - DL - 28
200 - HS - 28
Your output is wrong. it suppose to be Jill - 9999
Just create joins among these 3 tables and create a measure in BMM as #Dollars
once you done with subject area just pull the columns CustName,dollar
this would auto sum and show you the sales by each customer