arcplan offers a number of possibilities to set up a classic V-Lookup, as it is often used in Excel. One of these possibilities can be found under the blog entry Tips & Tricks: The Repeat Loop as Performance Killer.
The method described here works via the cross product of two tables and, as bulk operation, constitutes a “Left Outer Join”, while the intersection constitutes an “Inner Join”.
Let’s assume that the data comes from two different data sources. In one of the sources, data about the unit and sales prices is located; in the other source, data about the order volumes is located.
In our example, the data comes from the SAP System; thus, the cross product is generated via the keys. This is mainly important if the titles of the products change or if they differ from the start.
For the cross product from the keys, the information from the table “Key_1” and “Unit Price” is transformed into lines ([OBJ29] and [OBJ30]). In the table itself, the value is taken from line [OBJ30], while the contents in column [OBJ28] and line [OBJ29] remain the same. In case of inequality, the cell remains empty.
The result of the cross product may be merged into one column via the function MAX().
When using the function, please note that arcplan loads all information of the reports which are required for the display of the data on the report level into the memory. Thus, if multiple cross products are formed as shown in the picture above, the table contents are all loaded into the memory.
In order to avoid this, the function can also be reproduced directly in a column. For this purpose, the functions of the pictures above are coordinated in one object.
Principally, however, the rule is: anything that can be already merged via the request should be merged there.
Looking to become more data-driven, optimize processes, or leverage cutting-edge technologies? Our blog provides valuable insights – but the best way to tackle your specific challenges is through a direct conversation.
Let’s talk – our experts are just one click away!
Domain Lead Insights & Information Design
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.
SAP data integration is complex: performance issues, storage limitations, and third-party system integration pose significant challenges for businesses. With our flexible framework, you can create a powerful and scalable solution that seamlessly complements SAP BW and S/4HANA—efficient, future-proof, and cost-effective.
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,
No previous post
No next post
