Is it possible to create logical tables in the Epicor Kinetic database?
Userlevel 4
Please can you provide some context as to what you are trying to achieve?
Use a smaller data set sorted for certain long running reports or processes.
In SQL this would be called a View.
Userlevel 4
In Epicor you would achieve this via a BAQ which is essentially a SQL view of sorted, grouped, calculated data in 1 or more queries/sub-queries
I have yet to find anything significant that cannot be achieved within the BAQ designer v SQL Views
If you are on premise then you can do what you want at the SQL end, including creating views and then hooking BAQs up to them so you can display the data in dashboards, however if you are SaaS then BAQs are the only route available to you
NB: Don’t forget you can create BAQ reports as well
Thank you for the information. I appreciate it.
Issue Solved
Thanks
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.