topic Re: Data Model in QlikView

Data Model

Anonymous — Mon, 09 Nov 2015 04:52:27 GMT

Hello All,

Please help me in daat modeling,

Following is the structure which we have to follow

Re: Data Model

Anonymous — Mon, 09 Nov 2015 05:14:32 GMT

What is your problem?

Do you have all these tables?

What issue you are facing?

From this image , you are getting circular loop. To avoid that, you need to do two things:

1) Comment/Rename/Delete Related ECR No from ECO table

2) Comment/Rename/Delete Related EC0 No from MCO table

After these you would be having a Star Schema...

Hope this will help!!

Re: Data Model

jonathandienst — Mon, 09 Nov 2015 05:15:03 GMT

You will not be able to implement the structure in your diagram due to the loops (multiple possible pathways between fields). It is hard to give you specific advice without a lot more knowledge of your system and requirements, but the two general methods for multiple fact monitoring are link tables or concatenation/joining of the tables.These documents may help:

Advanced topics for creating a qlik datamodel

Re: Data Model

Anonymous — Mon, 09 Nov 2015 05:36:11 GMT

Hi Nitin,

if you want perform a data molding based on current diagram you can probably do a following steps.

1) You have to break this loop.

2) Join ECR & ECO to get related ECR No and Join ECO & MCO to get related ECO No.

3) Keep PCR table at center table.

4) Rest all things are correct.

Thanks

harinder

Re: Data Model

Anonymous — Mon, 09 Nov 2015 06:20:07 GMT

Hi Jonathan,

Thanks for the reply,

I understand the concepts but the requirement is so that I am having 5 tables and the relation between these tables were shown as per image.

Now I have to create these relations into QV data model ,

I cannot comment any of the relation to build star of just to remove the loop.

Actually IN PCR Table I am having related ECR,ECO and MCO numbers ,

while ECR, ECO and MCO tables are just like a hierarchy, where ECR can be parent to ECO and ECO to MCO.

These all three can directly be child of PCR.

Hope now Iam able to provide better understanding of requirement.

Regards

Nitin

Re: Data Model

Anonymous — Mon, 09 Nov 2015 06:24:20 GMT

PCR would be your fact table,

as I have already suggested you, you would be maintaing the same relationship.

Also if you are not dropping any field, but you need to follow the approach to build a model or relationship.

Even building a model is all about relationship and those relationship will automatically create the schema.

Re: Data Model

Anonymous — Mon, 09 Nov 2015 06:38:50 GMT

Yes this can definately create the star but renaming or deleting these fields will break the relations of

ECO & aMCO and even ECR & ECO.

This is not acceptable.

Actually its type of hierarchy

ECR>ECO>MCO,

So ECO is having Related ECR, while MCO is having Related ECO.

Now these tables may be having direct parents as PCR ,/

So ECR can have a PCR, or ECO can have a PCR or MCO can have a parent PCR.

Re: Data Model

himanshi — Mon, 09 Nov 2015 06:56:29 GMT

hiii ,

You can use joins to remove loops btw tables.

Re: Data Model

Anonymous — Mon, 09 Nov 2015 07:07:45 GMT

No need to worry, you just rename and when you wud create relationship, through PCR table you would be able to access all these info.

like: PCR->ECR, PCR->ECO etc