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 135 80 135 80 WEB-INF/classes/messages in /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 false integer true 68301 simple text-box Unformatted static string true DE simple text-box Unformatted static false string true 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 true string true ALL_SUBSCRIBERS simple text-box > > static boolean true simple check-box static false integer true 0 simple text-box Unformatted static false boolean true false simple check-box static boolean true simple check-box static false string true simple text-box Unformatted static false string true simple text-box Unformatted static false boolean true False 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 static false integer true 180 simple text-box Unformatted static false integer true 1100 simple text-box Unformatted 0 shortname string shortname 1 shortname string DummyDataSource 1 name string name 1 name string DummyDataSource 1 mailingName string 2 subject string 3 numMails integer 4 startSending string 5 stopSending string 6 mailformat string 7 averageMailsize integer 8 anonymousUsers integer 9 isMailTrackingAvailable boolean mailingName subject numMails startSending stopSending mailformat averageMailsize anonymousUsers isMailTrackingAvailable 1 mailingName string 2 subject string 3 numMails integer 4 startSending string 5 stopSending string 6 mailformat string 7 averageMailsize integer 8 anonymousUsers integer 9 isMailTrackingAvailable boolean DummyDataSource 1 category string 2 category_index integer 3 targetgroup string 4 targetgroup_index integer 5 value integer 6 rate float 7 value_string string 8 deliveredRate float 9 categoryKey string category category_index targetgroup targetgroup_index value rate value_string deliveredRate categoryKey 1 category string 2 category_index integer 3 targetgroup string 4 targetgroup_index integer 5 value integer 6 rate float 7 value_string string 8 deliveredRate float 9 categoryKey string DummyDataSource max) { max = value; } } reportContext.setGlobalVariable("maxValue", parseInt(max)); reportContext.setGlobalVariable("total_sent", parseInt(0)); reportContext.setGlobalVariable("total_delivered", parseInt(0));]]> = mailingSummaryData.size() ) { return false; } currentRowData = mailingSummaryData.get(currentrow); row["categoryKey"] = currentRowData.getCategory(); switch (currentRowData.getCategoryindex()) { case CommonKeys.CLICKER_PC_AND_MOBILE_INDEX: row["category"] = getTranslation("statistic.clicker.multiple"); break; case CommonKeys.OPENERS_PC_AND_MOBILE_INDEX: row["category"] = getTranslation("report.opens.pc.and.mobileWithNote"); break; case CommonKeys.OPENERS_INVISIBLE_INDEX: row["category"] = getTranslation("report.opens.invisible"); break; case CommonKeys.OPENERS_MEASURED_INDEX: row["category"] = getTranslation("report.opens.measured"); break; default: row["category"] = getTranslation(currentRowData.getCategory()); break; } row["category_index"] = currentRowData.getCategoryindex(); // do some i18n stuff if( currentRowData.getTargetgroupindex() == 1) { row["targetgroup"] = getTranslation("statistic.all_subscribers"); if (currentRowData.getCategoryindex() == CommonKeys.DELIVERED_EMAILS_INDEX) { total_sent = parseInt(reportContext.getGlobalVariable("total_sent")); reportContext.setGlobalVariable("total_sent", total_sent + parseInt(currentRowData.getCount())); } if (currentRowData.getCategoryindex() == CommonKeys.DELIVERED_EMAILS_DELIVERED_INDEX) { total_delivered = parseInt(reportContext.getGlobalVariable("total_delivered")); reportContext.setGlobalVariable("total_delivered", total_delivered + parseInt(currentRowData.getCount())); } } else { row["targetgroup"] = currentRowData.getTargetgroup(); } row["targetgroup_index"] = currentRowData.getTargetgroupindex(); row["value"] = currentRowData.getCount(); row["rate"] = currentRowData.getRate(); if (row["rate"] == -1) { row["rate"] = 0; } row["deliveredRate"] = currentRowData.getDeliveredRate(); if (row["deliveredRate"] == -1) { row["deliveredRate"] = 0; } currentrow++; return true;]]> 0 TARGET string TARGET 1 TARGET string DummyDataSource 1 autoOptimizationName string 2 testGroup1 string 3 testGroup2 string 4 testGroup3 string 5 testGroup4 string 6 testGroup5 string 7 resultMailing string autoOptimizationName testGroup1 testGroup2 testGroup3 testGroup4 testGroup5 resultMailing 1 autoOptimizationName string 2 testGroup1 string 3 testGroup2 string 4 testGroup3 string 5 testGroup4 string 6 testGroup5 string 7 resultMailing string DummyDataSource NewTabularHierarchy string dynamic category_index integer category string categoryKey string category_index NewTabularHierarchy1 string dynamic targetgroup_index integer targetgroup dataSetRow["value"] integer sum false dataSetRow["rate"] float true first false dataSetRow["value_string"] string true sum false dataSetRow["deliveredRate"] float true MailingSummaryDataSet a4 landscape 0.25in 0.25in 0.25in 0.25in parameterstext 3.1354166666666665in 5.145833333333333in 2.1666666666666665in 2.9791666666666665in parametersheadline bold #000000 Packages.com.agnitas.messages.I18nString.getLocaleString("report.parameters", reportContext.getLocale()) Packages.com.agnitas.messages.I18nString.getLocaleString("settings.Company", reportContext.getLocale()) CompanyDescriptionDataSet name name dataSetRow["name"] string name Packages.com.agnitas.messages.I18nString.getLocaleString("settings.fieldType.DATE", reportContext.getLocale()) new Date() html block-table serif 100% MailingDataSet mailingName dataSetRow["mailingName"] string subject dataSetRow["subject"] string startSending dataSetRow["startSending"] string stopSending dataSetRow["stopSending"] string mailformat dataSetRow["mailformat"] string averageMailsize dataSetRow["averageMailsize"] integer numMails dataSetRow["numMails"] string Column Binding dataSetRow["averageMailsize"] integer Column Binding_1 dataSetRow["numMails"] dataSetRow["numMails"] integer anonymousUsers dataSetRow["anonymousUsers"] integer true isMailTrackingAvailable dataSetRow["isMailTrackingAvailable"] boolean true all true 2 1 parametersheadline bold left all reportContext.getPersistentGlobalVariable("isAutoOptimization") == true Packages.com.agnitas.messages.I18nString.getLocaleString("report.selectedMailing", reportContext.getLocale()) +": " + row["mailingName"] html half-width 0pt 0px 0pt 0px center table table-striped all reportContext.getPersistentGlobalVariable("isAutoOptimization") == true 35% 65% table-head Packages.com.agnitas.messages.I18nString.getLocaleString("General2", reportContext.getLocale()) 0pt 0pt 0pt 0pt Packages.com.agnitas.messages.I18nString.getLocaleString("mailing.Subject", reportContext.getLocale()) 0pt 0pt 0pt 0pt row["subject"] html Packages.com.agnitas.messages.I18nString.getLocaleString("birt.Target", reportContext.getLocale()) #D3D3D3 solid medium TargetsDataSet TARGET dataSetRow["TARGET"] string TARGET (row["isMailTrackingAvailable"] && successStatisticExpired != true ? getTranslation("report.numberRecipients.notracking") : getTranslation("report.numberRecipients")) #D3D3D3 solid medium row["numMails"] + (row["isMailTrackingAvailable"] && successStatisticExpired != true ? " (" + row["anonymousUsers"] + ")" : '') html Packages.com.agnitas.messages.I18nString.getLocaleString("report.startSending", reportContext.getLocale()) #D3D3D3 solid medium row["startSending"] html Packages.com.agnitas.messages.I18nString.getLocaleString("report.stopSending", reportContext.getLocale()) #D3D3D3 solid medium row["stopSending"] html Packages.com.agnitas.messages.I18nString.getLocaleString("report.mailformat", reportContext.getLocale()) #D3D3D3 solid medium top row["mailformat"] html Packages.com.agnitas.messages.I18nString.getLocaleString("report.mailsize", reportContext.getLocale()) Currency #,##0 Column Binding table 100% AutoOptimizationDataSet all reportContext.getPersistentGlobalVariable("isAutoOptimization") == false autoOptimizationName dataSetRow["autoOptimizationName"] string testGroup1 dataSetRow["testGroup1"] string testGroup2 dataSetRow["testGroup2"] string testGroup3 dataSetRow["testGroup3"] string testGroup4 dataSetRow["testGroup4"] string testGroup5 dataSetRow["testGroup5"] string resultMailing dataSetRow["resultMailing"] string textBlue normal 120px 200px 10px odd #D3D3D3 solid 1px #D3D3D3 solid 1px #D3D3D3 solid 1px #D3D3D3 solid 1px all row["autoOptimizationName"] == null bold Packages.com.agnitas.messages.I18nString.getLocaleString("mailing.autooptimization", reportContext.getLocale()) #D3D3D3 solid 1px ReportText normal row["autoOptimizationName"] html #D3D3D3 solid 1px #D3D3D3 solid 1px #D3D3D3 solid 1px #D3D3D3 solid 1px all row["testGroup1"] == null Packages.com.agnitas.messages.I18nString.getLocaleString("testGroup1", reportContext.getLocale()) #D3D3D3 solid 1px ReportText row["testGroup1"] html odd #D3D3D3 solid 1px #D3D3D3 solid 1px #D3D3D3 solid 1px #D3D3D3 solid 1px all row["testGroup2"] == null Packages.com.agnitas.messages.I18nString.getLocaleString("testGroup2", reportContext.getLocale()) #D3D3D3 solid 1px ReportText row["testGroup2"] html #D3D3D3 solid 1px #D3D3D3 solid 1px #D3D3D3 solid 1px #D3D3D3 solid 1px all row["testGroup3"] == null Packages.com.agnitas.messages.I18nString.getLocaleString("testGroup3", reportContext.getLocale()) #D3D3D3 solid 1px ReportText row["testGroup3"] html odd #D3D3D3 solid 1px #D3D3D3 solid 1px #D3D3D3 solid 1px #D3D3D3 solid 1px all row["testGroup4"] == null Packages.com.agnitas.messages.I18nString.getLocaleString("testGroup4", reportContext.getLocale()) #D3D3D3 solid 1px ReportText row["testGroup4"] html #D3D3D3 solid 1px #D3D3D3 solid 1px #D3D3D3 solid 1px #D3D3D3 solid 1px all row["testGroup5"] == null Packages.com.agnitas.messages.I18nString.getLocaleString("testGroup5", reportContext.getLocale()) #D3D3D3 solid 1px ReportText row["testGroup5"] html #D3D3D3 solid 1px #D3D3D3 solid 1px #D3D3D3 solid 1px #D3D3D3 solid 1px all row["resultMailing"] == null Packages.com.agnitas.messages.I18nString.getLocaleString("resultMailing", reportContext.getLocale()) #D3D3D3 solid 1px ReportText row["resultMailing"] html half-width table MailingSummaryDataSet category category dataSetRow["category"] string category_index category_index dataSetRow["category_index"] integer targetgroup targetgroup dataSetRow["targetgroup"] string targetgroup_index targetgroup_index dataSetRow["targetgroup_index"] integer value value dataSetRow["value"] integer rate rate dataSetRow["rate"] float value_string value_string dataSetRow["value_string"] string category_key category_key dataSetRow["categoryKey"] string true 0pt 0pt 0pt 0pt center 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 0 20 0 255 0 0 0 false 0.0 0.0 0.0 30.0 0.0 0.0 0.0 0.0 South Horizontal 3.0 3.0 3.0 3.0 -1 -1 -1 -1 1 255 0 0 0 false 0 255 255 255 false 0 255 0 0 0 false 2.0 2.0 2.0 2.0 SansSerif 10.0 Horizontal Top_Bottom 1 255 0 0 0 false Below Categories Above 0.1 0.1 4 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 false 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 Numeric 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 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 Series1 Orthogonal_Value 0 Outside false Rectangle false 1.0 Text Sum Vertical 1 255 139 139 139 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["category_key"] Orthogonal_Value , Outside false false 1.0 Text Sum Descending getKeyFiguresRowPosition(row["category_key"], row["category_index"]) Horizontal 1 255 0 0 0 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 Min 0.0 true true false 255 192 192 192 255 192 192 192 Horizontal 60.0 -20.0 45.0 0.0 None false ]]> SVG eq row["targetgroup_index"] 1 true 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 360px 668px all reportContext.getPersistentGlobalVariable("showGross") == 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 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.0 0.0 0.0 30.0 0.0 0.0 0.0 0.0 South Horizontal 3.0 3.0 3.0 3.0 -1 -1 -1 -1 1 255 0 0 0 false 0 255 255 255 false 0 255 0 0 0 false 2.0 2.0 2.0 2.0 SansSerif 10.0 Horizontal Top_Bottom 1 255 0 0 0 false Below Categories Above 0.1 0.1 4 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 false 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 Numeric 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 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 Series1 Orthogonal_Value 0 Outside false Rectangle false 1.0 Text Sum Vertical 1 255 139 139 139 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 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["category_key"] Orthogonal_Value , Outside false false 1.0 Text Sum Descending getKeyFiguresRowPosition(row["category_key"], row["category_index"]) Horizontal 1 false Arial 10.0 false 255 0 0 0 0 255 255 255 1 255 0 0 0 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 true Min 0.0 true true false 255 192 192 192 255 192 192 192 Horizontal 60.0 -20.0 45.0 0.0 None ]]> SVG eq row["targetgroup_index"] 1 true 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 360px 668px all reportContext.getPersistentGlobalVariable("showNet") == false 2 1 full-width MailingSummaryDataCube rate CategoryGroup/category TargetgroupGroup/targetgroup all data["value_CategoryGroup/category_TargetgroupGroup/targetgroup"] >= 0 && data["value_CategoryGroup/category_TargetgroupGroup/targetgroup"] != null && isCategoryDataExpired(data["categoryKey"]) == false Packages.com.agnitas.messages.I18nString.getLocaleString("NotAvailableShort", reportContext.getLocale()) Currency #,##0.00 all data["value_CategoryGroup/category_TargetgroupGroup/targetgroup"] < 0 || data["value_CategoryGroup/category_TargetgroupGroup/targetgroup"] == null || data["index"] != CommonKeys.REVENUE_INDEX revenue Currency #,##0 all data["value_CategoryGroup/category_TargetgroupGroup/targetgroup"] < 0 || data["value_CategoryGroup/category_TargetgroupGroup/targetgroup"] == null || data["index"] == CommonKeys.REVENUE_INDEX || isCategoryDataExpired(data["categoryKey"]) == true value_CategoryGroup/category_TargetgroupGroup/targetgroup crosstab-value to-hide value CategoryGroup/category TargetgroupGroup/targetgroup all data["value_CategoryGroup/category_TargetgroupGroup/targetgroup"] >= 0 && data["value_CategoryGroup/category_TargetgroupGroup/targetgroup"] != null Packages.com.agnitas.messages.I18nString.getLocaleString("NotAvailableShort", reportContext.getLocale()) Custom (0.0%) all data["value_CategoryGroup/category_TargetgroupGroup/targetgroup"] < 0 || data["value_CategoryGroup/category_TargetgroupGroup/targetgroup"] == null || isCategoryDataExpired(data["categoryKey"]) == true rate_CategoryGroup/category_TargetgroupGroup/targetgroup crosstab-value to-hide CategoryGroup CategoryGroup/category getKeyFiguresRowPosition(dimension["CategoryGroup"]["category"]["categoryKey"], dimension["CategoryGroup"]["category"]["category_index"]) asc -1 Unformatted eq #999999 data["index"] == CommonKeys.REVENUE_INDEX && !params["isAlowedDeeptracking"].value true category left solid 1px #D3D3D3 TargetgroupGroup TargetgroupGroup/targetgroup dimension["TargetgroupGroup"]["targetgroup"]["targetgroup_index"] asc -1 auto auto targetgroup table-head crosstab-header 4 Packages.com.agnitas.messages.I18nString.getLocaleString("KeydataGeneral", reportContext.getLocale()) table-head dimension["CategoryGroup"]["category"]["category_index"] <= CommonKeys.REVENUE_INDEX || dimension["CategoryGroup"]["category"]["category_index"] == CommonKeys.OPENINGS_ANONYMOUS_INDEX || dimension["CategoryGroup"]["category"]["category_index"] == CommonKeys.CLICKS_ANONYMOUS_INDEX is-true always auto all reportContext.getPersistentGlobalVariable("showGross") == false category dimension["CategoryGroup"]["category"]["category"] string targetgroup dimension["TargetgroupGroup"]["targetgroup"] string value_CategoryGroup/category_TargetgroupGroup/targetgroup integer CategoryGroup/category TargetgroupGroup/targetgroup SUM Expression measure["value"] rate_CategoryGroup/category_TargetgroupGroup/targetgroup float CategoryGroup/category TargetgroupGroup/targetgroup SUM Expression measure["rate"] dimension["CategoryGroup"]["category"]["category_index"] < CommonKeys.REVENUE_INDEX && hasPercentageRepresentation(dimension["CategoryGroup"]["category"]["categoryKey"]) index dimension["CategoryGroup"]["category"]["category_index"] integer revenue data["value_CategoryGroup/category_TargetgroupGroup/targetgroup"]/100 float categoryKey dimension["CategoryGroup"]["category"]["categoryKey"] string table table-striped MailingSummaryDataCube rate CategoryGroup/category TargetgroupGroup/targetgroup all data["value_CategoryGroup/category_TargetgroupGroup/targetgroup"] >= 0 && data["value_CategoryGroup/category_TargetgroupGroup/targetgroup"] != null && isCategoryDataExpired(data["categoryKey"]) == false Packages.com.agnitas.messages.I18nString.getLocaleString("NotAvailableShort", reportContext.getLocale()) Currency #,##0.00 all data["value_CategoryGroup/category_TargetgroupGroup/targetgroup"] < 0 || data["value_CategoryGroup/category_TargetgroupGroup/targetgroup"] == null || data["index"] != CommonKeys.REVENUE_INDEX revenue Currency #,##0 all data["value_CategoryGroup/category_TargetgroupGroup/targetgroup"] < 0 || data["value_CategoryGroup/category_TargetgroupGroup/targetgroup"] == null || data["index"] == CommonKeys.REVENUE_INDEX || isCategoryDataExpired(data["categoryKey"]) == true value_CategoryGroup/category_TargetgroupGroup/targetgroup crosstab-value to-hide value CategoryGroup/category TargetgroupGroup/targetgroup all data["value_CategoryGroup/category_TargetgroupGroup/targetgroup"] >= 0 && data["value_CategoryGroup/category_TargetgroupGroup/targetgroup"] != null Packages.com.agnitas.messages.I18nString.getLocaleString("NotAvailableShort", reportContext.getLocale()) Custom (0.0%) all data["value_CategoryGroup/category_TargetgroupGroup/targetgroup"] < 0 || data["value_CategoryGroup/category_TargetgroupGroup/targetgroup"] == null || isCategoryDataExpired(data["categoryKey"]) == true deliveredRate_Binding crosstab-value to-hide CategoryGroup CategoryGroup/category getKeyFiguresRowPosition(dimension["CategoryGroup"]["category"]["categoryKey"], dimension["CategoryGroup"]["category"]["category_index"]) asc -1 Unformatted eq #999999 data["index"] == CommonKeys.REVENUE_INDEX && !params["isAlowedDeeptracking"].value true category left solid 1px #D3D3D3 TargetgroupGroup TargetgroupGroup/targetgroup dimension["TargetgroupGroup"]["targetgroup"]["targetgroup_index"] asc -1 auto auto targetgroup table-head crosstab-header 4 Packages.com.agnitas.messages.I18nString.getLocaleString("KeydataGeneral", reportContext.getLocale()) table-head dimension["CategoryGroup"]["category"]["category_index"] <= CommonKeys.REVENUE_INDEX || dimension["CategoryGroup"]["category"]["category_index"] == CommonKeys.OPENINGS_ANONYMOUS_INDEX || dimension["CategoryGroup"]["category"]["category_index"] == CommonKeys.CLICKS_ANONYMOUS_INDEX is-true always auto all reportContext.getPersistentGlobalVariable("showNet") == false category dimension["CategoryGroup"]["category"]["category"] string targetgroup dimension["TargetgroupGroup"]["targetgroup"] string value_CategoryGroup/category_TargetgroupGroup/targetgroup integer CategoryGroup/category TargetgroupGroup/targetgroup SUM Expression measure["value"] index dimension["CategoryGroup"]["category"]["category_index"] integer revenue data["value_CategoryGroup/category_TargetgroupGroup/targetgroup"]/100 float deliveredRate_CategoryGroup/category_TargetgroupGroup/targetgroup float CategoryGroup/category TargetgroupGroup/targetgroup SUM Expression measure["deliveredRate"] dimension["CategoryGroup"]["category"]["category_index"] < CommonKeys.REVENUE_INDEX Column Binding measure["deliveredRate"] float deliveredRate_Binding float CategoryGroup/category TargetgroupGroup/targetgroup SUM Expression measure["deliveredRate"] dimension["CategoryGroup"]["category"]["category_index"] < CommonKeys.REVENUE_INDEX && hasPercentageRepresentation(dimension["CategoryGroup"]["category"]["categoryKey"]) categoryKey dimension["CategoryGroup"]["category"]["categoryKey"] string table table-striped all onepixelStatisticExpired == true half-width table report-title Packages.com.agnitas.messages.I18nString.getLocaleString("report.mailing.openersByDevices", reportContext.getLocale()) 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 136 136 136 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 eq row["targetgroup_index"] 1 true false 320px 668px MailingSummaryDataSet category dataSetRow["category"] string category_index dataSetRow["category_index"] integer targetgroup dataSetRow["targetgroup"] string targetgroup_index dataSetRow["targetgroup_index"] integer value dataSetRow["value"] integer rate dataSetRow["rate"] float half-width table report-title Packages.com.agnitas.messages.I18nString.getLocaleString("report.mailing.clickersByDevices", reportContext.getLocale()) 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 136 136 136 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 eq row["targetgroup_index"] 1 true false block 320px 668px MailingSummaryDataSet category dataSetRow["category"] string category_index dataSetRow["category_index"] integer targetgroup dataSetRow["targetgroup"] string targetgroup_index dataSetRow["targetgroup_index"] integer value dataSetRow["value"] integer rate dataSetRow["rate"] float 2 1 full-width MailingSummaryDataCube rate CategoryGroup/category TargetgroupGroup/targetgroup all onepixelStatisticExpired != true Packages.com.agnitas.messages.I18nString.getLocaleString("NotAvailableShort", reportContext.getLocale()) html 0px Currency #,##0 all onepixelStatisticExpired == true value_CategoryGroup/category_TargetgroupGroup/targetgroup crosstab-value to-hide value CategoryGroup/category TargetgroupGroup/targetgroup solid 1px #D3D3D3 solid 1px #D3D3D3 Custom (0.0%) all onepixelStatisticExpired == true rate_CategoryGroup/category_TargetgroupGroup/targetgroup_new crosstab-value to-hide CategoryGroup CategoryGroup/category 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"]["category_index"] asc -1 Unformatted category left TargetgroupGroup TargetgroupGroup/targetgroup dimension["TargetgroupGroup"]["targetgroup"]["targetgroup_index"] asc -1 auto auto targetgroup table-head crosstab-header 4 Packages.com.agnitas.messages.I18nString.getLocaleString("KeydataPCMobile", reportContext.getLocale()) table-head always auto category dimension["CategoryGroup"]["category"]["category"] string targetgroup dimension["TargetgroupGroup"]["targetgroup"] string value_CategoryGroup/category_TargetgroupGroup/targetgroup integer CategoryGroup/category TargetgroupGroup/targetgroup SUM Expression measure["value"] category_index dimension["CategoryGroup"]["category"]["category_index"] integer rate_CategoryGroup/category_TargetgroupGroup/targetgroup_new 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_CategoryGroup/category_TargetgroupGroup/targetgroup"] > 0) {1} else {0} } else { data["rate_CategoryGroup/category_TargetgroupGroup/targetgroup"] } float category_1 dimension["CategoryGroup"]["category"] string rate_CategoryGroup/category_TargetgroupGroup/targetgroup measure["rate"] float CategoryGroup/category TargetgroupGroup/targetgroup SUM total_sent integer TargetgroupGroup/targetgroup SUM Expression measure["value"] dimension["CategoryGroup"]["category"]["category_index"] == CommonKeys.DELIVERED_EMAILS_INDEX table table-striped 2 1 full-width MailingSummaryDataCube value_string CategoryGroup/category TargetgroupGroup/targetgroup all onepixelStatisticExpired != true Packages.com.agnitas.messages.I18nString.getLocaleString("NotAvailableShort", reportContext.getLocale()) html all onepixelStatisticExpired == true value_string_CategoryGroup/category_TargetgroupGroup/targetgroup crosstab-value to-hide CategoryGroup CategoryGroup/category dimension["CategoryGroup"]["category"]["category_index"] >= CommonKeys.OPENINGS_GROSS_MEASURED_INDEX && dimension["CategoryGroup"]["category"]["category_index"] <= CommonKeys.ACTIVITY_RATE_INDEX is-true true dimension["CategoryGroup"]["category"]["category_index"] asc -1 Unformatted category left TargetgroupGroup TargetgroupGroup/targetgroup dimension["TargetgroupGroup"]["targetgroup"]["targetgroup_index"] asc -1 auto auto targetgroup table-head crosstab-header 4 Packages.com.agnitas.messages.I18nString.getLocaleString("statistic.Response", reportContext.getLocale()) table-head always auto category dimension["CategoryGroup"]["category"]["category"] string targetgroup dimension["TargetgroupGroup"]["targetgroup"] string value_CategoryGroup/category_TargetgroupGroup/targetgroup integer CategoryGroup/category TargetgroupGroup/targetgroup SUM Expression measure["value"] rate_CategoryGroup/category_TargetgroupGroup/targetgroup float CategoryGroup/category TargetgroupGroup/targetgroup SUM Expression measure["rate"] category_index dimension["CategoryGroup"]["category"]["category_index"] integer Column Binding data["rate_CategoryGroup/category_TargetgroupGroup/targetgroup"] float rate_CategoryGroup/category_TargetgroupGroup/targetgroup_new data["rate_CategoryGroup/category_TargetgroupGroup/targetgroup"] float value_string_CategoryGroup/category_TargetgroupGroup/targetgroup if(data["category_index"] == CommonKeys.OPENINGS_GROSS_MEASURED_INDEX || data["category_index"] == CommonKeys.CLICKS_GROSS_INDEX) { "" + Formatter.format(data["value_CategoryGroup/category_TargetgroupGroup/targetgroup"], "#,##0") } else if(data["category_index"] == CommonKeys.ACTIVITY_RATE_INDEX) { "" + Formatter.format(data["rate_CategoryGroup/category_TargetgroupGroup/targetgroup"], "0.0%") } else {""} string category_1 dimension["CategoryGroup"]["category"] string table table-striped 2 1 footnote 0pt Packages.com.agnitas.messages.I18nString.getLocaleString("report.mailsize.explanation", reportContext.getLocale()) footnote 0pt Packages.com.agnitas.messages.I18nString.getLocaleString("report.opens.measured.explanation", reportContext.getLocale()) footnote 0pt Packages.com.agnitas.messages.I18nString.getLocaleString("report.opens.invisible.explanation", reportContext.getLocale()) footnote Packages.com.agnitas.messages.I18nString.getLocaleString("report.opens.pc.and.mobile.explanation", reportContext.getLocale()) footnote 0px all params["trackingAllowed"].value == true || params["selectedTargets"] == null || params["selectedTargets"] == "" Packages.com.agnitas.messages.I18nString.getLocaleString("noMailingTracking", reportContext.getLocale()) footnote Packages.com.agnitas.messages.I18nString.getLocaleString("statistic.MeasuredOpeningsGross.explanation", reportContext.getLocale()) footnote Packages.com.agnitas.messages.I18nString.getLocaleString("statistic.ActivityRate.explanation", reportContext.getLocale()) footnote Packages.com.agnitas.messages.I18nString.getLocaleString("statistic.withoutConfirmation.explanation", reportContext.getLocale()) footnote 0pt all reportContext.getPersistentGlobalVariable("trackingExists") == true Packages.com.agnitas.messages.I18nString.getLocaleString("noTrackingData", reportContext.getLocale()) footnote all successStatisticExpired != true && onepixelStatisticExpired != true Packages.com.agnitas.messages.I18nString.getLocaleString("statistic.nodata.hint", reportContext.getLocale(), getMinimalExpirationPeriod()) html MailingSummaryDataSet category dataSetRow["category"] string category_index dataSetRow["category_index"] integer targetgroup dataSetRow["targetgroup"] string targetgroup_index dataSetRow["targetgroup_index"] integer value dataSetRow["value"] integer rate dataSetRow["rate"] float deliveredRate deliveredRate dataSetRow["deliveredRate"] float value_string value_string dataSetRow["value_string"] string DeliveredRate dataSetRow["deliveredRate"] float true ne row["category_index"] CommonKeys.OPENERS_TRACKED_INDEX

