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
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..