Eclipse BIRT Designer Version 4.8.0.v201806261756 MailingSummaryDataCube.MailingSummaryDataSet.x integer false MailingSummaryDataCube.MailingSummaryDataSet.y integer false MailingSummaryDayDataCube.MailingSummaryDayDataSet.x integer false MailingSummaryDayDataCube.MailingSummaryDayDataSet.y integer false SummaryDataCube.OptimizationSummaryDataSet.x integer false SummaryDataCube.OptimizationSummaryDataSet.y integer false 135 80 135 80 135 80 WEB-INF/classes/messages in chartPalette.length ? "#0071B9" : chartPalette[index]; } function getPaletteColorByGroupId(groupId) { if (isWinnerMailing(groupId)) { return translateColor(getPaletteColor(0)); //color-dark-green } else { return translateColor(getPaletteColor(groupId + 2)); } } function translateColor(colorRgb) { var red = "0x" + colorRgb.substr(1, 2); var green = "0x" + colorRgb.substr(3, 2); var blue = "0x" + colorRgb.substr(5, 2); return ColorDefinitionImpl.create(red, green, blue); } function getColorDefinition(styleName) { var color = ColorUtil.format(reportContext.getDesignHandle().findStyle(styleName).getColor().getRGB(), ColorUtil.HTML_FORMAT); return translateColor(color); }; //autooptimization groups data function getMailingGroupName(groupId) { switch (groupId) { case -1: return "" + tr("Sum"); case 0: return "" + tr("mailing.autooptimization"); case 1: return autoOptData.getTestGroup1(); case 2: return autoOptData.getTestGroup2(); case 3: return autoOptData.getTestGroup3(); case 4: return autoOptData.getTestGroup4(); case 5: return autoOptData.getTestGroup5(); default: return "" + tr("Unknown"); } } function getMailingIdByGroupId(groupId) { switch (groupId) { case -1: case 0: return -1; case 1: return autoOptData.getTestGroup1Id(); case 2: return autoOptData.getTestGroup2Id(); case 3: return autoOptData.getTestGroup3Id(); case 4: return autoOptData.getTestGroup4Id(); case 5: return autoOptData.getTestGroup5Id(); default: return -1; } } function getGroupIdByName(name) { if (tr("Sum") == name) { return -1; } if (autoOptData.getTestGroup1() == name) { return 1; } if (autoOptData.getTestGroup2() == name) { return 2; } if (autoOptData.getTestGroup3() == name) { return 3; } if (autoOptData.getTestGroup4() == name) { return 4; } if (autoOptData.getTestGroup5() == name) { return 5; } return 0; }; function isWinnerMailing(groupId) { return getMailingIdByGroupId(groupId) == autoOptData.getWinnerId(); } function getMailingGroupNameTitle(groupId, baseGroupId) { var name = getMailingGroupName(groupId); if (groupId == 0) { name += "\n(" + getMailingGroupName(baseGroupId) + ")"; } return name; } // percentage representation function hasPercentageRepresentation(categoryKey) { if (mailingSummaryDataDefinition[categoryKey] && mailingSummaryDataDefinition[categoryKey]["hasNoPercentageRepresentation"]) { return !mailingSummaryDataDefinition[categoryKey]["hasNoPercentageRepresentation"]; } return true; } function calculatePercent(value, totalValue) { if (totalValue > 0) { return (value / totalValue) * 100; } return 0; } function formatPercent(percent) { return new Packages.java.text.DecimalFormat("##0.0").format(percent); } // position function getKeyFiguresRowPosition(categoryKey, categoryIndex) { if (mailingSummaryDataDefinition[categoryKey] && mailingSummaryDataDefinition[categoryKey]["position"]) { return parseInt(mailingSummaryDataDefinition[categoryKey]["position"]); } return parseInt(1000000 + categoryIndex); // Bump to the end }; function getCrossTableColumnPosition(groupId) { if (groupId == CommonKeys.OPTIMIZATION_SUMMARY_GROUP_ID) { return parseInt(1000000); // Bump to the end } if (groupId == CommonKeys.OPTIMIZATION_WINNER_GROUP_ID){ return 1; } return parseInt(groupId + 1); } function getKeyFiguresColumnPosition(groupId) { if (groupId == CommonKeys.OPTIMIZATION_SUMMARY_GROUP_ID) { return 1; } if (groupId == CommonKeys.OPTIMIZATION_WINNER_GROUP_ID){ return 2; } return parseInt(groupId + 2); // Bump to the end }; function getKeyFiguresColumnPositionByName(name) { return getKeyFiguresColumnPosition(parseInt(getGroupIdByName(name))); } //wrap function wrap(str, width) { var length; if (str.length instanceof Function) { length = str.length(); } else { length = str.length; } if (length <= width) { return str; } return str.substring(0, width) + "\n" + wrap(str.substring(width, length), width); } //format date function formatDate(dateValue) { if (dateValue == null) { return ""; } if (reportContext.getLocale().getLanguage() == "de") { return new Packages.java.text.SimpleDateFormat("dd.MM.yyyy").format(dateValue); } else { return new Packages.java.text.SimpleDateFormat("yyyy-MM-dd").format(dateValue); } } // translation function tr(key) { return Packages.com.agnitas.messages.I18nString.getLocaleString(key, reportContext.getLocale()); } function getTranslationByCategory(categoryKey) { if (isDataDefinitionContainsTranslation(categoryKey)) { return tr(mailingSummaryDataDefinition[categoryKey]["translationKey"]); } return tr(categoryKey) }; function isDataDefinitionContainsTranslation(categoryKey) { return mailingSummaryDataDefinition[categoryKey] && mailingSummaryDataDefinition[categoryKey]["translationKey"] }; //chart series and tooltips function getSeriesTooltips(categoryKey, value, rate) { if (hasPercentageRepresentation(categoryKey)) { return makeLabelWithPercent(value, rate); } else { return value; } } function makeLabelWithPercent(value, rate) { curValue = Packages.java.text.NumberFormat.getNumberInstance(reportContext.getLocale()).parse(value); percent = Packages.java.text.NumberFormat.getNumberInstance(reportContext.getLocale()).parse(rate) * 100; return formatPercent(percent) + '%; ' + value; } reportContext.setGlobalVariable("mailingSummaryDataDefinition", mailingSummaryDataDefinition); reportContext.setGlobalVariable("hasPercentageRepresentationFunction", hasPercentageRepresentation); reportContext.setGlobalVariable("getKeyFiguresRowPositionFunction", getKeyFiguresRowPosition); reportContext.setGlobalVariable("getKeyFiguresColumnPositionFunction", getKeyFiguresColumnPosition); reportContext.setGlobalVariable("getCrossTableColumnPositionFunction", getCrossTableColumnPosition); reportContext.setGlobalVariable("getPaletteColorByGroupIdFunction", getPaletteColorByGroupId); reportContext.setGlobalVariable("tr", tr); reportContext.setGlobalVariable("wrap", wrap); reportContext.setGlobalVariable("formatDate", formatDate); reportContext.setGlobalVariable("getTranslationByCategoryFunction", getTranslationByCategory); reportContext.setGlobalVariable("getMailingGroupNameFunction", getMailingGroupName); reportContext.setGlobalVariable("getSeriesTooltipsFunction", getSeriesTooltips); reportContext.setGlobalVariable("calculatePercentFunction", calculatePercent); reportContext.setGlobalVariable("formatPercentFunction", formatPercent); reportContext.setGlobalVariable("getGroupIdByNameFunction", getGroupIdByName); reportContext.setGlobalVariable("getKeyFiguresColumnPositionByNameFunction", getKeyFiguresColumnPositionByName); ]]> /templates/blank_report.gif auto layout ltr styles.css false true /birt/webcontent/birt/styles/redesign_style.css static integer true 463 simple text-box Unformatted static string true DE simple text-box Unformatted static false string true ;jsessionid=12345 simple text-box Unformatted static false string true http://localhost:8080/css simple text-box Unformatted static boolean true simple check-box static false integer true 0 simple text-box Unformatted static boolean true simple check-box static false boolean true False simple check-box static false boolean true true simple check-box static false boolean true false simple check-box 1 mailingName string 2 mailingId integer 3 subject string 4 targetGroupName string 5 isWinner boolean 6 resultMailing integer 7 groupId integer 8 targetGroupId integer 9 avgMailSize float 10 sendDate date mailingName mailingId subject targetGroupName isWinner resultMailing groupId targetGroupId avgMailSize sendDate 1 mailingName string 2 mailingId integer 3 subject string 4 targetGroupName string 5 isWinner boolean 6 resultMailing integer 7 groupId integer 8 targetGroupId integer 9 avgMailSize float 10 sendDate date DummyDataSource 1) { row["targetGroupName"] = tr(dataRow.getTargetGroupName()); } else { row["targetGroupName"] = tr("statistic.all_subscribers"); } row["targetGroupId"] = dataRow.getTargetGroupId(); row["resultMailing"] = dataRow.getResultMailing(); row["groupId"] = dataRow.getGroupId(); row["targetGroupId"] = dataRow.getTargetGroupId(); row["avgMailSize"] = dataRow.getAvgMailSize(); row["sendDate"] = dataRow.getSendDate(); currentrow++; return true; } return false;]]> 1 category string 2 category_index integer 3 targetgroup string 4 targetgroupId integer 5 value integer 6 rate float 7 deliveredRate float 8 mailingId integer 9 mailingName string 10 groupId integer 11 categoryKey string 12 baseMailingName string 13 isWinner boolean 14 baseGroupId integer category category_index targetgroup targetgroupId value rate deliveredRate mailingId mailingName groupId categoryKey baseMailingName isWinner baseGroupId 1 category string 2 category_index integer 3 targetgroup string 4 targetgroupId integer 5 value integer 6 rate float 7 deliveredRate float 8 mailingId integer 9 mailingName string 10 groupId integer 11 categoryKey string 12 baseMailingName string 13 isWinner boolean 14 baseGroupId integer DummyDataSource max) { max = value; } } reportContext.setGlobalVariable("maxValue", parseInt(max)); reportContext.setGlobalVariable("total_sent", parseInt(0)); reportContext.setGlobalVariable("total_delivered", parseInt(0));]]> 1) { row["targetgroup"] = dataRow.getTargetgroup(); } else { row["targetgroup"] = tr("statistic.all_subscribers"); } if (groupId == CommonKeys.OPTIMIZATION_SUMMARY_GROUP_ID) { if (categoryIndex == CommonKeys.DELIVERED_EMAILS_INDEX) { total_sent = parseInt(dataRow.getCount()); reportContext.setGlobalVariable("total_sent", total_sent); } if (categoryIndex == CommonKeys.DELIVERED_EMAILS_DELIVERED_INDEX) { total_delivered = parseInt(dataRow.getCount()); reportContext.setGlobalVariable("total_delivered", total_delivered); } row["mailingName"] = tr("Sum"); } else if (groupId == CommonKeys.OPTIMIZATION_WINNER_GROUP_ID) { row["mailingName"] = tr("mailing.autooptimization"); } else { row["mailingName"] = dataRow.getMailingName(); } row["targetgroupId"] = dataRow.getTargetgroupindex(); row["value"] = dataRow.getCount(); row["rate"] = dataRow.getRate() == -1 ? 0 : dataRow.getRate(); row["deliveredRate"] = dataRow.getDeliveredRate() == -1 ? 0 : dataRow.getDeliveredRate(); row["mailingId"] = dataRow.getMailingId(); row["isWinner"] = dataRow.isWinner(); row["baseMailingName"] = dataRow.getBaseMailingName(); row["baseGroupId"] = dataRow.getBaseGroupId(); currentrow++; return true; } return false;]]> NewTabularHierarchy integer dynamic categoryKey string category string category_index NewTabularHierarchy1 integer dynamic baseMailingName string isWinner boolean baseGroupId integer targetgroup string groupId max false dataSetRow["value"] float true max false dataSetRow["rate"] float true max false dataSetRow["deliveredRate"] float true OptimizationSummaryDataSet a4 landscape 0.25in 0.25in 0.25in 0.25in block-table "Arial" 100% all reportContext.getOutputFormat() != "pdf" && reportContext.getOutputFormat() != "html" 4.041666666666667in 7.09375in half-width table table-stripedblock100%OptimizationMailingDataSet targetGroupName targetGroupName dataSetRow["targetGroupName"] string isWinner isWinner dataSetRow["isWinner"] boolean resultMailing resultMailing dataSetRow["resultMailing"] integer groupId groupId dataSetRow["groupId"] integer avgMailSize avgMailSize dataSetRow["avgMailSize"] float mailingSubject dataSetRow["subject"] string true mailingName mailingName dataSetRow["mailingName"] string true mailingId mailingId dataSetRow["mailingId"] integer targetGroupId targetGroupId dataSetRow["targetGroupId"] integer subjectPrefix tr("mailing.Subject") string true mailingSubjectName if (row["isWinner"]) {tr("resultMailing")} else {row["mailingName"]} string true senDate if (dataSetRow["sendDate"] == null) {tr("statistic.DeliveryStatus.0")} else {formatDate(dataSetRow["sendDate"])} string true namePrefix tr("Mailing") string true row["groupId"] asc -1 ne row["groupId"] CommonKeys.OPTIMIZATION_SUMMARY_GROUP_ID true

table-head left tr("General2") left tr("birt.Target") html left targetGroupName

inline namePrefix bold inline mailingSubjectName mailingSubject tr("report.mailsize") avgMailSize tr('mailing.senddate') html senDate half-width table OptimizationSummaryDataSet category category dataSetRow["category"] string category_index category_index dataSetRow["category_index"] integer targetgroup targetgroup dataSetRow["targetgroup"] string targetgroupId targetgroupId dataSetRow["targetgroupId"] integer value value dataSetRow["value"] integer rate rate dataSetRow["rate"] float deliveredRate deliveredRate dataSetRow["deliveredRate"] float mailingId mailingId dataSetRow["mailingId"] integer mailingName mailingName dataSetRow["mailingName"] string groupId groupId dataSetRow["groupId"] integer categoryKey categoryKey dataSetRow["categoryKey"] string tooltip getSeriesTooltips(dataSetRow["categoryKey"], dataSetRow["value"], dataSetRow["rate"]) string true 2.6.1 Bar Chart Side-by-side 0.0 0.0 0.0 0.0 3.0 3.0 3.0 3.0 -1 -1 -1 -1 1 255 0 0 0 false false Bar Chart Title 16.0 true Center Center 0 255 255 255 1 255 0 0 0 0.0 2.0 0.0 3.0 true 0.0 0.0 0.0 0.0 0.0 0.0 0.0 30.0 -1 -1 -1 -1 1 255 0 0 0 false true 0 20 0 255 0 0 0 false 0 255 255 255 0.0 0.0 0.0 30.0 0.0 0.0 0.0 0.0 West Horizontal 3.0 3.0 5.0 3.0 -1 -1 -1 -1 1 255 0 0 0 false 0 255 255 255 true onclick Toggle_Visibility Pointer 0 255 0 0 0 false 2.0 2.0 2.0 100.0 Arial 10.0 Horizontal Left_Right 1 255 255 0 0 false Above Series Above false 0.0 0.33 0.6 40 0.0 0.0 501.0 270.0 0.0 0.0 0.0 0.0 -1 -1 -1 -1 1 255 0 0 0 false 0 255 255 255 true Auto Two_Dimensional Points 10.0 0 enable.area.alt false 'A','B','C','D','E' 6,4,12,8,10 0 Series 1 true None No data available. Center Center 64 127 127 127 128 127 127 127 true 10.0 10.0 10.0 10.0 true Text Below Linear Left row["mailingName"] 1.0 Text 255 46 52 54 255 136 138 133 255 255 192 0 255 146 208 79 255 0 153 153 255 65 100 26 255 0 113 185 true Arial 10.0 255 79 80 81 0 255 255 255 1 255 0 0 0 false 0 255 255 255 0.0 10.0 0.0 3.0 true row["value"] > 0 ? (row["category_index"] != CommonKeys.REVENUE_INDEX ? row["value"] : row["value"]/100) : 0.000001 Text Sum Series1 Orthogonal_Value Series_Value ; Outside false onmouseover Show_Tooltip row["tooltip"] 200 Auto Rectangle 0 255 255 255 false 1.0 Text Sum Descending getKeyFiguresColumnPositionByName(row["mailingName"]) Vertical 1 255 128 128 128 true Arial 10.0 255 79 80 81 0 255 255 255 1 255 0 0 0 10.0 2.0 0.0 3.0 true 0 Left 1 255 196 196 196 false Across 1 255 204 204 204 true 1 255 225 225 225 false Across 1 255 225 225 225 false 0.0 5 false true Min 0.0 true false Text Below 255 80 166 218 255 242 88 106 255 232 172 57 255 128 255 128 255 64 128 128 255 128 128 192 255 170 85 85 255 128 128 0 255 192 192 192 255 255 255 128 255 128 192 128 255 7 146 94 255 0 128 255 255 255 128 192 255 0 255 255 255 255 128 128 255 0 128 192 255 128 128 192 255 255 0 255 255 128 64 64 255 255 128 64 255 80 240 120 255 0 64 128 255 128 0 64 255 255 0 128 255 128 128 64 255 128 128 128 255 255 128 255 255 0 64 0 255 0 0 0 255 255 255 255 255 255 128 0 true 0 255 255 255 1 255 0 0 0 false 0.0 2.0 0.0 3.0 false Orthogonal_Value , Outside false Text Sum Horizontal 1 true 0 255 255 255 1 255 0 0 0 0.0 2.0 0.0 3.0 true Below 1 255 196 196 196 false Across 1 255 196 196 196 true 1 255 225 225 225 false Across 1 255 225 225 225 false 5 Min 0.0 true false 255 46 52 54 255 242 88 106 255 232 172 57 255 128 255 128 255 64 128 128 255 128 128 192 255 170 85 85 255 128 128 0 255 192 192 192 255 255 255 128 255 128 192 128 255 7 146 94 255 0 128 255 255 255 128 192 255 0 255 255 255 255 128 128 255 0 128 192 255 128 128 192 255 255 0 255 255 128 64 64 255 255 128 64 255 80 240 120 255 0 64 128 255 128 0 64 255 255 0 128 255 128 128 64 255 128 128 128 255 255 128 255 255 0 64 0 255 0 0 0 255 255 255 255 255 255 128 0 true 0 255 255 255 1 255 0 0 0 false 0.0 2.0 0.0 3.0 false row["categoryKey"] Orthogonal_Value , Outside false true 1.0 Text Last Descending getKeyFiguresRowPosition(row["categoryKey"], row["category_index"]) Horizontal 1 0 255 255 255 false Arial 10.0 false 255 0 0 0 0 255 255 255 1 255 0 0 0 false 0.0 0.0 0.0 0.0 true 40 Below 1 255 196 196 196 false Across 1 255 196 196 196 false 1 255 225 225 225 false Across 1 255 225 225 225 false 5 false true 1 Min 0.0 true true false Auto 255 192 192 192 255 192 192 192 Horizontal 22.0 -20.0 45.0 0.0 None false ]]> SVG is-true row["category_index"] <= CommonKeys.REVENUE_INDEX || row["category_index"] == CommonKeys.OPENINGS_ANONYMOUS_INDEX || row["category_index"] == CommonKeys.CLICKS_ANONYMOUS_INDEX true true 0px 0px 760px 747px all reportContext.getPersistentGlobalVariable("showNet") == false 2.6.1 Bar Chart Side-by-side 0.0 0.0 0.0 0.0 3.0 3.0 3.0 3.0 -1 -1 -1 -1 1 255 0 0 0 false false Bar Chart Title 16.0 true Center Center 0 255 255 255 1 255 0 0 0 0.0 2.0 0.0 3.0 true 0.0 0.0 0.0 0.0 North Horizontal 0.0 0.0 0.0 30.0 -1 -1 -1 -1 1 255 0 0 0 false true 5 20 0 255 0 0 0 false 0.0 0.0 0.0 30.0 0.0 0.0 0.0 0.0 West Horizontal 3.0 3.0 5.0 3.0 -1 -1 -1 -1 1 255 0 0 0 false 0 255 255 255 true onclick Toggle_Visibility Pointer 0 255 0 0 0 false 2.0 2.0 2.0 100.0 Arial 10.0 Horizontal Left_Right 1 255 255 0 0 false Above Series Above false 0.0 0.33 0.6 40 0.0 0.0 501.0 270.0 0.0 0.0 0.0 0.0 -1 -1 -1 -1 1 255 0 0 0 false 0 255 255 255 true Two_Dimensional Points 10.0 0 enable.area.alt false 'A','B','C','D','E' 6,4,12,8,10 0 Series 1 true None No data available. Center Center 64 127 127 127 128 127 127 127 true 10.0 10.0 10.0 10.0 true Text Below Linear Left row["mailingName"] String 1.0 Text 255 46 52 54 255 136 138 133 255 146 208 79 255 255 192 0 255 0 153 153 255 65 100 26 255 0 113 185 true Arial 10.0 255 79 80 81 0 255 255 255 1 255 0 0 0 false 0.0 10.0 0.0 3.0 true row["value"] > 0 ? (row["category_index"] != CommonKeys.REVENUE_INDEX ? row["value"] : row["value"]/100) : 0.000001 Text Sum Series 1 Orthogonal_Value 0 Series_Value ; Outside false onmouseover Show_Tooltip row["tooltip"] 200 Auto Rectangle 0 255 255 255 false 1.0 Text Sum Descending getKeyFiguresColumnPositionByName(row["mailingName"]) 0 Vertical 1 0 255 255 255 true Arial 10.0 255 79 80 81 0 255 255 255 1 255 0 0 0 10.0 2.0 0.0 3.0 true Left 1 255 196 196 196 false Across 1 255 204 204 204 true 1 255 225 225 225 false Across 1 255 225 225 225 false 0.0 5 false true Min 0.0 true false false Text Below 255 80 166 218 255 242 88 106 255 232 172 57 255 128 255 128 255 64 128 128 255 128 128 192 255 170 85 85 255 128 128 0 255 192 192 192 255 255 255 128 255 128 192 128 255 7 146 94 255 0 128 255 255 255 128 192 255 0 255 255 255 255 128 128 255 0 128 192 255 128 128 192 255 255 0 255 255 128 64 64 255 255 128 64 255 80 240 120 255 0 64 128 255 128 0 64 255 255 0 128 255 128 128 64 255 128 128 128 255 255 128 255 255 0 64 0 255 0 0 0 255 255 255 255 255 255 128 0 true 0 255 255 255 1 255 0 0 0 false 0.0 2.0 0.0 3.0 false Orthogonal_Value , Outside false Text Sum Horizontal 1 true 0 255 255 255 1 255 0 0 0 0.0 2.0 0.0 3.0 true Below 1 255 196 196 196 false Across 1 255 196 196 196 true 1 255 225 225 225 false Across 1 255 225 225 225 false 5 Min 0.0 true false 255 80 166 218 255 242 88 106 255 232 172 57 255 128 255 128 255 64 128 128 255 128 128 192 255 170 85 85 255 128 128 0 255 192 192 192 255 255 255 128 255 128 192 128 255 7 146 94 255 0 128 255 255 255 128 192 255 0 255 255 255 255 128 128 255 0 128 192 255 128 128 192 255 255 0 255 255 128 64 64 255 255 128 64 255 80 240 120 255 0 64 128 255 128 0 64 255 255 0 128 255 128 128 64 255 128 128 128 255 255 128 255 255 0 64 0 255 0 0 0 255 255 255 255 255 255 128 0 255 255 255 255 true 0 255 255 255 1 255 0 0 0 false 0.0 2.0 0.0 3.0 false row["categoryKey"] Orthogonal_Value , Outside false true 1.0 Text Last Descending getKeyFiguresRowPosition(row["categoryKey"], row["category_index"]) Horizontal 1 0 255 255 255 false Arial 10.0 false 255 0 0 0 0 255 255 255 1 255 0 0 0 false 0.0 0.0 0.0 0.0 true 40 Below false 1 1 255 196 196 196 false Across 1 255 196 196 196 false 1 255 225 225 225 false Across 1 255 225 225 225 false 5 false true 1 Min true true false 255 192 192 192 255 192 192 192 Horizontal 22.0 -20.0 45.0 0.0 None false ]]> SVG is-true row["category_index"] <= CommonKeys.REVENUE_INDEX || row["category_index"] == CommonKeys.OPENINGS_ANONYMOUS_INDEX || row["category_index"] == CommonKeys.CLICKS_ANONYMOUS_INDEX true true 0px 0px 760px 747px all reportContext.getPersistentGlobalVariable("showGross") == false 2 1 full-width SummaryOptimizationDataCube value categoryGroup/category_index optimizationGroup/optimizationGroupId all data["value_categoryGroup/category_index_optimizationGroup/optimizationGroupId"] >= 0 && data["value_categoryGroup/category_index_optimizationGroup/optimizationGroupId"] != null tr("NotAvailableShort") Currency #,##0.00{RoundingMode=HALF_UP} all data["value_categoryGroup/category_index_optimizationGroup/optimizationGroupId"] < 0 || data["value_categoryGroup/category_index_optimizationGroup/optimizationGroupId"] == null || data["category_index"] != CommonKeys.REVENUE_INDEX revenue Currency #,##0{RoundingMode=HALF_UP} all data["value_categoryGroup/category_index_optimizationGroup/optimizationGroupId"] < 0 || data["value_categoryGroup/category_index_optimizationGroup/optimizationGroupId"] == null || data["category_index"] == CommonKeys.REVENUE_INDEX value_categoryGroup/category_index_optimizationGroup/optimizationGroupId crosstab-value to-hide rate categoryGroup/category_index optimizationGroup/optimizationGroupId all data["value_categoryGroup/category_index_optimizationGroup/optimizationGroupId"] >= 0 && data["value_categoryGroup/category_index_optimizationGroup/optimizationGroupId"] != null tr("NotAvailableShort") Custom (0.0%) all data["value_categoryGroup/category_index_optimizationGroup/optimizationGroupId"] < 0 || data["value_categoryGroup/category_index_optimizationGroup/optimizationGroupId"] == null rate_categoryGroup/category_index_optimizationGroup/optimizationGroupId crosstab-value to-hide categoryGroup categoryGroup/category_index getKeyFiguresRowPosition(dimension["categoryGroup"]["category_index"]["categoryKey"], dimension["categoryGroup"]["category_index"]) asc category left optimizationGroup optimizationGroup/optimizationGroupId getCrossTableColumnPosition(dimension["optimizationGroup"]["optimizationGroupId"]) asc -1 left inline groupTitle inline 16px 16px all !isWinnerMailing(data["optimizationGroupId"]) embed ok_icon.png center middle table-head crosstab-header tr("KeydataGeneral") html table-head data["category_index"] <= CommonKeys.REVENUE_INDEX || data["category_index"] == CommonKeys.OPENINGS_ANONYMOUS_INDEX || data["category_index"] == CommonKeys.CLICKS_ANONYMOUS_INDEX is-true all reportContext.getPersistentGlobalVariable("showGross") == false category_index dimension["categoryGroup"]["category_index"] integer optimizationGroup dimension["optimizationGroup"]["optimizationGroupId"] integer value_categoryGroup/category_index measure["value"] integer categoryGroup/category_index SUM rate_categoryGroup/category_index measure["rate"] float categoryGroup/category_index SUM category dimension["categoryGroup"]["category_index"]["category"] string optimizationGroupId dimension["optimizationGroup"]["optimizationGroupId"] integer groupTitle getMailingGroupNameTitle(data["optimizationGroupId"], dimension["optimizationGroup"]["optimizationGroupId"]["baseGroupId"]) string value_categoryGroup/category_index_optimizationGroup/optimizationGroupId float categoryGroup/category_index optimizationGroup/optimizationGroupId SUM Expression measure["value"] rate_categoryGroup/category_index_optimizationGroup/optimizationGroupId float categoryGroup/category_index optimizationGroup/optimizationGroupId SUM Expression measure["rate"] dimension["categoryGroup"]["category_index"] < CommonKeys.REVENUE_INDEX && hasPercentageRepresentation(dimension["categoryGroup"]["category_index"]["categoryKey"]) categoryKey dimension["categoryGroup"]["category_index"]["categoryKey"] string value measure["value"] integer revenue data["value_categoryGroup/category_index_optimizationGroup/optimizationGroupId"]/100 integer table table-striped SummaryOptimizationDataCube value categoryGroup/category_index optimizationGroup/optimizationGroupId all data["value_categoryGroup/category_index_optimizationGroup/optimizationGroupId"] >= 0 && data["value_categoryGroup/category_index_optimizationGroup/optimizationGroupId"] != null tr("NotAvailableShort") Currency #,##0.00{RoundingMode=HALF_UP} all data["value_categoryGroup/category_index_optimizationGroup/optimizationGroupId"] < 0 || data["value_categoryGroup/category_index_optimizationGroup/optimizationGroupId"] == null || data["category_index"] != CommonKeys.REVENUE_INDEX revenue Currency #,##0{RoundingMode=HALF_UP} all data["value_categoryGroup/category_index_optimizationGroup/optimizationGroupId"] < 0 || data["value_categoryGroup/category_index_optimizationGroup/optimizationGroupId"] == null || data["category_index"] == CommonKeys.REVENUE_INDEX value_categoryGroup/category_index_optimizationGroup/optimizationGroupId crosstab-value to-hide rate categoryGroup/category_index optimizationGroup/optimizationGroupId all data["value_categoryGroup/category_index_optimizationGroup/optimizationGroupId"] >= 0 && data["value_categoryGroup/category_index_optimizationGroup/optimizationGroupId"] != null tr("NotAvailableShort") Custom (0.0%) all data["value_categoryGroup/category_index_optimizationGroup/optimizationGroupId"] < 0 || data["value_categoryGroup/category_index_optimizationGroup/optimizationGroupId"] == null delivered_Binding crosstab-value to-hide categoryGroup categoryGroup/category_index getKeyFiguresRowPosition(dimension["categoryGroup"]["category_index"]["categoryKey"], dimension["categoryGroup"]["category_index"]) asc category left optimizationGroup optimizationGroup/optimizationGroupId getCrossTableColumnPosition(dimension["optimizationGroup"]["optimizationGroupId"]) asc -1 inline groupTitle inline 16px 16px all !isWinnerMailing(data["optimizationGroupId"]) embed ok_icon.png table-head crosstab-header tr("KeydataGeneral") html table-head data["category_index"] <= CommonKeys.REVENUE_INDEX || data["category_index"] == CommonKeys.OPENINGS_ANONYMOUS_INDEX || data["category_index"] == CommonKeys.CLICKS_ANONYMOUS_INDEX is-true all reportContext.getPersistentGlobalVariable("showNet") == false category_index dimension["categoryGroup"]["category_index"] integer optimizationGroup dimension["optimizationGroup"]["optimizationGroupId"] integer value_categoryGroup/category_index measure["value"] integer categoryGroup/category_index SUM rate_categoryGroup/category_index measure["rate"] float categoryGroup/category_index SUM category dimension["categoryGroup"]["category_index"]["category"] string optimizationGroupId dimension["optimizationGroup"]["optimizationGroupId"] integer groupTitle getMailingGroupNameTitle(data["optimizationGroupId"], dimension["optimizationGroup"]["optimizationGroupId"]["baseGroupId"]) string value_categoryGroup/category_index_optimizationGroup/optimizationGroupId float categoryGroup/category_index optimizationGroup/optimizationGroupId SUM Expression measure["value"] rate_categoryGroup/category_index_optimizationGroup/optimizationGroupId float categoryGroup/category_index optimizationGroup/optimizationGroupId SUM Expression measure["rate"] dimension["CategoryGroup"]["category_index"] < CommonKeys.REVENUE_INDEX && hasPercentageRepresentation(dimension["CategoryGroup"]["category_index"]["categoryKey"]) categoryKey dimension["categoryGroup"]["category_index"]["categoryKey"] string value measure["value"] integer revenue data["value_categoryGroup/category_index_optimizationGroup/optimizationGroupId"]/100 integer deliveredRate data["rate_categoryGroup/category_index_optimizationGroup/optimizationGroupId"] float delivered_Binding float categoryGroup/category_index optimizationGroup/optimizationGroupId SUM Expression measure["deliveredRate"] dimension["categoryGroup"]["category_index"] < CommonKeys.REVENUE_INDEX && hasPercentageRepresentation(dimension["categoryGroup"]["category_index"]["categoryKey"]) table table-striped 2 1 full-width half-width table report-title tr("report.mailing.openersByDevices") + " - " + getMailingGroupName(CommonKeys.OPTIMIZATION_WINNER_GROUP_ID) center 2.6.1 Pie Chart Standard 0.0 0.0 0.0 0.0 South 0.0 0.0 0.0 0.0 -1 -1 -1 -1 1 255 0 0 0 false false report.opens=Pie Chart Title 16.0 true Center Top 0 255 255 255 1 255 0 0 0 0.0 0.0 0.0 0.0 true 0.0 0.0 0.0 0.0 3.0 3.0 3.0 3.0 -1 -1 -1 -1 1 255 0 0 0 false true 5 5 0 255 0 0 0 false 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 3.0 3.0 3.0 3.0 -1 -1 -1 -1 1 255 0 0 0 false false 0 255 0 0 0 false 2.0 2.0 2.0 2.0 Vertical Top_Bottom 1 255 0 0 0 true Right Categories Above 0.0 0.0 315.0 150.0 3.0 3.0 3.0 3.0 -1 -1 -1 -1 1 255 0 0 0 false 0 255 255 255 true Two_Dimensional Points 20.0 0 enable.area.alt false 'A','B','C','D','E' 6,4,12,8,10 0 true None No data available. Center Center 64 127 127 127 128 127 127 127 true 10.0 10.0 10.0 10.0 true 255 255 204 153 255 255 255 153 255 255 204 0 255 204 255 204 255 154 204 0 Numeric 255 255 204 153 255 255 255 153 255 255 204 0 255 204 255 204 255 154 204 0 true Arial 10.0 false 0.0 0 255 255 255 1 255 0 0 0 false 5.0 5.0 5.0 5.0 true row["rate"] false Text Series 1 Orthogonal_Value ##.#% Base_Value Outside false onmouseover Highlight Auto 0 Below 1 255 128 128 128 true Fixed_Length 0.0 0 255 255 255 1.0 0.0 false 60.0 true 0 255 255 255 1 255 0 0 0 false 0.0 2.0 0.0 3.0 false row["category_index"] Orthogonal_Value , Outside false false Numeric Sum Ascending row["category_index"] false 0.65 ]]> SVG is-true row["category_index"] == CommonKeys.OPENERS_PC_INDEX || row["category_index"] == CommonKeys.OPENERS_TABLET_INDEX || row["category_index"] == CommonKeys.OPENERS_MOBILE_INDEX || row["category_index"] == CommonKeys.OPENERS_SMARTTV_INDEX || row["category_index"] == CommonKeys.OPENERS_PC_AND_MOBILE_INDEX true eq row["groupId"] CommonKeys.OPTIMIZATION_WINNER_GROUP_ID true false 320px 668px OptimizationSummaryDataSet category category dataSetRow["category"] string category_index category_index dataSetRow["category_index"] integer value value dataSetRow["value"] integer rate rate dataSetRow["rate"] float deliveredRate deliveredRate dataSetRow["deliveredRate"] float mailingId mailingId dataSetRow["mailingId"] integer groupId groupId dataSetRow["groupId"] integer categoryKey categoryKey dataSetRow["categoryKey"] string isWinner isWinner dataSetRow["isWinner"] boolean baseGroupId baseGroupId dataSetRow["baseGroupId"] integer half-width table report-title tr("report.mailing.clickersByDevices") + " - " + getMailingGroupName(CommonKeys.OPTIMIZATION_WINNER_GROUP_ID) center 2.6.1 Pie Chart Standard 0.0 0.0 0.0 0.0 South 0.0 0.0 0.0 0.0 -1 -1 -1 -1 1 255 0 0 0 false false report.clicker=Pie Chart Title 16.0 true Center Top 0 255 255 255 1 255 0 0 0 0.0 0.0 0.0 0.0 true 0.0 0.0 0.0 0.0 3.0 3.0 3.0 3.0 -1 -1 -1 -1 1 255 0 0 0 false true 5 5 0 255 0 0 0 false 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 3.0 3.0 3.0 3.0 -1 -1 -1 -1 1 255 0 0 0 false false 0 255 0 0 0 false 2.0 2.0 2.0 2.0 Vertical Top_Bottom 1 255 0 0 0 true Right Categories Above 0.0 0.0 315.0 150.0 3.0 3.0 3.0 3.0 -1 -1 -1 -1 1 255 0 0 0 false 0 255 255 255 true Two_Dimensional Points 20.0 0 enable.area.alt false 'A','B','C','D','E' 6,4,12,8,10 0 true None This chart contains no data. Center Center 64 127 127 127 128 127 127 127 true 10.0 10.0 10.0 10.0 false 255 254 204 153 255 254 254 153 255 232 172 57 255 128 255 128 255 154 204 0 255 128 128 192 255 170 85 85 255 128 128 0 255 192 192 192 255 255 255 128 255 128 192 128 255 7 146 94 255 0 128 255 255 255 128 192 255 0 255 255 255 255 128 128 255 0 128 192 255 128 128 192 255 255 0 255 255 128 64 64 255 255 128 64 255 80 240 120 255 0 64 128 255 128 0 64 255 255 0 128 255 128 128 64 255 128 128 128 255 255 128 255 255 0 64 0 255 0 0 0 255 255 255 255 255 255 128 0 255 255 255 255 Numeric 255 254 204 153 255 254 254 153 255 232 172 57 255 128 255 128 255 154 204 0 255 128 128 192 255 170 85 85 255 128 128 0 255 192 192 192 255 255 255 128 255 128 192 128 255 7 146 94 255 0 128 255 255 255 128 192 255 0 255 255 255 255 128 128 255 0 128 192 255 128 128 192 255 255 0 255 255 128 64 64 255 255 128 64 255 80 240 120 255 0 64 128 255 128 0 64 255 255 0 128 255 128 128 64 255 128 128 128 255 255 128 255 255 0 64 0 255 0 0 0 255 255 255 255 255 255 128 0 255 255 255 255 true Arial 10.0 false 0.0 0 255 255 255 1 255 0 0 0 false 5.0 5.0 5.0 5.0 true row["rate"] Text Sum Series 1 Orthogonal_Value ##.#% Base_Value Outside false onmouseover Highlight Auto 0 Below 1 255 128 128 128 true Fixed_Length 0.0 0 255 255 255 1.0 0.0 60.0 true 0 255 255 255 1 255 0 0 0 false 0.0 2.0 0.0 3.0 false row["category_index"] Orthogonal_Value , Outside false false Numeric Sum Ascending row["category_index"] false 0.65 ]]> SVG is-true row["category_index"] == CommonKeys.CLICKER_PC_INDEX || row["category_index"] == CommonKeys.CLICKER_TABLET_INDEX || row["category_index"] == CommonKeys.CLICKER_MOBILE_INDEX || row["category_index"] == CommonKeys.CLICKER_SMARTTV_INDEX || row["category_index"] == CommonKeys.CLICKER_PC_AND_MOBILE_INDEX true eq row["groupId"] CommonKeys.OPTIMIZATION_WINNER_GROUP_ID true false block 320px 668px OptimizationSummaryDataSet category category dataSetRow["category"] string category_index category_index dataSetRow["category_index"] integer value value dataSetRow["value"] integer rate rate dataSetRow["rate"] float deliveredRate deliveredRate dataSetRow["deliveredRate"] float mailingId mailingId dataSetRow["mailingId"] integer groupId groupId dataSetRow["groupId"] integer categoryKey categoryKey dataSetRow["categoryKey"] string isWinner isWinner dataSetRow["isWinner"] boolean baseGroupId baseGroupId dataSetRow["baseGroupId"] integer 2 1 full-width SummaryOptimizationDataCube value categoryGroup/category_index optimizationGroup/optimizationGroupId Currency #,##0{RoundingMode=HALF_UP} all data["value"] < 0 || data["value"] == null value all data["value"] >= 0 && data["value"] != null tr("NotAvailableShort") crosstab-value to-hide rate categoryGroup/category_index optimizationGroup/optimizationGroupId Custom (0.0%) all data["rate"] < 0 || data["rate"] == null rate all data["rate"] >= 0 && data["rate"] != null tr("NotAvailableShort") crosstab-value to-hide categoryGroup categoryGroup/category_index data["category_index"] in CommonKeys.OPENERS_TRACKED_INDEX CommonKeys.OPENERS_PC_INDEX CommonKeys.OPENERS_TABLET_INDEX CommonKeys.OPENERS_MOBILE_INDEX CommonKeys.OPENERS_SMARTTV_INDEX CommonKeys.OPENERS_PC_AND_MOBILE_INDEX CommonKeys.CLICKER_TRACKED_INDEX CommonKeys.CLICKER_PC_INDEX CommonKeys.CLICKER_TABLET_INDEX CommonKeys.CLICKER_MOBILE_INDEX CommonKeys.CLICKER_SMARTTV_INDEX CommonKeys.CLICKER_PC_AND_MOBILE_INDEX true dimension["categoryGroup"]["category_index"] asc -1 category left optimizationGroup optimizationGroup/optimizationGroupId getCrossTableColumnPosition(dimension["optimizationGroup"]["optimizationGroupId"]) asc -1 inline groupTitle inline 16px 16px all !isWinnerMailing(data["optimizationGroupId"]) embed ok_icon.png table-head crosstab-header tr("KeydataPCMobile") html table-head category_index dimension["categoryGroup"]["category_index"] integer optimizationGroup dimension["optimizationGroup"]["optimizationGroupId"] integer category dimension["categoryGroup"]["category_index"]["category"] string optimizationGroupId dimension["optimizationGroup"]["optimizationGroupId"] integer groupTitle getMailingGroupNameTitle(data["optimizationGroupId"], dimension["optimizationGroup"]["optimizationGroupId"]["baseGroupId"]) string value float categoryGroup/category_index optimizationGroup/optimizationGroupId SUM Expression measure["value"] value_groupOptimization float categoryGroup/category_index optimizationGroup/optimizationGroupId SUM Expression measure["value"] rate_optimizationGroup float categoryGroup/category_index optimizationGroup/optimizationGroupId SUM Expression measure["rate"] rate if (data["category_index"] == CommonKeys.OPENERS_TRACKED_INDEX || data["category_index"] == CommonKeys.CLICKER_TRACKED_INDEX) { //data["value_CategoryGroup/category_TargetgroupGroup/targetgroup"] / data["total_sent"] if (data["value_groupOptimization"] > 0) {1} else {0} } else { data["rate_optimizationGroup"] } float table table-striped 2 1 full-width SummaryOptimizationDataCube value categoryGroup/category_index optimizationGroup/optimizationGroupId Currency #,##0{RoundingMode=HALF_UP} formattedValue crosstab-value to-hide categoryGroup categoryGroup/category_index (dimension["categoryGroup"]["category_index"] >= CommonKeys.OPENINGS_GROSS_MEASURED_INDEX || dimension["categoryGroup"]["category_index"] >= CommonKeys.CLICKS_GROSS_INDEX) && dimension["categoryGroup"]["category_index"] <= CommonKeys.ACTIVITY_RATE_INDEX is-true true dimension["categoryGroup"]["category_index"] asc -1 category left optimizationGroup optimizationGroup/optimizationGroupId getCrossTableColumnPosition(dimension["optimizationGroup"]["optimizationGroupId"]) asc -1 inline groupTitle inline 16px 16px all !isWinnerMailing(data["optimizationGroupId"]) embed ok_icon.png table-head crosstab-header tr("statistic.Response") html table-head category_index dimension["categoryGroup"]["category_index"] integer optimizationGroup dimension["optimizationGroup"]["optimizationGroupId"] integer category dimension["categoryGroup"]["category_index"]["category"] string optimizationGroupId dimension["optimizationGroup"]["optimizationGroupId"] integer groupTitle getMailingGroupNameTitle(data["optimizationGroupId"], dimension["optimizationGroup"]["optimizationGroupId"]["baseGroupId"]) string cubeValue integer categoryGroup/category_index optimizationGroup/optimizationGroupId SUM Expression measure["value"] cubeRate float categoryGroup/category_index optimizationGroup/optimizationGroupId SUM Expression measure["rate"] formattedValue if(data["category_index"] == CommonKeys.OPENINGS_GROSS_MEASURED_INDEX || data["category_index"] == CommonKeys.CLICKS_GROSS_INDEX) { "" + Formatter.format(data["cubeValue"], "#,##0") } else if(data["category_index"] == CommonKeys.ACTIVITY_RATE_INDEX) { "" + Formatter.format(data["cubeRate"], "0.0%") } else {""} string table table-striped 2 1 full-width footnote 0pt tr("report.mailsize.explanation") footnote 0pt tr("report.opens.measured.explanation") footnote tr("report.opens.invisible.explanation") footnote tr("report.opens.pc.and.mobile.explanation") footnote tr("statistic.MeasuredOpeningsGross.explanation") footnote 0pt tr("statistic.ActivityRate.explanation") footnote 0pt tr("statistic.withoutConfirmation.explanation") footnote 0pt all reportContext.getPersistentGlobalVariable("trackingExists") == true tr("noTrackingData") "Arial" all reportContext.getOutputFormat() != "csv" OptimizationSummaryDataSet category category dataSetRow["category"] string category_index category_index dataSetRow["category_index"] integer targetgroup targetgroup dataSetRow["targetgroup"] string targetgroupId targetgroupId dataSetRow["targetgroupId"] integer value value dataSetRow["value"] integer rate rate dataSetRow["rate"] float deliveredRate deliveredRate dataSetRow["deliveredRate"] float mailingId mailingId dataSetRow["mailingId"] integer mailingName mailingName dataSetRow["mailingName"] string groupId groupId dataSetRow["groupId"] integer categoryKey categoryKey dataSetRow["categoryKey"] string baseMailingName baseMailingName dataSetRow["baseMailingName"] string isWinner isWinner dataSetRow["isWinner"] boolean baseGroupId baseGroupId dataSetRow["baseGroupId"] integer groupId_agr integer OptGroup FIRST Expression row["groupId"] true value_agr float OptGroup MAX Expression if (row["value"] < 0) {0}else {row["value"]} true rate_agr float OptGroup MAX Expression if (row["rate"] < 0) {0}else {row["rate"]} true delivered_rate_agr float OptGroup MAX Expression if (row["deliveredRate"] < 0) {0}else {row["deliveredRate"]} true optGroupName getMailingGroupNameTitle(row["groupId_agr"], row["baseGroupId"]) string true categoryHeader tr("grid.mediapool.category") string true mailingHeader tr("Mailings") string true targetsHeader tr("birt.Target") string true valueHeader tr("value") string true rateHeader tr("Brutto") string true deliveredHeader tr("Netto") string true 0.6875in 1

