2848700 - Key Date Not Available in OData Query Filter

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.

SAP Business ByDesign

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.

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'.

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

2734842 - Attributes Not Available in OData Query

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