Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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?
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.
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