categoryHeader mailingHeader targetsHeader valueHeader rateHeader deliveredHeader

CategoryGroup row["category_index"] row["category"] false getKeyFiguresRowPosition(row["categoryKey"], row["category_index"]) asc -1 OptGroup row["groupId"] row["groupId"] true getCrossTableColumnPosition(row["groupId"]) asc -1

category optGroupName targetgroup all row["value_agr"] < 0 value_agr all row["value_agr"] >= 0 tr("NotAvailableShort") html Custom (0.0%) all row["value_agr"] < 0 rate_agr all row["delivered_rate_agr"] >= 0 tr("NotAvailableShort") html Custom 0.00% all row["delivered_rate_agr"] < 0 delivered_rate_agr

ok_icon.png image/png iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAAAXNSR0IArs4c6QAAAAZiS0dEAP8A/wD/ oL2nkwAAAAlwSFlzAAALEwAACxMBAJqcGAAAAZBJREFUOMutk7FLAlEcxz+mbZZ0YOGNQtThIujiKU1x JI0GB44R/QNCBM2BCA2tIY6Cg63G0ajeJLiIhdCoUHB46ZZ2LXdypTaUv+XBe7/v5/d7v/d9Hsuy+E/4 fm4k6lkvoACnwAkwBB6BEqDpqfLUne9xd5CoZ/eApuQPC5mQwvHOAcOPdxpGm+pAozt+MQBZT5Wf5wCJ enbPy9rT5e4ZsUCESr9Gpf/A1vomSlBGFdO0zA75XpEpn/sOxGNZltP269XuuRDwbXDRvVl434KUw5yM uO7dGcC2nipP1+wzRfKHhVggslQMcNG9IRaIIPnDgj0nHMBpJqRQ6deWivVUGYBKv0YmpGAPeQY4TApR tLfmr2IA7a1JUogCHLoBcwJH5KyJenYh3AE8Now2SlD+lrxIrARlGkYb2xszQKk60FDFtNsTCyurYprq QMM21gygdccvRsvsUJBycxD3M7bMjmMobQaw7Snne0XMyYj7+C2qeATA1vomqnjEffwWczIi3ytiu3G6 Wiuv5DP9Jb4A3I7DAQFff4QAAAAASUVORK5CYII=