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

    Data Model



      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.