Fine-Tuning Data Access

The following properties may also be useful in certain situations:

• QueryPassthrough: Indicates if MDX queries are being submitted. By default this is False, which causes the provider to accept only SQL-92 compliant queries.

  Setting this property to True causes all queries to be passed through directly to SAP Business Warehouse.

• ExtraProperties: Specifies additional properties to submit along with an MDX query.
• IncludeJoinColumns: Indicates if extra columns used to make ON conditions with joins should be added.

  These do not return any values. They are added purely to enable tools that require them to automatically set up relationships between tables when creating joins.

• ResponseRowLimit: Sets a calculated limit on the number of rows returned before an error is raised.

  Because queries are being translated to MDX, selecting only a few columns may exponentially multiply the number of expected results.

  For this reason, ResponseRowLimit is available to provide some guidance on what types of queries are likely to result in a timeout. You can disable this by setting it to 0.