Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2010-11-25 11:07 AM

Data model in star

Hi community,

Please here is my problem:

After the analysis I conducted to achieve a QlikView application, I got the data model that is in the word file below:

This model has the shape of a star. My question is: Modele de données du moteur.doc

What are the problems which may occur using such a model?

Thank you.

Preview file
79 KB
543 Views
0 Likes
2 Replies
prieper
Master II
Master II
‎2010-11-26 05:21 PM

Looks pretty good,
Think that the only objection is typically that you may have problems to compare values lying in different tables on basis of entries, which are not related to keyfields.

HTH
Peter

392 Views
0 Likes
Not applicable
‎2010-11-28 11:44 PM
Author

Hi,

All the tables are linked with only one Key Field.

If you need to analyze the data at transaction level then it would be difficult based on some of the dimensions.

Please use the composite key

regards

sunil

392 Views
0 Likes