HI MFGF ALL and,
Thanks for your valuable response.. you always clarify solutions for the problems, i honestly appreciate your perception and way of giving answers.
Yes , regarding cross join, When actually FM asks for cross join? and for what our mistakes, FM asks for cross join?
If we want to create cross join manually, is it possible.
No, dont mind, actually i want to make my base understanding and fundamental more strong.
Thanks
Inam
Quote from: inu on 24 Jul 2014 12:05:14 AM
HI MFGF ALL and,
Thanks for your valuable response.. you always clarify solutions for the problems, i honestly appreciate your perception and way of giving answers.
Yes , regarding cross join, When actually FM asks for cross join? and for what our mistakes, FM asks for cross join?
If we want to create cross join manually, is it possible.
No, dont mind, actually i want to make my base understanding and fundamental more strong.
Thanks
Inam
Hi,
Generally you should never be in a position where a crossjoin is attempted, unless it's by design and you know it is the right thing to do. As long as you have all the relevant relationships defined, you should not be in a position where cross joins are a factor. You only see messages about cross joins where you try to bring in items from different query subjects that have no relationships that link them (either directly or indirectly via other query subjects). In other words, it means you are missing one or more relationships somewhere in your model.
Cheers!
MF.