Mapping a Cube - big problem [message #251771] |
Mon, 16 July 2007 10:59 |
Cachulo
Messages: 1 Registered: July 2007
|
Junior Member |
|
|
Hi!
Let me see if i can explain my problem...
I´m trying to map a cube, using to tables buy and sales. the buy table as many buys relative to a single product done by the company. the sales table as the sales done by the company.
In my join condition i have to join tables by the product ID, but that is not enough, as each table have various rows with the same product ID relative to different sales and buys.
So i´m trying to join table by its products ID and by the date that the product was bought. In other words, i have to select the most recent buy_date in table buy, considering the sale_date in sales.
How do I do a join like that? How do i select this buy_date from table buy? That is similar to a sql query like this
select * from buy, sales where buy.prod_id=sales.prod_id and buy_date = (select max(buy_date) from buy1 where buy_date < sale_date);
But i have to do that in OWB. i have version 10.1.0.4.0.
Thanks in advance,
Nuno Cachulo
|
|
|