Attribute design help

[138006]

Hi,

I have 2 Dim table D1 and D2 and 2 Fact tables F1 and F2 say.
Now, I create an attribute A11 to join D1 and F1 and A22 to join D2 and F2. In Report#1 I need to show an attribute A1(from D1),A2(from D2) and Fact from F1. What I did, is create those attributes and added the joins as their child, e.g. A11 attribute is the child of A1 and A22 attribute is the child of A2. The report sql is fine.

Now, in Rrport#2, I have a peculiar case where I need to join D2 with D1 and then D1 with fact F2.
So I created another attribute A12 and added it as the child of A2. Now when I drag A2, A1 and fact from F2 then I get a join between D1 and D2 and D1 and F2 as desired.

Problem is, since I added A12 as child of A2, so, I get this join in Report#1 as well which I don't want.

What should be the design in such cases.

Thanks and regards,

 

[entaroadun]

This is as clear as mud.

In report 2, what fields are you joining on?

Give the table structures with field names, the join structure, and the fields that the attributes are mapped to.

Saying "I need to join D2 with D1 and then D1 with fact F2" doesn't help.

 

[138006]

D1 and F1 are joined by the attribute A11 (u can assume that the column is a11 in both)

D2 and F2 are joined by the attribute A22 (u can assume that the column is a22 in both)

D1 and D2 are joined by attribute A12 (u can assume that the column is a12 in both)

A1 is an attribute from D1 and it has child as a11.
A2 is an attribute from D2 and it has child as a22.
In report 1 we drag A1, A2 and fact from F1. so the join is between D1 and f1 on a11 and between D2 and F1 on a22.

Now we have joined D1 and D2 on a12 in attribute A12. I added this as a child of A2.
In report 2 I need to join D2 with D1 on a12 and the D1 to another fact table.

Problem is, in report1 also due to A12, I get a join between D1 and D2 even if this is not required.
Hope this helps now.
Thanks,