Report studio join two request from two cubes

Post Reply
evan_2010
Posts: 1
Joined: Thu Aug 05, 2010 7:07 pm
OLAP Product: COGNOS
Version: TM1
Excel Version: 2007

Report studio join two request from two cubes

Post by evan_2010 »

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?
Post Reply