Skip to Content
avatar image
Former Member

Ranking in migrated report

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Sep 09, 2014 at 09:01 AM

    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


    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      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