Distinguish whether a query subject is a fact or dimension query subject?

[saumil287]

Hi All,

How should I distinguish whether a particular query subject is a fact or dimension query subject.





Thanks & Regards
saumil

[MFGF]

Hi All,

How should I distinguish whether a particular query subject is a fact or dimension query subject.





Thanks & Regards
saumil

Hi,

This feels like deja vu. Didn't we just have a complete conversation in a different thread and answer this in detail?

http://www.cognoise.com/index.php/topic,24355.0.html

MF.

[saumil287]

Hi MFGF,

So sorry for putting the same kind of question again.




Thanks
saumil

[MFGF]

Hi MFGF,

So sorry for putting the same kind of question again.




Thanks
saumil

I don't understand? It's not the same kind of question - it is the exact same question. Is there still some doubt? Are you unsure of something? If so, just say what part isn't clear and we can try to explain in a different way...

[inu]

Hi
if at least one fact query item that is 'L' shaped symbol with yellow color. Then u can say it as fact query subject. if no fact in query subject , then dimension.
for the sake of your better understanding , just go through fm guide , which has been given with the installation of cognos software.

Thank you

[MFGF]

Hi
if at least one fact query item that is 'L' shaped symbol with yellow color. Then u can say it as fact query subject. if no fact in query subject , then dimension.
for the sake of your better understanding , just go through fm guide , which has been given with the installation of cognos software.

Thank you

Hi,

No - this isn't the case. Fact determination is done by the query engine based on cardinalities of relationships, not on the query item usage properties within a query subject.

MF.

[Lynn]

Hi
if at least one fact query item that is 'L' shaped symbol with yellow color. Then u can say it as fact query subject. if no fact in query subject , then dimension.
for the sake of your better understanding , just go through fm guide , which has been given with the installation of cognos software.

Thank you

Hi,

No - this isn't the case. Fact determination is done by the query engine based on cardinalities of relationships, not on the query item usage properties within a query subject.

MF.

Inam is wrong, Muppet is correct.

The user guide explains detection of fact version dimensions.

http://public.dhe.ibm.com/software/data/cognos/documentation/docs/en/10.2.1/ug_fm.pdf

Take a look at page 67

[MFGF]

Inam is wrong, Muppet is correct.

The user guide explains detection of fact version dimensions.

http://public.dhe.ibm.com/software/data/cognos/documentation/docs/en/10.2.1/ug_fm.pdf

Take a look at page 67

Yay! The Muppet scores another lucky guess! ;)