Does Business Objects 6.5 have a bug?

[S4E]

I created a query within BO that has five conditions. Each of the conditions is listed as a dimension, and has a unique value. After submitting the query, I noticed that it returned values not specified in the condition statements, but displayed the proper condition values.

I constructed the same query in Excel and accessed the same database, and it returned the proper results. I also checked the database itself, and the erroneous fields that were retrieved in BO had their proper values, and not the values listed in the report.

Has anyone else experienced a similar scenario?

 

[skrandel]

Without seeing the SQL, it's hard to tell what's going on. There is no bug in BO regarding this. Sure, there are issues, but SQL generation is not one of them. If you're seeing this, then you likely have some joins defined incorrectly in your universe that are causing this problem.

Any outer joins?

Steve Krandel
VERITAS Software

 

[BrianTyler]

All I can suggest is that you check the conditions and be very careful about NOT and OR in any conditions.

If it looks OK in BO, then look at the SQL. Perhaps some of the objects are defined 'oddly' in the Universe.

Brian