SAP Knowledge Base Article - Public

2848700 - Key Date Not Available in OData Query Filter

Symptom

In some reports, e.g. Material Inventories - Balance Summary (FININVU14_Q0001), 'Key Date' is available for selection but not available in OData queries filter when using Build OData Queries.

Environment

SAP Business ByDesign

Reproducing the Issue

  1. Go to the Business Analytics work center.
  2. Go to Design Reports.
  3. Open a report, e.g. Material Inventories - Balance Summary (FININVU14_Q0001).
  4. You can see 'Key Date' is available in Selection. 
  5. Click Build OData Queries.
  6. Search for 'Key Date' in Filters tab.
  7. You will notice that 'Key Date' is not available.

Cause

The parameter 'Key Date' is actually available in the OData Service. Unfortunately, it does not show up in the Query Builder.

You can find it in the $metadata document, e.g.'. /sap/byd/odata/ana_businessanalytics_analytics.svc/$metadata?entityset=RPFININVU14_Q0001QueryResults'.

Resolution

If you want to provide a $filter on it, you can write the $filter statement manually.

See Also

2734842 - Attributes Not Available in OData Query

Keywords

Key Date, OData, Report , KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , Problem

Product

SAP Business ByDesign 1908