If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Report net

Started by halitabitha, 02 Nov 2006 08:50:47 AM

Previous topic - Next topic

halitabitha

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!!

BIsrik

check your sql, is the grouping, ordering, joining if any are proper.

Also, Please make your topic more related to the error.

Srik

MFGF

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.
Meep!

MDXpressor

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.
No, a proof is a proof. What kind of a proof? It's a proof. A proof is a proof, and when you have a good proof, it's because it's proven.

-Jean Chretien