topic Re: Data Model in QlikView in QlikView

Data Model in QlikView

Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: Data Model in QlikView

marcus_sommer — Wed, 04 Oct 2017 16:31:42 GMT

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

Re: Data Model in QlikView

MK9885 — Wed, 04 Oct 2017 17:25:51 GMT

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?

Re: Data Model in QlikView

Anonymous — Wed, 04 Oct 2017 17:58:15 GMT

Have a look:

Best pratices PDF's which i have collected in the past.

Hope it helps!!

Re: Data Model in QlikView

Thu, 05 Oct 2017 03:09:47 GMT

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.

Re: Data Model in QlikView

marcus_sommer — Fri, 06 Oct 2017 06:33:23 GMT

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