Home » Developer & Programmer » Data Integration » Mapping a Cube - big problem
Mapping a Cube - big problem [message #251771] Mon, 16 July 2007 10:59
Messages: 1
Registered: July 2007
Junior Member
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

Thanks in advance,
Nuno Cachulo
Previous Topic: Excel to OWB odbc connection
Next Topic: Converting from Oracle Express Objects to Standard Form
Goto Forum:

Current Time: Sun Aug 20 01:01:04 CDT 2017

Total time taken to generate the page: 0.47283 seconds