3549038 - Missing fields in the OData Query Builder

The attributes of a characteristic are missing in the query builder when an OData query is built on a standard data source.

SAP Business ByDesign 

SAP Cloud for Customer

1. Go to Business Analytics work center.
2. Navigate to Design Data Sources work center view.
3. Choose any data source. For example, Material Valuation Data.
4. Click on Build OData query.
5. Check the fields listed in the query builder

You will see that there is a difference in the list of fields displayed in the test environment and the production environment. 

If the referenced data source of a specific characteristic is not exposed, then its corresponding attributes will not be listed in the OData Query builder.

Exposing the referenced DataSource will allow the user to view the master data characteristics and key figures in the OData query.

You can check the data source documentation of a specific data source to figure out the referenced data source of a specific characteristics or a key figure.

For example, MATERIAL is the referenced data source of the characteristic Material. If this data source is not exposed, the attributes of the Material characteristic will not be listed in the query builder when an OData query is built on the data source FININVU07 (Material Valuation Data).

To expose a specific data source, Follow the steps given below.

1. Navigate to the Business Analytics work center.
2. Navigate to the Design Data Sources work center view.
3. Select the standard data source you would like to use the OData Service.
4. Click on the Expose button.
5. Check if the option Expose for OData is enabled.

2675247 - Build OData Queries Button Grayed Out or Missing - SAP for Me

OData, Query Builder, Attributes, Missing fields, Data source, Test, Production, Master data, Characteristics, Key figures , KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , How To

SAP Business ByDesign all versions ; SAP Cloud for Customer core applications all versions