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

RSO_RES_ADSO117 - Overview

• 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.

RSO_RES_ADSO117 - Details

• 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