-
Simple Query against Rollup.
-
Provides table from
.tables()in.rollup().
Code
Groovy
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) |
|---|---|---|---|---|
|
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 |