Dashboard Parameter Link - Help Needed

[dgreenEA (Dylan Green)]

@Vinaykamboj,

Gave that a shot and it doesn’t seem to work in this senario. The BAQs both have a recursive CTE union. For more info on how it works check out @Doug.C 's example when he showed me how to build them:

BAQ Union/Union All - Help Needed

You can make a recursive BOM indenter as mentioned, however, with your current set up the only thing you need to do to make it union is to add several UnionAlls which have the subqueries inside of them. As shown below. I use this method because RecursiveCTE indenters don’t like group by functions in the anchor, and I don’t want duplicates of a part within a level. The union all basically rolls up whatever fields from what is inside it’s subquery into the subquery. In my instance I roll up all t…

More or less the BAQ has to have a parameter in order for it to create a limited amount of returns. Otherwise, it just creates an indented BOM for every part ever and there is little to no traceability on what came from where.