Fact column showing aggregated/summarized values repeated in all rows

[Naven]

Hi,

I have created a Measure dimension using a query subject which has no relation with any other query subjects.

When i test the measure dimension it is showing aggregated/summarized values repeated in all rows. If drilling down the fact column, the value would still have same repeating aggregate values.

I know if we join (create relationship) this measure dimension any other dimesion  proper data is obtained, but why measure dimension shows aggregated data in all rows if join is not present.

Thanks,
Naveen

[blom0344]

I have created a Measure dimension using a query subject which has no relation with any other query subjects.

This would induce a crossjoin repeating each value from the isolated query subject for the other set. Not properly modelled I'd say.. (and the effect you see is what one would expect)

[Naven]

Thks blom... :)