SAP Knowledge Base Article - Preview

2627820 - Unable to filter out zero using SAP Integrated Business Planning as a source - SAP Cloud Platform Integration for Data Services

Symptom

  • When creating a Task in SAP Cloud Platform Integration for Data Services the output data ignores filters and zero values are loaded.
  • When viewing filters tab in Query Transform you receive one of the following design time errors:
    • "ERROR - Replication table <query_transform_name> has an invalid filter expression: Cannot determine argument data type."
    • "WARNING - Replication table <query_transform_name> has an invalid filter expression: Expression of type <output_data_type> will be converted to type <REAL>."


Read more...

Environment

  • SAP Cloud Platform Integration for Data Services
  • SAP Integrated Business Planning

Product

SAP Cloud Integration for data services 1.0 ; SAP Integrated Business Planning 5.0

Keywords

CPI , IBP , HCI , where , "where clause" , filter , unexpected , un-expected , "unexpected results" , "un-expected results" , Null results , KBA , LOD-HCI-DS , HANA Cloud Integration for Data Services , SCM-IBP-INT-TS , Time-Series-Based Integration , Problem

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.