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 add-in 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.