Skip to Content
0

Optimized sql not properly generated when using SAP ODP Object

Jul 18, 2017 at 08:45 PM

39

avatar image

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

:)

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Ravi kiran Pagidi Jul 19, 2017 at 10:11 AM
1

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

Share
10 |10000 characters needed characters left characters exceeded
Michael Jennings Jul 26, 2017 at 03:27 PM
0

Ok,

Thanks Ravi.

Best Regards,

MJ

:)

Share
10 |10000 characters needed characters left characters exceeded