For what mistake FM asks for cross join

[inu]

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

[MFGF]

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.