A very frequent use case in reporting is the linking and displaying of information from either different tables or even different data sources. Frequently, a database view or even an intermediate step via a database layer, in which the data from different sources is merged, is required for this purpose. With the "Assign" function, arcplan offers a simple and quick possibility to link data in the report and in real time.
For an analysis, we want to retrieve last month's revenues from system 1; a certain number of data sets is returned.
All master data is stored in a different data source (system 2). The list is considerably longer and sorted differently (in alphabetical order).
For sales reporting, address information shall now be added and correctly matched to the suppliers with revenues:
By means of the "Assign" function, the whole issue is easy to handle:
The "Assign" function is able to match information/data (here: Ort System 2) to certain properties (here: Lieferant System 1).
The data is matched via two reference columns (here: Lieferant System 1 and Lieferant System 2).
A simple but very powerful function which has been available since arcplan 7.5.8.
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
