BODS: Restrict rows in SAP ECC datasource

[LeeFung]

I am pulling data from an SAP ECC table.  How can I restrict the # of rows in the source, like using an SQL query to restrict rows in an RDBMS datasource? Thanks.

[former_member198401 · Accepted solution]

Whats your Source Database

You can try the following where clause of a Query transform

Oracle: pushdown_sql('<datastore name>','ROWNUM <= 100')

Not sure about SQL Server. But there must be some way out

Regards

Arun Sasi

[former_member198401 · Accepted solution]

Oops I didnt see that your Source is ECC.

Pushdown_sql() doesnt work with SAP Applications datastore(SAP ECC, SAP CRM etc)

Pushdown_SQL

Regards

Arun Sasi

[former_member187605]

If the exact number of records is not important add a condition like  PK_Column <= <some profiled value> to the where-clause.

If you really want an exact number of records in the output, you can add a 2nd query transform with a where-clause: gen_row_num() <= 1000