Report studio join two request from two cubes
Posted: Thu Aug 05, 2010 7:34 pm
hey All
I have a problem width report studio.
I must build a graphic witdh two request R1, R2
in R1 i have two members A1, A2(calculated member). R1 is based to cube C1
in R2 i have also two members B1, B2(calculated member). R2 is based to cube C2
A1=B2 (are two of my Keys join)
I created a third query R3 that represents the juncture of the first two.
I obtain results that are completely different
for exemple :
in R1: A1 = 01 A2 = 12
in R3: A1 = 01 A2 = 14000
This is not normal.
the problem is cardinalities of my joint?
is that this kind of join is supported by cognos 8?
Where does the problem otherwise?
I have a problem width report studio.
I must build a graphic witdh two request R1, R2
in R1 i have two members A1, A2(calculated member). R1 is based to cube C1
in R2 i have also two members B1, B2(calculated member). R2 is based to cube C2
A1=B2 (are two of my Keys join)
I created a third query R3 that represents the juncture of the first two.
I obtain results that are completely different
for exemple :
in R1: A1 = 01 A2 = 12
in R3: A1 = 01 A2 = 14000
This is not normal.
the problem is cardinalities of my joint?
is that this kind of join is supported by cognos 8?
Where does the problem otherwise?