Symptom
You are expecting a particular attribute of a characteristic to be available for use to build OData Queries.
Environment
- SAP Business ByDesign
- SAP Cloud For Customer
Reproducing the Issue
-
Go to the Business Analytics work center.
-
Go to Design Reports.
-
Select the desired report.
-
Click on Build OData Queries.
-
Search for any specific attribute in Attributes/Filters tab. You will notice that the particular attribute is not available.
Cause
If an attribute is simply added via option "Add Fields to Rows" report view, it won't be available for use via OData. For attributes to be available for use via OData, we have to add that particular attribute via Add Field option.
Here you can see the 2 different options:
Resolution
-
Go to the Business Analytics work center.
-
Go to Design Reports.
-
Search for the desired report and open it.
-
Execute the report once.
-
Click on the Configure Icon.
-
Click on Add Fields.
-
Add that specific attribute to be displayed in the report and click OK.
-
Go back to Design Reports.
-
Click on Build Odata Queries. You will find that the desired attribute is now available in Attributes/Filters tab and use it for building OData Queries else you can generate metadata query and check the available fields.
Keywords
Attribute, OData, Add Fields, Report, AP-RC-ANA , KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , How To
Product
SAP Business ByDesign all versions ; SAP Cloud for Customer add-ins all versions ; SAP Cloud for Customer core applications all versions