Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

limited load with SAP connector.

Hi

when developing new (and complicated) extraction processes it is absolutely necessary to debug them with a limited amount of data.

If the script should be ready and correct the complete data load can start.

For huge R/3 tables the connector needs hours to get ready (no matter whether I limit data using the debugger or using the first statement).

This is a very bad effect for my QV-development productivity.

It would be a benefit for all to speed up SAP extraction with subsets of data.

regards

Eckhard Schneyinck

1 Reply
disqr_rm
Valued Contributor III

limited load with SAP connector.

Hi Eckhard,

You can introduce a variable in the beginning of the script, say vDebug, and when it is set to "X", you can introduce a WHERE condition automatically in the extract query, on a table field (like BUKRS, or VKORG, etc.).

In any case, debugging based on a variable is always a good idea, as while debugging you may want to restrict load on the main (big) table but you may want to load all records from smaller (text, dimension) table.

Hope this helps.

Rakesh