Duplicate Records checkmark checked

[ismael2004]

Hi Guys!

It's me Nunina. Had to log on using a co-workers handle. Mine isn't working....

I have an Impromptu report that I use as a Drill-thru. My cube have 500 records. My drill-thru has 675. When I run the SQL query against the database, using the Impromptu query, I get 675 records, but when I add the DISTINCT keyword to my query, I get the 500 records the cube is showing.

I have the Eliminate Duplicate rows check mark checked, and still get duplicate records. I try to edit the SQL query, but I get a "Cannot edit SQL...." error. Do you know what to do? How can I eliminate those duplicates.

BTW, my report is a more detailed .imr than the one I used to create the IQD for my cube. And to the IQD I had to manually add the DISTINCT in the sql statement.

Any help will be greatly appreciated.

Thank you!!!!

Nunina

 

[maripro]

You might try reading the excellent FAQ regarding handling duplicate records. Various techniques can be employed to eliminate duplicates, but you will have to understand the data to use them. Provide more details if you still have a problem.