How To Fix RSO_RES_ADSO117 - Field '&1' is not visible in reporting

SAP Error Message - Details

• Message type: E = Error

• Message class: RSO_RES_ADSO - Datastore Object

• Message number: 117

• Message text: Field '&1' is not visible in reporting

What causes this issue?

Fields in an aDSO can only be used directly in BW queries if the field
name does not exceed the maximum length and the data type is
"compatible" with the supported BW reporting types.

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?

There are two possibilities for solving this problem:
* Change either the field name or the type of the field to a supported
type
* Define an Open ODS view on top of the aDSO, so providing the required
conversion of the types and the field names

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 RSO_RES_ADSO117 - Field '&1' is not visible in reporting ?

  The SAP error message RSO_RES_ADSO117, which states that "Field '&1' is not visible in reporting," typically occurs when you are trying to access a field in an SAP HANA-based Advanced DataStore Object (ADSO) that is not available for reporting. This can happen for several reasons, and here are some common causes, solutions, and related information:
  Causes:
  
  Field Not Marked for Reporting: The field in question may not be marked as visible for reporting in the ADSO configuration.
  Field Not Included in the Data Model: The field might not be part of the data model or the data flow that is being used for reporting.
  Authorization Issues: There may be authorization restrictions preventing access to the field.
  Field is in a Different Layer: The field might be in a different layer (e.g., not included in the InfoProvider or the query).
  Data Source Issues: If the ADSO is based on a data source that does not include the field, it will not be available for reporting.
  
  Solutions:
  
  
  Check ADSO Configuration:
  
  Go to the ADSO in the SAP BW modeling tools.
  Ensure that the field is marked as "Visible" in the reporting settings.
  If it is not visible, you can change the settings to make it visible.
  
  
  
  Update Data Model:
  
  If the field is not part of the data model, you may need to add it to the ADSO or the relevant data flow.
  Ensure that the field is included in the transformation and data flow processes.
  
  
  
  Review Authorizations:
  
  Check the user authorizations to ensure that the user has the necessary permissions to access the field.
  You may need to adjust the roles or authorizations assigned to the user.
  
  
  
  Check Query Design:
  
  If you are using a query to access the ADSO, ensure that the field is included in the query design.
  You may need to modify the query to include the field.
  
  
  
  Data Source Validation:
  
  If the ADSO is based on a data source, validate that the data source includes the field.
  If necessary, update the data source to include the required field.
  
  
  
  Related Information:
  
  SAP Notes: Check for any relevant SAP Notes that may address this specific error or provide additional troubleshooting steps.
  Documentation: Refer to the SAP BW/4HANA or SAP BW on HANA documentation for detailed information on ADSO configuration and reporting.
  Community Forums: Engage with SAP community forums or support channels for insights from other users who may have encountered similar issues.
  
  By following these steps, you should be able to identify the cause of the error and implement a solution to resolve it.