topic Re: Bad or Good relation ? in QlikView

Bad or Good relation ?

cksuperlatif — Tue, 10 Nov 2015 09:24:30 GMT

Hy,

Please i need your help, to show me if this kind of relation is correct or bad

Thank for help

Re: Bad or Good relation ?

oknotsen — Tue, 10 Nov 2015 10:32:24 GMT

Looks to me as if you can improve this data model a lot by joining a bunch of those tables.

I am also missing a fact table if you are going for a star diagram.

Re: Bad or Good relation ?

Mark_Little — Tue, 10 Nov 2015 10:35:22 GMT

Hi,

Without knowing the data it is quite hard to say. Ideally you should have a central fact table, the a snow flake schema from there.

Things to consider are

Can i join or concatenate the tables?

What is my fact table?

Hope this helps

Mark

Re: Bad or Good relation ?

marcus_sommer — Tue, 10 Nov 2015 10:37:31 GMT

If it worked and isn't too slow it's ok. - if not it should be transformed to a snowflake- or star-sheme. Are there any issues with this app?

- Marcus

Re: Bad or Good relation ?

miguelbraga — Tue, 10 Nov 2015 10:41:01 GMT

Hey Kara,

You can join all the Absence tables to create a single fact table. Try to join these tables:

Demande_Absence
Suivi_Demande_Absence
Absence
FANABS_Absence_Anulle
Absence_En_Attente

A little hint on to join them correctly:

You can make a key which you can know where the data are coming from like this: for exemple in the table Absence:

'Absence' as AbsenceType,

Hope it helps you

Regards,

Re: Bad or Good relation ?

cksuperlatif — Tue, 10 Nov 2015 15:01:09 GMT

Thank for your answer,

my problem is that I have one table Personnel which contain all information about an employee and all other table have only Matricule_Personnel as key, so if i want to have an information about him i must link to Personnel table. I dont know what else

Re: Bad or Good relation ?

marcus_sommer — Tue, 10 Nov 2015 16:22:24 GMT

Are there any issues with this app? Joinning or mapping like suggested from MiguelBraga to get lesser tables would help to reduce the complexity. But before make sure that really all fields from these tables will be needed - the document analyzer will be helpful for this: Re: Document Analyzer V2 -- a major update.

Further noticeable is that there are no association to dates - if your datamodel only a big dimension table about staff it might not needed. Otherwise I would suggest to implement a master-calendar: How to use - Master-Calendar and Date-Values and this is probably helpful, too: Get started with developing qlik datamodels.

- Marcus

Re: Bad or Good relation ?

cksuperlatif — Thu, 12 Nov 2015 09:00:59 GMT

Thank you much Marcus Sommer, I will follow your instruction