topic Re: Data model with links to them, and multiple possible branches in App Development

Data model with links to them, and multiple possible branches

Obsyky — Fri, 14 Mar 2025 21:48:38 GMT

Hello,

I'm sharing a quick image of the data model I need to work on at the end.

The image shows 3 main tables:
- System
- Product
- Item

Link tables:
- Link table to create the hierarchy between themselves for systems, products and items.
- Link table between each of these 3 large objects
- Table linking products or items to complementary objects

For the notion of complementary objects, in the image I've only shown the documentation, but there are six other objects which work in the same way. In other words, a table linking products, a table linking items and the dimension table.

Each table of main objects and complementary objects obviously doesn't have the same characterisation attributes.

Do you have any ideas for modelling this in Qlik properly?

Thank you very much in advance!

Re: Data model with links to them, and multiple possible branches

marcus_sommer — Mon, 17 Mar 2025 11:41:41 GMT

The magic key to transform such data-structure into an efficient and performant data-model is to de-normalize the tables - ideally ending in a star-scheme data-model with a single fact-table and n dimension tables.

Re: Data model with links to them, and multiple possible branches

Obsyky — Mon, 17 Mar 2025 14:04:56 GMT

I can understand that. For example, for a document X, I have X lines following its top links, even for indirect links.
Then I have to add an attribute that tells me the depth of the link, because for some reports I have to put level 1 in column A, level 2 in column B, and so on...

Edit: I've just thought about the subject, the problem I need to solve is, for example, for a product, how do I know its father/son products?