Optimize Query Performance (Specifics for SAP BW)

Reduce the amount of metadata that is loading in your widget to increase performance when using queries with two structures.

You are working with a large number of structure members and you notice decreased performance. To reduce the amount of metadata, use the flag to optimize query performance in the Data and Performance section of the (Model Preferences) dialog.

When switching on this option, you need to be aware of the following impacts:

• User-defined formatting that is set up in the model is not applied. Instead, scale or decimal place settings from the SAP BW backend are adopted.

• Variance charts show reversed values in measures with sign reversal.

• Sign reversal for restricted measures is not supported.

• Error bars cannot build a percentage-specific formula for SAB BW percentage measures.

• The styling panel does not show correct values for scale and decimal places.

• In the geo tooltips, the scaling factor is not displayed according to the settings.

• Date and time measures cannot be used for charts or geo maps even though they are displayed in the drop-down menu of the Builder panel.