Converting RDD to BAQ

Epicor ERP 10
,
1

I have an internal request from our Planning department to see if I can convert the BOM Availability Report into a dashboard. Knowing that out-of-the-box (OOTB) Epicor reports are data sourced by RDD, I can easily find the SQL query for the data source in plain text by looking at the dataset properties. Typically, the SQL query for the data source references tables as aliases by “T1”, “T2”, “T3”, and so on.

In an example like this one from the “BOMResAv” RDD:

SELECT
T1.PartNum
, T1.MtlSeq
, T1.ComponentType
, T1.Level
, T1.ParentPart
, T1.ParentMtlSeq
, T1.[Description]
, T1.PartType
, T1.RequiredQty
, T1.UOM
, T1.Revision
, T1.Indentor
, T1.DisplayOrder
, T1.IsSubstitute
, T2.ParentPartNum
, T2.ParentCompType
, T2.Whse
, T2.OnHandQty
, T2.WhsUOM
, T2.AvailableQty
, T2.UOM as PartWhseBOMResAv_UOM
, T1.[AltMethod]
, T1.[Company]
, T3.[ClassID]
 FROM
PartBOMResAv_" + Parameters!TableGuid.Value + " T1
	LEFT OUTER JOIN PartWhseBOMResAv_" + Parameters!TableGuid.Value + " T2
		ON T1.Company = T2.Company 
		AND T1.ParentPart = T2.ParentPartNum 
		AND T1.ParentMtlSeq = T2.ParentMtlSeq 
		AND T1.ComponentType = T2.ParentCompType 
		AND T1.MtlSeq = T2.MtlSeq
	LEFT OUTER JOIN Part_" + Parameters!TableGuid.Value + " T3 
		ON  T1.[Company] = T3.[Company] 
		AND T1.[PartNum] = T3.[PartNum]

… what is a good way to figure out which tables the RDD is using?

Is there a typical method for this?

2

I think a big issue with trying to duplicate an RDD’s functionality, is that there is “magic” that happens behind the curtains. The Query expression in an RDL only shows how the report gets the temp data created by the RDL.

Since there is no table named PartBOMResAv, you can’t simply query it. That only exists after the RDD has done it’s magic. So knowing how to replicate PartBOMResAv is your real issue.