Skip to Content
0
Sep 02, 2021 at 09:38 AM

SAC: Long response times in when using setVariableValue() instead of manual user prompt

304 Views

Hello,

we're currently facing the problem that several analytic applications in our environment are facing very long response times on the established live data connection from SAC to SAP BW/4HANA – especially in case of the selection of Fiscal Year.

The selection of Fiscal Year (0FISCYEAR) in the applications has been implemented as drop-down box-selection, which executes method setVariableValue() in the underlying script in order to filter the application on a new fiscal year as a single value. This approach of using setVariableValue() has proven to be unavoidable due to specific requirements in the implementation and shall not be deepened or discussed.

To request another value of 0FISCYEAR for the dashboard takes approx. 18.5 sec!

At the same time, it has been realized that a manual selection of the exact same variable via the given SAC standard user prompt is loading the same data set with much lower latency / less waiting time. To execute the BEx variable for 0FISCYEAR in this case only takes approx. 2.5 – 3 sec for the exact same use case!

Since the two approaches functionally should be identical, the two questions come up:

  • Why is the manual user prompt so much faster in loading the data than method “setVariableValue()” and
  • Is there a way to make use of this functionality also via scripting? That means is it possible to access the same interface for variable selections, which is used by the user prompt and hereby to automatically execute new variable values for the application via script? If not, is it planned to open this interface/functionality also for BIAL scripts in future revisions?

Best regards