Symptom
In some reports, for example, 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 view.
- Open a report, for example, 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. It does not show up in the Query Builder.
You can find it in the $metadata document, for example, f'. /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 , How To