6 Replies Latest reply: Jan 11, 2010 4:01 AM by ask123 RSS

Data Model

ask123

Hi,

I have follwoing two fact table and one dimension table.

Sales: InvoiceNo,Invoicedate,item code,item qty,Sales Amount,cost

Invnetory: item code, Qty on Hand, Inventory Value

Item: Item Code, Item desc, Product group, Product Sub group

How can I create data model in QV for above data.

Thanks.