Need help with AML query to connect two independent ItemTypes via referencing item

Hi Eli,

here some update: The warehouse view was a big hit and people love it! In the meantime a second use case showed up and I identified a scenario where Federated Data in Query Definitions will become EPIC. 

-> Use Federated Data with the new Reporting Feature and show diagrams with federated data in the Dashboard!

Use case:

Let´s assume we produce electronic products, and each device is tested after manufacturing. The testing process involves various methods, with voltage and current measurements being commonly included. Typically there is a department responsible for these tests, which plans the tests and analyzes the results. For this purpose, there is dedicated hardware and software. 

In the phase of production ramp-up, additional stakeholders are interested in the test data as it provides valuable insights into the process and ensures everything is running as expected. Monitoring and analyzing the data closely allows any potential issues to be identified and resolved early, optimizing the production process.
But not everybody has access to the test software and database so using federation to display test certain data in Innovator is an elegant solution. 

I got the following request: 'Please provide this and that data so I can export an Excel file and generate charts.'

Yeah, the classic Excel approach. Of course, this is not how we handle it. Excel is not ideal because it only provides a snapshot of the data, lacks real-time monitoring, is prone to human error and struggles with large datasets.

One solution is to provide some diagrams and reports directly from the SQL Report Server. This works fine and people are happy. Of course the MS SQL Report Server only offers limited access control as it doesn´t honor the permission system of Innovator. But Query Definitions do!

This leads us to the new Aras Reporting features. The possibility to display charts in the dashboard would be the icing on the cake, cause people can have an instant live view to data of interest. In the simplest case, they just want to know how many products have been tested and how quickly. In other cases, they may need to monitor a specific component. These kind of view are perfect for  users who don't primarily work in the testing department, but still need certain data, such as quality managers, engineers, product managers, manufacturing planning,... 

So if Aras don’t have any plans for 2025 yet - go for it! :)

Hi Eli,

here some update: The warehouse view was a big hit and people love it! In the meantime a second use case showed up and I identified a scenario where Federated Data in Query Definitions will become EPIC. 

-> Use Federated Data with the new Reporting Feature and show diagrams with federated data in the Dashboard!

Use case:

Let´s assume we produce electronic products, and each device is tested after manufacturing. The testing process involves various methods, with voltage and current measurements being commonly included. Typically there is a department responsible for these tests, which plans the tests and analyzes the results. For this purpose, there is dedicated hardware and software. 

In the phase of production ramp-up, additional stakeholders are interested in the test data as it provides valuable insights into the process and ensures everything is running as expected. Monitoring and analyzing the data closely allows any potential issues to be identified and resolved early, optimizing the production process.
But not everybody has access to the test software and database so using federation to display test certain data in Innovator is an elegant solution. 

I got the following request: 'Please provide this and that data so I can export an Excel file and generate charts.'

Yeah, the classic Excel approach. Of course, this is not how we handle it. Excel is not ideal because it only provides a snapshot of the data, lacks real-time monitoring, is prone to human error and struggles with large datasets.

One solution is to provide some diagrams and reports directly from the SQL Report Server. This works fine and people are happy. Of course the MS SQL Report Server only offers limited access control as it doesn´t honor the permission system of Innovator. But Query Definitions do!

This leads us to the new Aras Reporting features. The possibility to display charts in the dashboard would be the icing on the cake, cause people can have an instant live view to data of interest. In the simplest case, they just want to know how many products have been tested and how quickly. In other cases, they may need to monitor a specific component. These kind of view are perfect for  users who don't primarily work in the testing department, but still need certain data, such as quality managers, engineers, product managers, manufacturing planning,... 

So if Aras don’t have any plans for 2025 yet - go for it! :)