Skip to Content

Optimized sql not properly generated when using SAP ODP Object

Hi Experts,

I'm using BODS 4.2 sp8. We have a simple dataflow where we pull data from SAP using direct download and push it in our database. like this:

SAP OPD Object --> Query Transform --> Sybase Database

Inside query transform,we have applied one simple condition in where clause.

When we are generating optimized SQL for the same,we observe that the conditions in where clause are not being included in the optimized query.

The issue is only observerd for SAP ODP Tables using SAP Table it works fine.

Any help is appreciated.

Best Regards,

MJ

:)

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Jul 19, 2017 at 10:11 AM

    Hi Michael Jennings,

    when used ODP object in a regular Dataflow, the where conditions are not pushed down. Use ODP object in ABAP dataflow to full Push down.

    Thanks,

    Ravi kiran

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 26, 2017 at 03:27 PM

    Ok,

    Thanks Ravi.

    Best Regards,

    MJ

    :)

    Add comment
    10|10000 characters needed characters exceeded