Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Data Model in QlikView

Is there a pre defined way to create a Data Model. Can you please share the logic and steps to keep in mind before going ahead and structuring it.

5 Replies
marcus_sommer
MVP & Luminary
MVP & Luminary

Not really. Probably the most important point is to collect all requirements before starting. Here you will find many very good explanations how to Get started with developing qlik datamodels.

- Marcus

MK9885
Master II
Master II

I think best way to create a data model is know the requirements as Marcus said.

Plus know your keys (Primary or Composite Keys). If not sure, ask the BA team what keys are for hat table or you need to create your own?

qlikviewnovice
Specialist II
Specialist II

Not applicable
Author

Is it mandatory to maintain a star schema/ snow flake schema at QlikView end I.E. Have all the measures defined in the fact surrounded by dimensions if you have a lot of data sources or can you just create the data Model based on common fields. Do you need to follow a mandatory rule while the model is getting created based on these common fields.

marcus_sommer
MVP & Luminary
MVP & Luminary

In general many other datamodels will also work and a star-scheme isn't mandatory but it's recommended because it is most often the best compromize between between load run-times, complexity and performance.

- Marcus