topic Re: i have created a data model? in QlikView

i have created a data model?

Fri, 15 Aug 2014 11:38:16 GMT

i have created a data model now i want cross check whether my data model is perfect or not? how ? what are steps i have to follow?

Colin-Albert — Fri, 15 Aug 2014 11:43:48 GMT

Check for Synthetic Keys and remove them.
Check for tables that only have 2 fields and use Mapping Tables and Applymap instead.
Check for Isolated Tables or sets of tables.
These may be correct but users will need to make sure they do not cause a cartesian join by combining data from isolated data sets in the same chart.

Post an image of you data model and I'm sure you will get plenty of help.

giakoum — Fri, 15 Aug 2014 11:44:48 GMT

Go to the table viewer and see what you have created.

Best practise rules can be found in the attached document

Fri, 15 Aug 2014 12:00:59 GMT

Some of the checks you can do.

1.Verify your data model with the source Data

2.You can check count of the records, tallying the records from the source.

3.You can check the values,tallying the source

Regs

Ram

engishfaque — Fri, 15 Aug 2014 12:03:09 GMT

Dear Manoj,

Find attached document, attached document will provide you good understanding.

Kind regards,

Ishfaque Ahmed