How To Fix BS_ANLY_LIST001 - Cannot create new lines for this query

BS_ANLY_LIST001 - Overview

• Message type: E = Error

• Message class: BS_ANLY_LIST - Analytics: Simple List Reporting

• Message number: 001

• Message text: Cannot create new lines for this query

What causes this issue?

You are using an input-ready query and you want to enter new rows. There
are several cases when new lines cannot be created.
If the query contains compound characteristics, a new line only can be
created if the superordinate characteristic either has a fixed value or
also resides in the row drill-down. If the superordinate characteristic
is part of a restricted key figure, new lines cannot be created.
See SAP Note 1149346, which describes in detail the prerequisites for
creating new rows.

System Response

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

How to fix this error?

Procedure for System Administrators

Error message extract from SAP system. Copyright SAP SE.

BS_ANLY_LIST001 - Details

• The SAP error message BS_ANLY_LIST001 ("Cannot create new lines for this query") typically occurs in the context of SAP Business Warehouse (BW) or SAP Business Explorer (BEx) when users attempt to add new lines to a query or report that is not configured to allow it. Here are some potential causes, solutions, and related information for this error:
  Causes:
  
  Query Configuration: The query may not be set up to allow for the addition of new lines. This can happen if the query is designed to display data in a specific format that does not support additional entries.
  Data Source Limitations: The underlying data source (e.g., InfoProvider) may not support the addition of new records or may be in a state that prevents modifications.
  User Authorizations: The user may lack the necessary authorizations to modify the query or the underlying data.
  Query Mode: The query might be in a mode that does not allow for editing