topic Re: Data model issue in App Development

Data model issue

qv11user — Sun, 01 Feb 2026 08:45:29 GMT

Hello All,

In my current dashboard I have a complex data model where multiple fact tables have connected to dimension tables and then sub dimension tables, due to this I'm getting severe performance issues. Attached data model for reference

I want to simplify the data model by creating the link table and then connect all the dimension and fact tables to link table so that performance is improved.

I have attached both current and required data model images for reference.

Could you please someone take a look and help me on this.

Re: Data model issue

tresB — Mon, 02 Feb 2026 05:34:25 GMT

Have a look here : https://community.qlik.com/t5/Design/Concatenate-vs-Link-Table/ba-p/1467569

Re: Data model issue

marcus_sommer — Mon, 02 Feb 2026 10:07:24 GMT

A link-table model is rather not suitable if there are already performance-issues. Recommended as best compromise between efforts, simplicity and performance is to use a star-scheme model. Means merging all facts into a single fact-table which also avoids most of the association trouble.