In the first two blog posts of that ACL Analytics™ series (Four practical text field functions, The Classify workaround) we have seen how text fields can be combined easily and what benefits we gain from it. Today I will show you another use case for this functionality.
An essential advantage of ACL Analytics™ is that it is not only ideally suited for working with table or spreadsheet-like data (which is something which we primarily associate with Microsoft Excel™), but also includes the part of connecting several tables via key fields like Microsoft Access™ is doing.
As the information to be analyzed are usually distributed across several tables (as in fact, most of the data comes from relational databases), ACL Analytics™ provides the ability to connect them through relations to perform cross-table analytics.
The consideration of purchasing documents is a good example here. SAP® and other ERP systems manage these and other relevant information in several tables. The purchasing documents themselves are divided into two tables, “purchasing document header” and “purchasing document items”. Information about vendors, the company code or the place of storage are saved in their own master data tables. So-called “key fields” identify certain records in a table and enabling the connection to other tables at once. For example, the field “company code” in table purchasing document items is a key field that refers to the company code master data table. Now, if you want information from this table e.g. the name of the company code, just use the following procedure: