Data Model Problem

[#1]

Hi,

Order Header:

LOAD

            Order ID,

            Order Date,

            Customer ID,

           SalesRepID,

           Sub Total,

           Modified Date,

           Total Due 

FROM Order Header;

Item Request:

LOAD

               ItemRequestID,

               ItemRequestTypeID,

              Order ID,

              Company

              Modified Date,

              Customer Name

FROM Item Request;

Customer:

LOAD

               Customer ID,

               Customer Code,

               Customer Name,

               Modified Date

               SalesRepID

     FROM  Customer;

Order Version:

LOAD

                Version Id,

                Order ID,

               Total Due   

               Modified Date    

FROM  Order Version;

How to design Data Model?

Ramu

Please Help Me

Thank You.

[agni_gold]

• Customer is dimension
• Order Header  is dimension ,Left Join Order Header with Order Version to make One Dimension Order_Header
• Item Description is your fact

[agni_gold]

Or send me any specific requirement, you want

[engishfaque]

Dear Ramanjaneyulu,

I hope you are looking for this one.

Kindly find attached App and Data Model.

Kind regards,

Ishfaque Ahmed

[#5]

Thank you

[#6]

Thank you

[jonathandienst]

How big is your data set?

The queries you posted are quite well structured and may be sufficient. QV will automatically create the associations on the common field names, but with that date I see no composite keys or a need to do any transformations.

If your data set is large (>>10 million rows or more), then some optimisation may be necessary, subject to testing.

[anat]

PFA...

[jonathandienst]

If your question has been answered, please close off this thread by indicating an answer.