Packages.com.agnitas.messages.I18nString.getLocaleString("birt.Target", reportContext.getLocale()) Packages.com.agnitas.messages.I18nString.getLocaleString("grid.mediapool.category", reportContext.getLocale()) Packages.com.agnitas.messages.I18nString.getLocaleString("value", reportContext.getLocale()) Packages.com.agnitas.messages.I18nString.getLocaleString("Brutto", reportContext.getLocale()) Packages.com.agnitas.messages.I18nString.getLocaleString("Netto", reportContext.getLocale())

targetgroup category all row["value"] >= 0 Packages.com.agnitas.messages.I18nString.getLocaleString("NotAvailableShort", reportContext.getLocale()) all row["value"] < 0 value all row["value"] >= 0 Packages.com.agnitas.messages.I18nString.getLocaleString("NotAvailableShort", reportContext.getLocale()) Percent Percent all row["value"] < 0 rate all row["value"] >= 0 Packages.com.agnitas.messages.I18nString.getLocaleString("NotAvailableShort", reportContext.getLocale()) Percent Percent all row["value"] < 0 DeliveredRate Currency #,##0 all data["value_CategoryGroup/category_TargetgroupGroup/targetgroup"] < 0 || data["index"] == CommonKeys.REVENUE_INDEX value_CategoryGroup/category_TargetgroupGroup/targetgroup