Page Comparison

def dmCtxctx = api.getDatamartContext()
// without initial filter: def filterfilterBuilder = api.datamartFilterBuilderUserEntry("Filter", "Transaction DM")
def filter = apiFilter.datamartFilterBuilderUserEntryequal("FilterInvoiceDateYear", "Transaction DM", Filter.equal("InvoiceDateYear"2015")
def filterBuilder = api.datamartFilterBuilderUserEntry("Filter", "2015")Transaction DM", filter)
api.trace("FilterfilterBuilder", null, filterfilterBuilder)

def dm = dmCtxctx.getDatamart("Transaction DM")
def q = dmCtxctx.newQuery(dm)
q.select("Country")
q.select("CustomerID")
q.select("ProductID")
q.select("SUM(InvoicePrice)", "Revenue")
q.select("SUM(Quantity)", "Volume")
q.where(filter)
api.trace("Query", null, qfilterBuilder)

def result = dmCtxctx.executeQuery(q)
api.trace("Data", null, result?.data)

return result

def dmCtxctx = api.getDatamartContext()
def dimFilters = ["CustomerID", "ProductID"]
def filter = Filter.equal("Country", "Italy")
def filterBuilder = api.datamartFilterBuilderUserEntry("Italy", "Transaction DM", dimFilters, Filter.equal("Country", "Italy")filter)
api.trace("Filter", null, filterfilterBuilder)

def dm = dmCtxctx.getDatamart("Transaction DM")
def q = dmCtxctx.newQuery(dm)
q.select("Country")
q.select("CustomerID")
q.select("ProductID")
q.select("SUM(InvoicePrice)", "Revenue")
q.select("SUM(Quantity)", "Volume")
q.where(filterfilterBuilder)
api.trace("Query", null, q)

def result = dmCtxctx.executeQuery(q)
api.trace("Data", null, result?.data)

return result

def dmCtxctx = api.getDatamartContext()
def dimFilters = ["CustomerID": "CD-00155", "ProductID": "MB-0005"]
def filter = Filter.equal("Country", "Germany")
def filterBuilder = api.datamartFilterBuilderUserEntry("Germany", "Transaction DM", dimFilters, Filter.equal("Country", "Germany"))filter)
api.trace("Filter", null, filterfilterBuilder)

def dm = dmCtxctx.getDatamart("Transaction DM")
def q = dmCtxctx.newQuery(dm)
q.select("Country")
q.select("CustomerID")x§
q.select("ProductID")
q.select("SUM(InvoicePrice)", "Revenue")
q.select("SUM(Quantity)", "Volume")
q.where(filterfilterBuilder)
api.trace("Query", null, q)

def result = dmCtxctx.executeQuery(q)
api.trace("Data", null, result?.data)

return result