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:
Best regards