Specifies whether the provider attempts to add a default value for all variables required to execute generated queries.

Data Type

bool

Default Value

true

Remarks

When set to True, the driver enables simpler query patterns when it is not necessary to customize cube data using the SAP VARIABLES clause.

For example, instead of executing a complex join like this:

SELECT * FROM Customers JOIN SAPVARIABLES WHERE SAPVARIABLES.varname = 'value'

You can simply execute:

SELECT * FROM Customers

Set this property to False to disable this behavior.

See Retrieving SAP BW Data for more information on the SAP VARIABLES clause.