Mar 6, 2015
8.5.2025
8.5.2025
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
OData is the language your SAP system uses to talk to the world today. We'll show you step by step how to turn an idea into a production-ready, delta-capable OData service in S/4HANA or ECC.
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.
No previous post
No next post
