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.
The query from the Adventure Works SSAS Cube shown here identifies the internet turnover of the individual customers (sorted according to country, city, …) using a simple query. The generated MDX does not contain zero row suppression (expression NON EMPTY), so that customers without turnover will be shown in the result, as well. As the recipient of the report would like the zero rows to be suppressed, however, the report is supposed to be adjusted.
There are a number of ways to achieve this with arcplan. Here, however, it will explicitly be implemented with the new function REPLACEEXPRESSION for demonstration purposes.
In order to implement this requirement, the expression NON EMPTY must be integrated into the statement in the MDX in a suitable location. The function REPLACEEXPRESSION operates as follows:
REPLACEEXPRESSION((<Search term>;<Term to be replaced>;<Number of replacements, optional>)
Thus, the function behaves similarly to the search and replace function for texts featured in Word.
Thus, in limited scope, the REPLACEEXPRESSION function allows the expansion of the arcplan standard when accessing the databank, which e.g. permits a better filtering of data in the databank, in particular in the MDX sector on SAP BW or SSAS, as compared to doing it only in arcplan (better performance, more possibilities to filter, statistic operations from the database…)
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 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.
You’re probably in the same boat as many of our clients facing a challenge: how best to integrate SAP BW (SAP Business Warehouse) as the data source for Microsoft Power BI (Power BI). It’s not always an easy task, since it requires due attention to diverse factors, potential challenges, and possible ways to tune performance.
We have compiled a thorough guide of best practices and limits, underscored by our extensive in-depth experience into integrating Power BI with SAP BW. Now we offer you a brief insight in this blog.
No previous post
No next post
