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
