We have two sites registered under one company for Epicor. How can I have our dashboards run and only show data for the site the user is logged in as? i.e., if I am currently logged into Site A, I only would like to see data from Site A when running said dashboard.
In your BAQ you can filter the table(s) by current site. Add a filter to the table on the Plant field, and choose the BAQ Constant. That will filter your results by the the site that you are logged into.
8 Likes
I added the parameter Plant = BAQ CurrentPlant constant to all applicable tables, but the Query still seems to bring in Part Numbers from the other site.
You’re gonna have to show me what you’re doing if you want me to help you here.
Parts belong to the company, not the site. There is no such thing as part numbers from a different site.
1 Like
Yeah, but you can back into it using warehouse if you really want to.
You can back into it with part plant if you really want to which is simpler, but those are planning parameter records not part records.
1 Like
We have the Part Plant table in there and filtering on Current Plant. Is there something else we can do with that table?
Show your current BAQ
Are you sure there is no part plant record for the part?
or, add it as a subquery criteria instead of a table criteria.
3 Likes