SAP Knowledge Base Article - Public

3437388 - Dimensions that have hard filters are not sorted as per query definition

Symptom

Query contains characteristics that are restricted with values in the characteristic restriction part.
In addition these characteristics are added to any of the axes and the sort option is set as "As in Query" in the query definition. 
But the output is not following this setting. 
This occurs in product that is using BI Java, for example, Analysis for Office, BI Java Portal.
This issue does not occur in T-cd RSRT.

Environment

  • SAP Analysis for Microsoft Office

Resolution

Please set RSADMIN parameter BICS_SELECTION_SORT_IN_ABAP as X.
For more information, please refer to note 1947948 - BICS: Optimization for queries with characteristic restrictions.

Keywords

fixed filter, hard filter , KBA , BI-RA-AO-XLA , Excel Addin , BW-BEX-ET-WJR-BICS , BI Consumer Services , BI-RA-BICS-BW , BICS BW Provider , BW-BEX-OT-BICS-RSRT , BICS Query Monitor , Problem

Product

SAP Analysis for Microsoft Office all versions