topic Data model in star in QlikView

Data model in star

Thu, 25 Nov 2010 16:07:26 GMT

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.

Data model in star

prieper — Fri, 26 Nov 2010 22:21:33 GMT

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

Data model in star

Mon, 29 Nov 2010 04:44:56 GMT

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