Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
trappersw
Partner - Creator
Partner - Creator

Pros and cons of an Entity-Attribute-Value model

Dear all,

What are the pros and cons of an entity-attribute-value model in Qlik Sense?

I work on a datawarehouse with such a datamodel and need a lot of (nested) front end variables to perform the calculations.

Pros in my opinion:

- one datamodel can contain data from various different and functionally disjunct sources.

- once set up, relatively easy to add another fact

Cons:

- too much business logic in the app

- difficult to maintain or rapidly change

- simple calculations (fi. if-clauses in the reloadscript) become complexer than they need to be

Feedback welcome!

1 Solution

Accepted Solutions
Anonymous
Not applicable

My viewpoint is that if that the front end is excessively complex to set up and maintain then there is an issue with the data model.

Given the con's you mention I'd conclude an issue with your data model.

Your 2 pro's are also pro's of a well designed load script and Star Model.

So my vote is for a de-normalised Star Model, which is also the most common and recommended data model for Qlik solutions.

View solution in original post

1 Reply
Anonymous
Not applicable

My viewpoint is that if that the front end is excessively complex to set up and maintain then there is an issue with the data model.

Given the con's you mention I'd conclude an issue with your data model.

Your 2 pro's are also pro's of a well designed load script and Star Model.

So my vote is for a de-normalised Star Model, which is also the most common and recommended data model for Qlik solutions.