Problem with report 5.1.7 to 6.1b... help please

building reports desktopintelligence
1

Sorry if this is not appropriate here, i searched for bugs for 6.1b FC but could only find the Webi issues thread. If there is one could you point me in the right direction please?

Anyway, I’ve been checking some complex FC reports prior to rolling them out via our spanking new Webi server, and found that one of them is giving some VERY strange results.

The universe is built mainly over a single generic reference table that is split into the appropriate alias tables by the use of self joins in Designer. I’ve written SQL to imitate the join in place on the relevant alias and it pulls the correct data. When i run the report i get other data that does exist in the column of the database table but shouldn’t exist in the Designer alias. :crazy_face:

I’ve checked to make sure the object is referencing the correct table.

I’ve checked to make sure that BO isn’t joining DP’s in the report and that the query conditions haven’t changed.

Are their problems with some conversion of V5 reports?

Any help greatly appreciated

norty303 :uk: (BOB member since 2003-03-19)

2

OK folks, emergency over :smiley:

We traced the error back to a slight code change in the stored procedure that populates the table which meant that the wrong category was going into the wrong column.

norty303 :uk: (BOB member since 2003-03-19)