Search results for query: *

you can do basically two type of analyses on this 1/ which orders that are submitted in week 1 are prepared,shipped, ... (flow of the orders) 2/ how many orders are submitted in week 1, how many are prepared in week 1,... (nr per activity) You seem to have built you're fact table to support...

hello, Does anyone know whether it's possible to connect to mysql databases using owb and whether all features are available on these tables? or is the only way to copy the tables using other programs to an oracle db. Don't seem to find any docs on this at oracle so I assume it'll be the second...

thanks, that's what I've done in the mean time and performance is ok.

To keep it simple, we have three tables: order, holidays and stores order: id |Store | OrderDate | scan@WarehouseDate | Scan@StoreDate 1 |123 | 01/01/2007| 02/01/2007 | 04/01/2007 holidays: Date | Country | Quantity 01/01/2007| Es | 1 Stores Store |Mo |Tu |We |Th...

Hello, a question on coding. We deliver orders to stores and want to measure the delay between the order and the delivery. we have three timestamps: order, scan at warehouse and scan at store. we need to know the delay between all steps. All stores have one or more closingdays, the warehouse is...

oracle has some nice docs on this: http://www.oracle.com/pls/db102/portal.portal_db?selected=6 datawarehousing guide will give you a lot of info.

2/ in case of using oracle you can use the merge statement which is, in case record doesn't exist insert one, else update the existing one. Most probably other databases have simular thing. Anyways, you always have a primary key on which you can join.