Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
cksuperlatif
Contributor III
Contributor III

Bad or Good relation ?

Hy,

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

Thank for help

relation niva.jpg

7 Replies
oknotsen
Master III
Master III

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.

May you live in interesting times!
Mark_Little
Luminary
Luminary

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

marcus_sommer

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

miguelbraga
Partner - Specialist III
Partner - Specialist III

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,

MB

cksuperlatif
Contributor III
Contributor III
Author

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

marcus_sommer

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

cksuperlatif
Contributor III
Contributor III
Author

Thank you much Marcus Sommer, I will follow  your instruction