How To Fix BW_BICS_EQ148 - Sorting by &1, &2 is not supported. See long text.

BW_BICS_EQ148 - Overview

• Message type: E = Error

• Message class: BW_BICS_EQ - Easy Query Messages

• Message number: 148

• Message text: Sorting by &1, &2 is not supported. See long text.

What causes this issue?

The engine does not support sorting by property <(>&<)>1 and property
<(>&<)>2.
Property <(>&<)>1 is of type Dimension
Property <(>&<)>2 is of type Key Figure
The standard behavior is to sort by key figure first.

System Response

The request is rejected

How to fix this error?

Change the sorting order to property <(>&<)>2 and property <(>&<)>1

Procedure for System Administrators

The system issues an error message and will not allow you to continue with this transaction until the error is resolved.

Error message extract from SAP system. Copyright SAP SE.

BW_BICS_EQ148 - Details

• The SAP error message BW_BICS_EQ148, which states "Sorting by &1, &2 is not supported," typically occurs in the context of SAP BW (Business Warehouse) when using BICS (Business Intelligence Consumer Services) to access data. This error indicates that the sorting operation you are trying to perform on a query or report is not supported for the specified fields.
  
  Cause:
  
  Unsupported Sorting Fields: The fields you are trying to sort by may not be supported for sorting in the context of the query or the data source you are using.
  Query Design: The query might be designed in such a way that certain fields are not allowed to be sorted due to the underlying data model or the characteristics of the data.
  Aggregation Issues: If the fields are part of an aggregation or if they are calculated fields, sorting may not be allowed.
  Data Source Limitations: The data source (e.g., InfoProvider) may have limitations on sorting