Home » Developer & Programmer » Warehouse Builder » Mapping a Cube - big problem
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
Previous Topic: DSS and OLAP
Next Topic: Excel to OWB odbc connection
Goto Forum:
  


Current Time: Wed Dec 17 14:18:10 CST 2014

Total time taken to generate the page: 0.16880 seconds