arcplan and its new Function "Assign"

arcplan and its new Function "Assign"

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.

Table of Contents

Simple Example:

For an analysis, we want to retrieve last month's revenues from system 1; a certain number of data sets is returned.  

arcplan-funktion-zuordnen-system-1

All master data is stored in a different data source (system 2). The list is considerably longer and sorted differently (in alphabetical order).

arplan-funktion-zuordnen-system-2

For sales reporting, address information shall now be added and correctly matched to the suppliers with revenues:

arcplan-funktion-zuordnen-system-1-ort

By means of the "Assign" function, the whole issue is easy to handle:

arcplan-funktion-zuordnen

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.

Want To Learn More? Contact Us!

Olaf Bowe

Your contact person

Olaf Bowe

Domain Lead Insights & Information Design

Related Posts

chevron left icon
Previous post
Next post
chevron right icon

No previous post

No next post