topic Re: Data Model Problem in QlikView

Data Model Problem

Mon, 21 Sep 2015 12:10:37 GMT

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.

Re: Data Model Problem

agni_gold — Mon, 21 Sep 2015 14:32:12 GMT

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

Re: Data Model Problem

agni_gold — Mon, 21 Sep 2015 14:32:45 GMT

Or send me any specific requirement, you want

Re: Data Model Problem

engishfaque — Tue, 22 Sep 2015 04:54:53 GMT

Dear Ramanjaneyulu,

I hope you are looking for this one.

Kindly find attached App and Data Model.

Kind regards,

Ishfaque Ahmed

Re: Data Model Problem

Tue, 22 Sep 2015 05:27:44 GMT

Thank you

Re: Data Model Problem

Tue, 22 Sep 2015 05:28:21 GMT

Thank you

Re: Data Model Problem

jonathandienst — Tue, 22 Sep 2015 05:35:36 GMT

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.

Re: Data Model Problem

anat — Tue, 29 Sep 2015 06:28:38 GMT

PFA...

Re: Data Model Problem

jonathandienst — Tue, 29 Sep 2015 07:50:22 GMT

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