Is there any way to use an RDD to feed an executive query or dashboard? The problem I am running into is that I have 2 queries that I want to show the summary data for, in the same chart. For example:
Ignoring the actual values (populated as random values for illustration). Here I have two sources of data.
- A list of each department, and the total Open Job Target Value for that department.
- A list of every open job and the current value, with the next department in the op sequence. In this example we are only looking at the sheetmetal department.
Each day I have to run the BAQ report that is based on my RDD, which contains all four queries needed to make this work together. In that RDL, one of the data sources was modified to include data from two queries, thus merging the results in the way that I need.
How To Merge These into One Report? - Kinetic 202X - Epicor User Help Forum (epiusers.help)
How do I include more than one BAQ in my executive query? I can’t join the queries in the dashboard, right?
I think that the executive queries will do it. I will post back when I get it all sorted out.
Thanks!