Skip to main content
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

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?

Anonymous
Not applicable
Author

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

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