topic Re: Data Model Issue in QlikView

Data Model Issue

Mon, 22 Sep 2014 10:14:17 GMT

Hi,

I am facing issue in Data Model. Issues is:

we have two fact table ,each facts have different granularity level.one is higher than other and we have 2dimension table.

these dimension table are connected with each fact tables with different keys.

for example:

Budget and Sales are two fact table. Branch and Account is two dimension table.

Budget connected to Branch and Account with BranchLevel1 and AccountLevel1.

Sales also connected to Branch and Account with BranchLevel2 and Accountlevel2.

BranchLevel1 and AccountLevel1 is higher granule level than BranchLevel2 and AccountLevel2

If I am directly connect theses table with each other then it makes a circular loop.

Please help me to resolve that issue.

Thanks in advance......

Nisha

Re: Data Model Issue

jyothish8807 — Mon, 22 Sep 2014 10:17:22 GMT

Hi Nisha,

Can you attach the table view you are getting right now?

Regards

Re: Data Model Issue

Mon, 22 Sep 2014 11:05:15 GMT

I want to connect these two fact with each dimension table. but I don't know how I can solve this problem

Nisha

Re: Data Model Issue

avinashelite — Mon, 22 Sep 2014 11:08:30 GMT

HI Nisha,

join the fact1 and fact2 with dimension1.

post your app please

Re: Data Model Issue

avinashelite — Mon, 22 Sep 2014 11:11:39 GMT

Try like this

Maintable:

Load *

from Dim1

join

load *

from Fact1

join

load *

from Fact2

load *

from Dim2

Re: Data Model Issue

Mon, 22 Sep 2014 11:42:29 GMT

we can't make lower level granularity for fact2. It gives more budget then the real value.

Re: Data Model Issue

sathishkumar_go — Mon, 22 Sep 2014 11:49:17 GMT

HI,

You have to link fact2 table with either Dim1 or Dim2.

Example : In Dim1 table, ConsAcct field rename as ConsAcct_Dim

so that you can avoid circular loop.

-Sathish

Re: Data Model Issue

avinashelite — Mon, 22 Sep 2014 11:50:25 GMT

Can you please post the Data and qvw please ...Will make correct model for you

Re: Data Model Issue

Mon, 22 Sep 2014 11:51:30 GMT

But I want to link fact1 also from these two dimnension

Re: Re: Data Model Issue

Mon, 22 Sep 2014 11:57:46 GMT

PFA

Nisha

Re: Data Model Issue

sathishkumar_go — Mon, 22 Sep 2014 12:01:53 GMT

Fact1 have already linked with Dim1.

I have told you, to bread the link between fact2 and Dim1

-Sathish

Re: Re: Re: Data Model Issue

jyothish8807 — Mon, 22 Sep 2014 12:02:43 GMT

Hi,

PFA.

Is it wat you want?

Regards