topic Re: Data model creation in QlikView

Data model creation

shiveshsingh — Wed, 25 Nov 2020 16:16:04 GMT

I am having 2 fact tables, and each fact table has 40-40 dimensions each.

Both the fact table are not associated to each other in any way.

How can we create a data model for this?

Re: Data model creation

techvarun — Mon, 21 Aug 2017 05:04:56 GMT

You need to concatenate both the tables or need to create a Link table

Re: Data model creation

techvarun — Mon, 21 Aug 2017 05:06:31 GMT

Follow the links in the below thread.

Data Modelling With Multiple Fact Tables

Re: Data model creation

tresB — Mon, 21 Aug 2017 05:08:02 GMT

If they are not associated in any way, leave them as they are and that would create two data islands for you. At the front-end, you could create dashboard possibly for two disjoint data set as if creating two dashboards in one place. In another way, you could concatenate the tables creating flag (mentioning the table name may be) and use that in set analysis in front-end expressions.

Re: Data model creation

effinty2112 — Mon, 21 Aug 2017 09:15:05 GMT

Hi Shivesh,

If your two fact tables have no associations do they really belong together in one document?

cheers

Andrew

Re: Data model creation

mayuresh_d — Mon, 21 Aug 2017 09:59:46 GMT

If both of them don't have any relation with each other then u have to create two data model with respect to both the fact tables. and keep it in one document ...so that you can use both the data represent in single table.. and you can use field triggers if you want that your selection make affects on both model.

else

just keep them separate and create two documents.

Re: Data model creation

ramasaisaksoft — Mon, 21 Aug 2017 10:17:39 GMT

To create a Data model,

Case 1 :

when ever you have more than 1 Fact table choose "Snow flake Date Model" here Dimension tables will join Fact tables so you will get Association between them(Even though that Dim table is not useful just take a small Dim table between both of the Fact tables).

Case 2:-

Create one extra field as a Flag field in both of the tables so that association will come.

Case 3:

Depends on the data Use alias names to the fields.