How To Fix AQ987 - Define the BI properties of classic info sets

SAP Error Message - Details

• Message type: E = Error

• Message class: AQ - Message texts for SAP Query

• Message number: 987

• Message text: Define the BI properties of classic info sets

What causes this issue?

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

System Response

How to fix this error?

This application is for the maintenance of BI-specific properties of
classical InfoSets and is therefore only relevant if BI tools are to be
used to analyze the data of classical InfoSets. Note in this context the
corresponding IMG activity.

Procedure for System Administrators

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message AQ987 - Define the BI properties of classic info sets ?

  The SAP error message AQ987, which states "Define the BI properties of classic info sets," typically occurs when you are trying to use a classic InfoSet in a Business Intelligence (BI) context without having defined the necessary BI properties for that InfoSet. This is often encountered in the context of SAP BW (Business Warehouse) or when working with queries in SAP.
  Cause:
  The error arises because the classic InfoSet does not have the required BI properties defined. These properties are essential for the InfoSet to be used in BI reporting and analysis. The absence of these properties means that the system cannot process the InfoSet correctly for BI purposes.
  Solution:
  To resolve this error, you need to define the BI properties for the classic InfoSet. Here are the steps to do this:
  
  
  Access the InfoSet:
  
  Go to the transaction code SQ02 (InfoSet Query) in SAP.
  
  
  
  Select the InfoSet:
  
  Choose the InfoSet that is causing the error.
  
  
  
  Define BI Properties:
  
  In the InfoSet maintenance screen, look for an option to define BI properties. This may be under a menu option like "BI Properties" or "Properties."
  You will need to specify the necessary attributes such as:
  
  InfoObject assignments
  Key figures
  Characteristics
  Any other relevant settings that are required for BI reporting.
  
  
  
  
  
  Save Changes:
  
  After defining the necessary properties, save your changes.
  
  
  
  Test the InfoSet:
  
  After saving, test the InfoSet to ensure that it can now be used in BI queries without generating the error.
  
  
  
  Related Information:
  
  Documentation: Refer to SAP Help documentation for detailed guidance on InfoSets and BI properties.
  Transaction Codes:
  
  SQ02: InfoSet Query
  SQ01: Query Management
  
  
  SAP Notes: Check for any relevant SAP Notes that may provide additional insights or updates related to this error.
  Support: If the issue persists after following the above steps, consider reaching out to your SAP support team or consulting with an SAP BW expert.
  
  By following these steps, you should be able to resolve the AQ987 error and successfully define the BI properties for your classic InfoSet.