Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

vvvvvvizard
Contributor III

Data model

Good day

Attached is a pic of the data model

The model is accurate

Its not too slow , a little , no one is complaining yet

its 14GB in size

One fact table and the rest are dimension tables

I want to follow data modelling best practices , should i combine the dimension tables together

Getting to the star schema from here is easier said than done , any tips ?

1 Solution

Accepted Solutions
micheledenardi
Valued Contributor

Re: Data model

I think you can use Document Analyzer V3.0 Update Available to check if all the dimensions are used at layout level and drop the unused fields.

After that you have to join() and applymap() your tables (where possible).

Yes, easier said than done.

Check also this link and the attached files.

https://www.quickintelligence.co.uk/perfect-your-qlikview-data-model/

4 Replies
micheledenardi
Valued Contributor

Re: Data model

I think you can use Document Analyzer V3.0 Update Available to check if all the dimensions are used at layout level and drop the unused fields.

After that you have to join() and applymap() your tables (where possible).

Yes, easier said than done.

Check also this link and the attached files.

https://www.quickintelligence.co.uk/perfect-your-qlikview-data-model/

serj_shu
Valued Contributor

Re: Data model

Hello!

If you want to make some cleanings so for the start it can be:

1. Order this chaos! Sort tables by meanings and theme, by links and key fields;

2. Join all that can be joined without changing on cheksum;

3. There can be some trash tables without any help in front-end (and they can be dropped in the script).

As the finish model it should be a fact table with multiple dictionaries.

vvvvvvizard
Contributor III

Re: Data model

last question , when can two tables not be joined . Some tables i joined i got incorrect results in front end , so i tried different combinations left , outer , inner , concateneate  which is making me think some tables just cant be joined , is this true ?or can all tables be joined in some way

serj_shu
Valued Contributor

Re: Data model

You should be careful with joining and not all tables can be joined without data corruption.

If it happens, so may be there is a way to transform, separate or combine this table somehow.

This is individual for every model.

Try to make it step by step.