How to solve the repeatition of data in the report or Same records are repeating in the report.
How to resolve this issue is that we have to check teh filters i checked the filter my report is working for certain projects .
If i pick some project in drop down list Ã, it is working for some projects and for some projects Ã, its giving the data but the records are repeating.
Can any body help me in this issue.
thanks!!
check your sql, is the grouping, ordering, joining if any are proper.
Also, Please make your topic more related to the error.
Srik
Hi,
Sounds to me like you have some serious problems with your metadata model in Framework Manager. This is where you should really be looking to resolve repeating data / double counting etc. Look for transitive relationship traps (loops) in your relationships as a starting point.
Regards,
MF.
Quote from: MFGF on 19 Dec 2006 04:38:47 AM
Hi,
Sounds to me like you have some serious problems with your metadata model in Framework Manager. This is where you should really be looking to resolve repeating data / double counting etc. Look for transitive relationship traps (loops) in your relationships as a starting point.
Regards,
MF.
You can try to isolate the problem join by running reports that have 1 data item from the Measure dimension (use a very granular fact item instead of an aggregatable measure), select a data item from 1 dimension. Repeat until you have tested the measures against each Query Subject. When you notice the repetition, you have identified a poorly constructed join.