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

FM Joins doubt

Started by cognosun, 13 Jul 2012 04:10:47 AM

Previous topic - Next topic

cognosun

I have 3 tables in FM...say 2 Dimension tables ( D1,D2) and one Fact table ( F1)

My doubt is...

if D1 is joined to F1 and

if D2 is joined to F1

How does this mean D1 and D1 are also joined ?

I've observed 2 scenarious here..in one scneario we won't get any error if we pull columns in one report ( from D1 and D2)

In other scenario we get "Cross Joins" error.

Can anyone explain the reasons like...in which scenario they throw "Cross Join" error and in which scenario they won't ...

Many Thanks in Advance,
Joys




blom0344

There is NO direct relationship between D1 and D2 tables , they are there to add descriptive data to the fact subject. Pulling data at random from both D1 and D2 without measures from the fact is a meaningless exercise at best.

You do not describe the difference between the 2 scenario's , but it will probably be caused by the selection of dataitems and the way Cognos tries to write the SQL.

In other words, check the proposed SQL and you will learn more..