Hello! I created a dashboard and BAQs in our dev environment then export dashboard with BAQs and imported to live. The dashboard does not work nor do the individual BAQs. I have created BAQs in live that worked. Any ideas where to look?
Thanks!
@PDoh Not that it is relevant to the errors which we will need to see, but using solution workbench to transfer Dashboards and BAQs is best especially after the first round.
To @Matthew_Morgan point what are the errors in the baq designer? When you analyze or when you test?
No errors when I run the dashboard, from dashboard designer, or queries in query designer. No records are returned and yes there is data.
Tried solution workbench and still didn’t work. Building the queries in live and they seem OK except for customer. I am getting flagged on a UD field on the customer. I think that maybe a problem but does not explain why I can’t run the two other queries for vendors and parts. They are simple count records queries for a data conversion.
Maybe a closed join or some criteria that imports OK but short circuits the BAQ?
Can you supply some of the query details?
I got it! Have not written BAQs and DB in a while. The top query is the company. I had return matching rows from both tables on the links, eg customer contacts. Well, what if the customer contacts weren’t loaded yet?? I changed all the links to return all company records and they work. Thanks everybody for responding!!
1 Like