Ranking in migrated report

[Former Member]

Hi,

I have some Webi 3.1 reports that were migrated to 4.1 that are not working correctly.  The report pulls from two universes, there are merged dimensions, a break in the reports and ranking within each break.  The 3.1 report works fine.  In the 4.1 report the ranking does not work properly.  It returns the top 10 values, but also returns values with blanks and zeroes.

Has anyone else run into this issue?

When I rebuild the report in 4.1 it works fine.  However, there are several reports and I'd rather not rebuilt all of them.

Thanks,

David

[sateesh_kumar1 · Accepted solution]

Hi David,

uncheck below properties in Format table

Since calculation changed a lot , we need to do some changes to get the old logic's to work .

http://wiki.scn.sap.com/wiki/display/BOBJ/BI+4.1+SP03+Web+Intelligence+Calculation+Rewrite+Tool

[Former Member · Accepted solution]

Sathish,

Thanks for the reply and for your help.  Unchecking the specified boxes did not solve the problem.  I think there might be an issue with logic used in the merged dimensions/join.  I'll try adding a filter to exclude null and zero values.

Best regards,

David