SAP Knowledge Base Article - Preview

2551243 - CDS modeling considerations in BW


  • Union or Join is used in a CDS view with annotation @Analytics.query:true.  Hit activation error: 'CDS Feature Union not supported for BW Query'
  • Association is added in a CDS view with annotation @Analytics.query:true.  Hit activation error: 'CDS local associations not allowed (when @Analytics.query: true)'
  • Create an extend view for a CDS view with annotation @Analytics.query:true to add addtional elements into the CDS query. Hit various activation errors like:  'CDS local associations not allowed (when @Analytics.query: true)' or ' xxx is not a numeric value' or '_xxx: has unsupported path entry type [Analytics]'
  • In a CDS view, UNION two tables. Instead of get all data records back and aggregate the values in the query result, only distinct values are returned without aggregation.
  • A CDS view contains join (or association) on fields with alpha conversion. It gets wrong query result.
  • A CDS query gets wrong decimal in query result for currencies that are not 2 decimila, such as JPY, HUF, CLP..., etc.



BW 7.50 SP4 or BW 7.51 SP2 above


SAP BW/4HANA 1.0 ; SAP NetWeaver 7.5 ; SAP S/4HANA 1610


2C , KBA , BW-BEX-OT-ODP , Query Runtime for Operational Data Provisioning , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.