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
- Go to the Business Analytics work center.
- Go to Design Reports.
- Open a report, e.g. Material Inventories - Balance Summary (FININVU14_Q0001).
- You can see 'Key Date' is available in Selection.
- Click Build OData Queries.
- Search for 'Key Date' in Filters tab.
- 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
Keywords
Key Date, OData, Report , KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , Problem
Product
SAP Business ByDesign 1908