SAP data reader parameter and use current selection

Question

Hello,

Is somebody as expertise with SAP data reader? Where can I find information about the parameter option?

Have you use the use selection with SAP data reader? I have try it and it didnt wor.

By the way I use the BOARD dedicated connector.

Thank you and best regards

Marcel

Etienne CAUSSE · Answer

Hi Björn Reuber

Is the possibility to use @Selection in the query parameters planned for the future ?

That would be clearly a huge step forward to simplify some of the SAP data transfer architectures that we have today.

Etienne

unknown · Answer

Thanks Björn

Björn Reuber · Answer

Hi,

the parameter can't handle variables, so you can't use @Selection.

Further details you can find in following article

How To: Set parametric WHERE clause for SAP Connector in a BOARD Procedure

We're using this to reduce the time slices (in a manual way) in board, htat we doesnt create "huge" queries in SAP.

So we have one DataReader with a parameter on SAP side (to choose hte year) and we have a procedure where we can decide which year should be loaded.

The most common use (I think) would be to load different currencies or languages to a cube

Regards

Björn