Removing Loops

[#1]

Hi,

Attached is the sample data model that I have(the tables are as is coming from data source) . Is there a way I can remove the loops?

[Anonymous]

As a rule, it is not a good idea to load data as is.  You have to design your data model on paper first, and after that load the data the way you need.
In your case, I think, you need Purchase, Purchase Details, Sales, and Sales Details to keep in one Facts table, which will contain Account and Product Keys.  Maybe Location Key as well if Location is not an attribute of Account.  Account, Product, and Location (if you need it) tables are dimensions, and they don't need Sales nor Purchase keys.

(If you have trouble understanding the above, you need to take some training or to hire QV professional.)

Regards,

Michael

[ankitaag]

You can create a link table containing all the keys of sales purchase product etc and link the facts and dimensions, if you don't want to concatenate the fact tables. You need to study how to create link tables if you aren't aware of the same.

[Colin-Albert]

Add tables one at a time to your data model. Resolve any issues with synthetic keys or loops, for the new table you have added before adding another table to the model.

The simplest way to do this is to have each table you are loading on a separate tab, and have an extra tab with an Exit Script command that you can promote and demote through the script whilst testing.

Use debug mode with a limited load of 10 rows to identify and test for correct associations and loops - You do not need lots of data to test for a valid data model.

It is much better to plan your data model rather that throwing everything into QlikView and then trying to sort out the synthetic keys and loops afterwards!

[buzzy996]

some thing like this,uf u want all the tables as it is,elec u can create one key table map the corresponding tables to that key table.