If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Merging query subjects (dimensions)

Started by captain karisma, 11 Nov 2010 06:35:49 AM

Previous topic - Next topic

captain karisma

Hi guys,

I have 2 dimensions. CC and employee which join to fact F1.
I have combined CC and Employee on a common column being "code" in a database view via a 1:1 relationship (inner join).

When i filter on CC->item1 and F1 , I get the correct result
When i filter on the combined Employee/CC->item1 and F1 , i get a different result

Does anyone know what i need to be doing for them to display the same result? Am i joining incorrectly?

Thx for any tips

blom0344

Check your database view. The view column that is used for joining with the fact should still have unique values. In other words, when the view generates 1000 rows, then the join column should yield 1000 distinct values.

Are you also sure that combining the two dimensional objects through an inner join does not result in data-loss?

Also, do not make the mistake of thinking an inner join translates to  1:1 cardinality, it only precludes either end from being 0