topic Data Model Question in QlikView

Data Model Question

onetwothree123 — Tue, 03 Jul 2012 15:55:37 GMT

I have a set of tables, some with data for everyday, some with weekly and some with monthly data. I want to link all of these tables to the calendar, but I dont want to connect these tables to each other,
(i.e) I don't want the Daily table1 to be associated with Daily table2 or the Daily table3, but all 3 of them have Daily dates that need to be connected to the calendar. How can I make this happen?
As an extension to this question, how do I define a set of dimension tables, and link each of the above Fact tables to the dimensions, without concatenating/joining/link table-ing the individual fact tables?

Table Structure :
T1 T2 T3 T4 T5 five tables

T1 T2 T3 - Daily dates tables

T4 - Weekly

T5 - Monthly

Re: Data Model Question

jonathandienst — Tue, 03 Jul 2012 16:15:39 GMT

Concantenating the fact data into a single fact table is usually the best way to solve this sort of problem, so you need to have a very compelling reason for doing it the way you propose. You would differentiate between the different data sets by using one or more grouping fields - for example, you could use a field TableGroup, with possible values T1, T2, T3... then use set analysis to select the correct data for the charts. This solves the problem with synthetic keys, data loops and multiple copies of attribute and calendar tables that you are likely to need,

Ultimately, this would lead to a simpler solution, simpler expressions, simpler operation and simpler maintenance.

But perhaps you have a good reason....

Regards

Jonathan