What if Dimension has data but No data in Framework Managr Model Query subject

[tarunkrdas2013]

Hi Gurus,

I made a join between Dimension Model query subject (which has no data as i tested using Test sample option) and Fact Model query subject(which has data as i tested using Test sample option).

I am not getting data ...my question is if dimension has no data and Fact has data ,does a join between them will fetch data?I believe No ,but need your experiences

Kind Regards
Tarun Kumar Das

[MFGF]

Hi Gurus,

I made a join between Dimension Model query subject (which has no data as i tested using Test sample option) and Fact Model query subject(which has data as i tested using Test sample option).

I am not getting data ...my question is if dimension has no data and Fact has data ,does a join between them will fetch data?I believe No ,but need your experiences

Kind Regards
Tarun Kumar Das

The answer depends upon the cardinality of the relationship between the dimension and fact. If the cardinality at the dimension end of the relationship is "optional" (0..1) then you should get fact rows returned that do not have a corresponding dimension row. If it is mandatory (1..1) you will only get fact rows that have a corresponding dimension row (ie none of them).

MF.