Data Model Issue

[#1]

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

[jyothish8807]

Hi Nisha,

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

Regards

KC

[#3]

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

Nisha

[avinashelite]

HI Nisha,

join the fact1 and fact2 with dimension1.

post your app please

[avinashelite]

Try like this

Maintable:

Load *

from Dim1

join

load *

from Fact1

join

load *

from Fact2

load *

from Dim2

[#6]

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

[sathishkumar_go]

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

[avinashelite]

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

[#9]

But I want to link fact1 also from these two dimnension

[#10]

PFA

Nisha