In arcplan, the individual selection constitutes a fixed list of elements which were selected by the developer. Up to arcplan Enterprise 6, a database query for an individual selection did not take place. Thus, this could be used for performance optimizations or for a pre-selection. However, customers frequently requested an add-on for updating the displayed texts. As a database query did not take place, there was no update here, either. For example, a typo corrected in the database was not updated in a performance indicator as it was not screened against the database. From a performance perspective, this was optimal, as well.
Since arcplan 7, this behavior was changed due to the customer requests. Unfortunately, this may lead to severe performance issues in case of MDX based connectors (e.g. SAP BW or SQL Server Analysis Services). The MDX query which is generated in order to update the texts now screens the entire cube almost without any limitation. The query may be viewed in the database dialogue.
An individual selection for definition of a date requests the related data. The MDX shows that all performance indicators of the third quarter 2007 are identified just to update this one text.
Here the results of the query in the SQL Server Management Studio.
The performance indicator dimension was selected and limited. The system now identifies the performance indicator values and names without any limitations.
As a result, this report would accordingly contain two additional database queries as from arcplan 7. Depending on the complexity, this may, of course, grow indefinitely.
As mentioned in the title, it is unclear, however, whether the individual selection will become a performance killer or whether it may be possible to use it for optimization, after all. By an adjustment of the arcplan settings file, a function can be activated which is able to restore the old behavior, if desired per object. In this context, it is important to note in case of an upgrade from an old version that this is a manual process and must be carried out for each relevant individual selection.
1. Activation of the functionality in settingsDesigner.xml and settingsServer.xml
In order to activate the functionality, the following command must be added in the settings:
<option optionType="bool">
<key>USEAUTOUPDATEPROPERTYFORINDIVIDUALSELECTION</key>
<value>1</value>
</option>
2. Restart arcplan Designer and the server
3. Set the database properties of the object with the individual selection to "no automatic update".
After restarting the application, verify that a query is no longer triggered. (Note: if the object was already queried, the query does not disappear. The file must be re-opened for this purpose. As a precaution, the application should be completely shut down.)
Thus, the old behavior is available if desired which provides more flexibility during development. However, it is essential to remember this for developing applications and in particular for upgrades from an older version.
Do you want to replace the IoT core with a multi-cloud solution and utilise the benefits of other IoT services from Azure or Amazon Web Services? Then get in touch with us and we will support you in the implementation with our expertise and the b.telligent partner network.
Domain Lead Insights & Information Design
With the new function REPLACEEXPRESSION, arcplan 7 affords the possibility to influence the automatically generated SQL and MDX statement. This has the benefit that a design can continue to be made with “arrows” and that one is not limited to formulas. Currently, only simple adjustments of the query are possible with this tool; however, there is a large impact on the resulting possibilities.
With the Q2 2023 updated titled "New optimized story experience - unified strories and applications", SAP analytics cloud offers users new ways to develop reports and dashboards even more flexibly and easily in an integrated design enviroment. We'll showyou which new features theupdate provides and how it supports you in creating reports,
As a business intelligence package, SAP BW provides many opportunities for efficient reporting – but also contains numerous barriers which significantly slow down performance. Using the example of report filters available in the application, this article shows how the smallest adaptations impair SAP BW performance, and how efficient settings for filtering options can improve results.
No previous post
No next post
