SAP Knowledge Base Article - Public

3555335 - Some items are not visible when creating model based on SAP Cloud for Customer connection

Symptom

  • Some items are not visible when creating model based on C4C connection
  • The missing items are with Type="Edm.Guid" in metadata

Environment

  • SAP Analytics Cloud Enterprise
  • SAP Cloud for Customer

Reproducing the Issue

  1. Create an import connection of SAP Cloud for Customer(C4C) OData.
  2. Create a model based on the C4C connection. 
  3. Choose the target query but some items of the query are not visible in query panel.
  4. Create a Generic OData connection to the same C4C query.
  5. Create a model based on the Generic OData connection.
  6. Choose the same query and all the items are visible in the query panel

Cause

This is a designed behavior, the items with Type="Edm.Guid" will be hidden when used in C4C connection.

Resolution

Use Generic ODBC connection as a workaround.

Keywords

KBA , LOD-ANA-AQU-CLD , Data acquisition from Cloud-based (non-OData) sources , Problem

Product

SAP Analytics Cloud all versions