Simple Query against Rollup.
Provides table from .tables() in .rollup().

Code

def qapi = api.queryApi()
def exprs = qapi.exprs()

def t1 = qapi.tables().rollup("P/C Filters (BE 14.0 vs FE 13.1)")

return qapi.source(t1, [t1.CustomerId, t1.ProductId, t1.p1_CustomerLoyaltyProgram, t1.p2_CustomerLoyaltyProgram, t1.p3_ConsignmentCost])
    .stream { it.collect { it } }

Result

Customer Id	Product Id	Customer Loyalty Program (SUM)	Customer Negotiated Discounts (SUM)	Consignment Cost (SUM)

Customer Id	Product Id	Customer Loyalty Program (SUM)	Customer Negotiated Discounts (SUM)	Consignment Cost (SUM)
CD-0001	AK_0001	239.830	243.522	119.181
CD-0002	AK_0002	351.465	235.103	144.959
CD-0003	AK_0003	294.568	296.826	154.262
CD-0004	AK_0004	274.306	237.001	147.769
CD-0005	AK_0005	322.077	268.424	149.298
CD-0006	AK_0008	293.580	241.317	132.004
CD-0007	B-0001	322.282	229.054	143.487
CD-0008	B-0001-Collaboration	302.803	264.829	147.682
CD-0009	B-0002	310.168	255.278	167.173
CD-0010	B-0003	236.072	276.858	141.086

Simple Query Rollup

Code

Result

See Also