Crosstab BAQ - is it possible to create?

Epicor ERP 10
1

Hi, we are on E10.1.400.14 version. I am wondering if it is possible to create crosstab BAQs and Dashboards in Epicor?

2

In Help, search for Pivot and check out the topic: “Aggregate Data Using Pivot”

Mark W.

3

Thanks Mark, this helped.

MIKE TONOYAN | Application Maintenance
MTonoyan@NatelEMS.commailto:MTonoyan@NatelEMS.com
Tel +1.818.734.6511 | Cell +1.818.397.8515

4

Mark, do you know if it’s possible to define dynamic column headings instead of having a constant fields? In my case I would like to have dates for every Monday of every week of the year as column headers with forecast and order release quantities.

5

Mark,
Pointing to help worked really well.
The example was simple - looking forward to leveraging this in other areas.
Instead of counting the sales orders, could sum the amount of the sales orders or shipments.

Bruce Larson
Principal Consultant
Larson Solutions
763-486-0030 | Bruce@LarsonSolutions.com

6

I don’t think so, not in BAQ. However, if you feel comfortable to T-SQL, I would take Jeff Brus’s advice (from the EUG forum) and look at an External BAQ. You can leverage the power of stored procedures which allows you to do this kind of thing.

Mark W.

7

Thanks again, I was afraid I had to do that.