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