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!
