Record count is increasing after the Left join

[Anonymous]

Hi ,

       We have data model something like below:

	Root
Month	Year	CID	AID
Jan	2013	36	124
Jan	2013	36	125
	Child
Month	Year	CID	Month Count
Jan	2013	36	2
Left Join(Root)
Month	Year	CID	AID	Month Count
Jan	2013	36	124	2
Jan	2013	36	125	2

Root columns :

     Month, Year, CID  and AID columns

Child  columns

     Month, Year, CID and Month Count

LEFT JOIN (ROOT)

       Month, Year,CID,AID,MONTH COUNT

When we do left join with the root view we are getting Month Count repeated since (Month,Year,CID) join condition is satisfying.

But in the UI we have only  Month, Year and CID as dimensions . In th ui when we try to show SUM(Month Count) it is showing 4 instead of 2.

If i dont perform join and keep qv association then i am getting the correct count ie 2. Is there any way i can keep left join and get the count 2?.

[swuehl]

I think it might be better to not join the two tables, thus avoiding the fact duplication first hand.

If you absolutely want to join, you can maybe try something like this as expression in your chart with the given dimensions Month, Year, CID:

=aggr( sum( [Month Count] ), Month, Year, CID, AID)