"Ather Mian" <ather@nowwhere.com> wrote in message
news:uwXQI0POEHA.2100@TK2MSFTNGP11.phx.gbl...
> Hi,
>
>
>
> I am trying to set up an orders datamart, which would be fed from our ERP
> daily. Requirement is to know at any given time what are the bookings,
what
> is the backlog and how much has been billed. I am trying to create a
> dimensional model. My structure is as follows.
>
>
>
> Table 1 Order: OrdID, CustID, EmployeeID, Country
>
> Table 2 Products: ProdID, ProdLine
>
> Table 3 Customers CustID, CustName
>
> Table 5 Employees: Employee ID, EmployeeName
>
> Table 5 Fact Table: Ord ID, ProdID, CustID,EmployeeID, Order Date, Invoice
> Date, OrderQty, InvoicedQty, BacklogQty,Cost/Unit, Selling PricePer Unit
>
>
>
> My problem is that for the orders that are unshipped would have a null
date.
> I was thinking of having two fact tables one for Booking and Backlog and
> another one for Billing to avoid the null date problem or Is there a way
to
> do this with one fact table.
>
>
>
> Any help would be greatly appreciated.
>
>
>
> Thanks
>
>
>
> Ather
>
>

"Ather Mian" <ather@nowwhere.com> wrote in message
news:uwXQI0POEHA.2100@TK2MSFTNGP11.phx.gbl...
> Hi,
>
>
>
> I am trying to set up an orders datamart, which would be fed from our ERP
> daily. Requirement is to know at any given time what are the bookings,
what
> is the backlog and how much has been billed. I am trying to create a
> dimensional model. My structure is as follows.
>
>
>
> Table 1 Order: OrdID, CustID, EmployeeID, Country
>
> Table 2 Products: ProdID, ProdLine
>
> Table 3 Customers CustID, CustName
>
> Table 5 Employees: Employee ID, EmployeeName
>
> Table 5 Fact Table: Ord ID, ProdID, CustID,EmployeeID, Order Date, Invoice
> Date, OrderQty, InvoicedQty, BacklogQty,Cost/Unit, Selling PricePer Unit
>
>
>
> My problem is that for the orders that are unshipped would have a null
date.
> I was thinking of having two fact tables one for Booking and Backlog and
> another one for Billing to avoid the null date problem or Is there a way
to
> do this with one fact table.
>
>
>
> Any help would be greatly appreciated.
>
>
>
> Thanks
>
>
>
> Ather
>
>

> Hi,
>
>
>
> I am trying to set up an orders datamart, which would be fed from our ERP
> daily. Requirement is to know at any given time what are the bookings,
what
> is the backlog and how much has been billed. I am trying to create a
> dimensional model. My structure is as follows.
>
>
>
> Table 1 Order: OrdID, CustID, EmployeeID, Country
>
> Table 2 Products: ProdID, ProdLine
>
> Table 3 Customers CustID, CustName
>
> Table 5 Employees: Employee ID, EmployeeName
>
> Table 5 Fact Table: Ord ID, ProdID, CustID,EmployeeID, Order Date, Invoice
> Date, OrderQty, InvoicedQty, BacklogQty,Cost/Unit, Selling PricePer Unit
>
>
>
> My problem is that for the orders that are unshipped would have a null
date.
> I was thinking of having two fact tables one for Booking and Backlog and
> another one for Billing to avoid the null date problem or Is there a way
to
> do this with one fact table.
>
>
>
> Any help would be greatly appreciated.
>
>
>
> Thanks
>
>
>
> Ather
>
>