'PERCENT_RANK' is not a recognized built-in function name in Business Objects 4.2

Question

I use BO 4.2 + SQL Server 2008 for reporting. Design mode for report allows using of data ranking in a query filters including percent ranking. For percent ranking BO calls PERCENT_RANK() function in SQL Server. It appears the error message

'PERCENT_RANK' is not a recognized built-in function name

I know this function was introduced in SQL Server 2012. My questions are

• why BO Designer allows add percent rank to query and this button is not disabled/hidden working with SQL Server 2008?
• what ways to disable/hide this button?

p.s. You can find this button by way: -> Design of report -> Edit Data Provider -> Query Filter panel -> Add a database ranking -> set '% top' (See screen)

p.p.s Using BO 3.1 this button is disabled in my case and it is OK, but I need fix it for BO 4.2.

Thank you

Answer 1

SAP support:

1)Tested the scenario in-house on 4.2 SP3 Patch3 by doing the following steps

-Created a report based on SQL SERVER 2008 R2 Universe.

-Take some objects in result pane .

-Now in the Query Filter Pane ,click on database tracking ->select % Top option ->Select objects.

-run the report.

-Error thrown is exactly the same which you are getting "The following database error occurred: [Microsoft SQL Server Native Client 10.0] : 'PERCENT_RANK' is not a recognized built-in function name. For information about this error, please refer to SAP Knowledge Base Article 2054721 on the SAP Support Portal. (IES 10901) (Error: INF )” "

2)Now tested the same above scenario by creating a report on SQL SERVER 2012 Universe and it worked fine.

3)The reason being is the SQL SERVER 2008 R2 is not able to recognize the percent_rank function as the this functionality was introduced by Microsoft on SQL SERVER 2012.

Information about this is provided in the below link

https://learn.microsoft.com/en-us/sql/t-sql/functions/percent-rank-transact-sql

4)Also now coming to disabling the option. Now if you don't want to see the %TOP option use Applet mode or Rich Client instead of HTML mode .

As this option is by default in HTML mode .

:D