Oracle Business Intelligence, querying in two fact tables
Let me explain the problem providing information about the modelling made in Administration tool.....
Physical Layer
Objects:
1)SQL that brings ve_code (Vendor code),Shop_code, ei_code (Items code), Trans_date, qty, amnt, mixed Profit
2)Alias of the Above
3) Vendor_table (joined by ve_code with above tables)
4)Items table (containing Items_Year, Season) Joined with (1) and (2)
4)Alias of (4)
5) Shop Table (containing Shop's Brand and Descr) Joined by ge_shop_code with (1) and (2)
6) Alias Of (5)
7) Brand Table (containing Brand Name joined with (5)
8) Alias of (7) joined with (6)
Business Layer
A)SALES 1 (measures from (1))
B)SALES 2 (measures from (2))
C)TIMES (trans_date from (1) Complex join with (A))
Physical Layer
Objects:
1)SQL that brings ve_code (Vendor code),Shop_code, ei_code (Items code), Trans_date, qty, amnt, mixed Profit
2)Alias of the Above
3) Vendor_table (joined by ve_code with above tables)
4)Items table (containing Items_Year, Season) Joined with (1) and (2)
4)Alias of (4)
5) Shop Table (containing Shop's Brand and Descr) Joined by ge_shop_code with (1) and (2)
6) Alias Of (5)
7) Brand Table (containing Brand Name joined with (5)
8) Alias of (7) joined with (6)
Business Layer
A)SALES 1 (measures from (1))
B)SALES 2 (measures from (2))
C)TIMES (trans_date from (1) Complex join with (A))
0