public void assertKPIValues(KPI kpi, String[][] values) throws Exception { DataSet dataSet = KPIHelper.getDataSet(kpi); if (dataSet != null) { assertDataSetValues(dataSet, values, 0); } }
@Test // Auto-generated by KPITestMethodGenerator public void test_kpi_30251353675275870() throws Exception { KPI kpi = getKPIByCode("kpi_30251353675275870"); DataSet dataSet = KPIHelper.getDataSet(kpi); if (dataSet != null) { assertDataSetValues(dataSet, new String[][] { {"EARLY","7,524,909.475"}, {"STANDBY","6,654,928.048"}, {"ADVANCED","6,424,734.889"}}, 0); } }
@Test // Auto-generated by KPITestMethodGenerator public void test_kpi_63931223772633377() throws Exception { KPI kpi = getKPIByCode("kpi_63931223772633377"); DataSet dataSet = KPIHelper.getDataSet(kpi); if (dataSet != null) { assertDataSetValues(dataSet, new String[][] { {"Engineering","7,650.162"}, {"Management","6,017.47"}, {"Support","3,345.6"}, {"Sales","3,213.53"}, {"Services","2,504.5"}}, 0); } }
@Test // Auto-generated by KPITestMethodGenerator public void test_kpi_30441353507392054() throws Exception { KPI kpi = getKPIByCode("kpi_30441353507392054"); DataSet dataSet = KPIHelper.getDataSet(kpi); if (dataSet != null) { assertDataSetValues(dataSet, new String[][] { {"2010","2,906,030.224"}, {"2011","4,122,965.423"}, {"2012","4,075,631.39"}, {"2013","4,095,320.587"}, {"2014","4,197,797.742"}, {"2015","1,206,827.046"}}, 0); } }
@Test // Auto-generated by KPITestMethodGenerator public void test_kpi_63901223772516707() throws Exception { KPI kpi = getKPIByCode("kpi_63901223772516707"); DataSet dataSet = KPIHelper.getDataSet(kpi); if (dataSet != null) { assertDataSetValues(dataSet, new String[][] { {"Barcelona","2,913.14"}, {"Madrid","2,453.36"}, {"Brno","4,659.24"}, {"Westford","3,594.972"}, {"Raleigh","4,970.78"}, {"London","4,139.77"}}, 0); } }
@Test // Auto-generated by KPITestMethodGenerator public void test_kpi_30011353503663716() throws Exception { KPI kpi = getKPIByCode("kpi_30011353503663716"); DataSet dataSet = KPIHelper.getDataSet(kpi); if (dataSet != null) { assertDataSetValues(dataSet, new String[][] { {"WIN","2,467,342.049"}, {"VERBAL COMMITMENT","2,704,337.45"}, {"STANDBY","2,692,343.835"}, {"SHORT LISTED","2,720,890.442"}, {"QUALIFIED","2,614,849.549"}, {"LOST","2,614,342.545"}, {"DEMO","2,336,241.648"}, {"CONTACTED","2,454,224.894"}}, 0); } }
@Test // Auto-generated by KPITestMethodGenerator public void test_kpi_30361353506582145() throws Exception { KPI kpi = getKPIByCode("kpi_30361353506582145"); DataSet dataSet = KPIHelper.getDataSet(kpi); if (dataSet != null) { assertDataSetValues(dataSet, new String[][] { {"WIN","2,467,342.049"}, {"VERBAL COMMITMENT","2,704,337.45"}, {"STANDBY","2,692,343.835"}, {"SHORT LISTED","2,720,890.442"}, {"QUALIFIED","2,614,849.549"}, {"LOST","2,614,342.545"}, {"DEMO","2,336,241.648"}, {"CONTACTED","2,454,224.894"}}, 0); } }
@Test // Auto-generated by KPITestMethodGenerator public void test_kpi_21591363786594721() throws Exception { KPI kpi = getKPIByCode("kpi_21591363786594721"); DataSet dataSet = KPIHelper.getDataSet(kpi); if (dataSet != null) { assertDataSetValues(dataSet, new String[][] { {"VERBAL COMMITMENT","2,704,337.45"}, {"LOST","2,614,342.545"}, {"STANDBY","2,692,343.835"}, {"QUALIFIED","2,614,849.549"}, {"CONTACTED","2,454,224.894"}, {"WIN","2,467,342.049"}, {"SHORT LISTED","2,720,890.442"}, {"DEMO","2,336,241.648"}}, 0); } }
public static String generateKPIValuesArray(KPI kpi) { DataSet dataSet = KPIHelper.getDataSet(kpi); if (dataSet == null) return null; DataFormatterRegistry dataFormatterRegistry = DataFormatterRegistry.lookup(); StringBuffer buf = new StringBuffer(); buf.append("new String[][] {"); for (int i = 0; i < dataSet.getRowCount(); i++) { buf.append("\n{"); for (int j = 0; j < dataSet.getProperties().length; j++) { Object dataSetValue = dataSet.getValueAt(i, j); DataProperty prop = dataSet.getPropertyByColumn(j); DataPropertyFormatter propFormatter = dataFormatterRegistry.getPropertyFormatter(prop.getPropertyId()); String displayedValue = propFormatter.formatValue(prop, dataSetValue, Locale.ENGLISH); if (j > 0) buf.append(","); buf.append("\"" + displayedValue + "\""); } buf.append("}"); if (i < dataSet.getRowCount()-1) buf.append(","); } buf.append("}"); return buf.toString(); }
@Test // Auto-generated by KPITestMethodGenerator public void test_kpi_30331353506453066() throws Exception { KPI kpi = getKPIByCode("kpi_30331353506453066"); DataSet dataSet = KPIHelper.getDataSet(kpi); if (dataSet != null) { assertDataSetValues(dataSet, new String[][] { {"Roxie Foraker","2,659,589.977"}, {"Nita Marling","2,342,011.583"}, {"Neva Hunger","2,485,446.724"}, {"Kathrine Janas","2,435,833.788"}, {"Julio Burdge","2,873,807.116"}, {"Jerri Preble","2,521,398.184"}, {"Jamie Gilbeau","2,617,395.494"}, {"Darryl Innes","2,669,089.546"}}, 0); } }
@Test // Auto-generated by KPITestMethodGenerator public void test_kpi_30651353683614640() throws Exception { KPI kpi = getKPIByCode("kpi_30651353683614640"); DataSet dataSet = KPIHelper.getDataSet(kpi); if (dataSet != null) { assertDataSetValues(dataSet, new String[][] { {"Darryl Innes","2,669,089.546"}, {"Nita Marling","2,342,011.583"}, {"Roxie Foraker","2,659,589.977"}, {"Neva Hunger","2,485,446.724"}, {"Jamie Gilbeau","2,617,395.494"}, {"Jerri Preble","2,521,398.184"}, {"Kathrine Janas","2,435,833.788"}, {"Julio Burdge","2,873,807.116"}}, 0); } }
@Test // Auto-generated by KPITestMethodGenerator public void test_kpi_30041353504912610() throws Exception { KPI kpi = getKPIByCode("kpi_30041353504912610"); DataSet dataSet = KPIHelper.getDataSet(kpi); if (dataSet != null) { assertDataSetValues(dataSet, new String[][] { {"Julio Burdge","2,873,807.116"}, {"Darryl Innes","2,669,089.546"}, {"Roxie Foraker","2,659,589.977"}, {"Jamie Gilbeau","2,617,395.494"}, {"Jerri Preble","2,521,398.184"}, {"Neva Hunger","2,485,446.724"}, {"Kathrine Janas","2,435,833.788"}, {"Nita Marling","2,342,011.583"}}, 0); } }
@Test // Auto-generated by KPITestMethodGenerator public void test_kpi_30391353506887646() throws Exception { KPI kpi = getKPIByCode("kpi_30391353506887646"); DataSet dataSet = KPIHelper.getDataSet(kpi); if (dataSet != null) { assertDataSetValues(dataSet, new String[][] { {"PRODUCT 8","4,114,026.669"}, {"PRODUCT 6","2,079,768.984"}, {"PRODUCT 1","1,987,832.383"}, {"PRODUCT 3","1,925,443.347"}, {"PRODUCT 4","1,857,255.82"}, {"PRODUCT 10","1,854,040.865"}, {"PRODUCT 7","1,824,624.363"}, {"PRODUCT 11","1,758,737.539"}, {"PRODUCT 2","1,614,398.311"}, {"PRODUCT 5","1,588,444.131"}}, 0); } }
@Test // Auto-generated by KPITestMethodGenerator public void test_kpi_30801353685378049() throws Exception { KPI kpi = getKPIByCode("kpi_30801353685378049"); DataSet dataSet = KPIHelper.getDataSet(kpi); if (dataSet != null) { assertDataSetValues(dataSet, new String[][] { {"Company 3","330"}, {"Company 6","185"}, {"Company 8","172"}, {"Company 2","180"}, {"Company 7","190"}, {"Company 9","184"}, {"Company 4","188"}, {"Company 5","181"}, {"Company 1","190"}}, 0); } }
@Test // Auto-generated by KPITestMethodGenerator public void test_kpi_30831353686700387() throws Exception { KPI kpi = getKPIByCode("kpi_30831353686700387"); DataSet dataSet = KPIHelper.getDataSet(kpi); if (dataSet != null) { assertDataSetValues(dataSet, new String[][] { {"PRODUCT 8","4,114,026.669"}, {"PRODUCT 6","2,079,768.984"}, {"PRODUCT 1","1,987,832.383"}, {"PRODUCT 3","1,925,443.347"}, {"PRODUCT 4","1,857,255.82"}, {"PRODUCT 10","1,854,040.865"}, {"PRODUCT 7","1,824,624.363"}, {"PRODUCT 11","1,758,737.539"}, {"PRODUCT 2","1,614,398.311"}, {"PRODUCT 5","1,588,444.131"}}, 0); } }
@Test // Auto-generated by KPITestMethodGenerator public void test_kpi_30861353687605533() throws Exception { KPI kpi = getKPIByCode("kpi_30861353687605533"); DataSet dataSet = KPIHelper.getDataSet(kpi); if (dataSet != null) { assertDataSetValues(dataSet, new String[][] { {"0","2,057,056.508"}, {"10","2,375,578.04"}, {"20","2,008,834.675"}, {"30","2,176,257.697"}, {"40","2,207,890.542"}, {"50","2,091,138.732"}, {"60","1,820,731.107"}, {"70","2,066,648.416"}, {"80","1,842,871.528"}, {"90","1,957,565.167"}}, 0); } }
@Test // Auto-generated by KPITestMethodGenerator public void test_kpi_30101353505177974() throws Exception { KPI kpi = getKPIByCode("kpi_30101353505177974"); DataSet dataSet = KPIHelper.getDataSet(kpi); if (dataSet != null) { assertDataSetValues(dataSet, new String[][] { {"United States","74"}, {"United Kingdom","77"}, {"Turkey","67"}, {"Switzerland","71"}, {"Sweden","73"}, {"Spain","80"}, {"South Korea","69"}, {"Saudi Arabia","83"}, {"Russia","67"}, {"Poland","88"}, {"Australia, China, Netherlands, Canada, Mexico, Japan, Germany, Italy, France, Norway, India, Belgium, Indonesia, Brazil","1,051"}}, 0); } }
@Test // Auto-generated by KPITestMethodGenerator public void test_kpi_30461354643057084() throws Exception { KPI kpi = getKPIByCode("kpi_30461354643057084"); DataSet dataSet = KPIHelper.getDataSet(kpi); if (dataSet != null) { assertDataSetValues(dataSet, new String[][] { {"Roxie Foraker","3,832.46"}, {"Patricia J. Behr","2,533.57"}, {"Darryl Innes","1,970.19"}, {"Alan P. Adamson","1,606.2"}, {"Loretta R. Havens","1,486.6"}, {"Julio Burdge","1,459.45"}, {"Eileen L. Pereira","1,375.41"}, {"Kathrine Janas","1,326.432"}, {"Jerri Preble","1,242.48"}, {"Neva Hunger","1,229.6"}, {"Tony L. Crawford","1,137.53"}, {"Donald M. Stanton","1,026.06"}, {"Hannah B. Mackey","971.24"}, {"Jamie Gilbeau","792.59"}, {"Nita Marling","741.45"}}, 0); } }
@Test // Auto-generated by KPITestMethodGenerator public void test_kpi_30301353506280659() throws Exception { KPI kpi = getKPIByCode("kpi_30301353506280659"); DataSet dataSet = KPIHelper.getDataSet(kpi); if (dataSet != null) { assertDataSetValues(dataSet, new String[][] { {"Apr 2010","42,485,847.012"}, {"Jul 2010","51,622,861.461"}, {"Oct 2010","59,985,255.528"}, {"Jan 2011","48,658,783.972"}, {"Apr 2011","52,079,924.319"}, {"Jul 2011","55,270,895.043"}, {"Oct 2011","44,231,566.894"}, {"Jan 2012","49,108,590.261"}, {"Apr 2012","51,437,088.287"}, {"Jul 2012","43,640,397.533"}, {"Oct 2012","43,540,520.762"}, {"Jan 2013","57,330,014.521"}, {"Apr 2013","48,398,318.716"}, {"Jul 2013","45,819,149.797"}, {"Oct 2013","44,942,957.051"}, {"Jan 2014","56,941,978.584"}, {"Apr 2014","48,064,010.139"}, {"Jul 2014","50,072,135.677"}, {"Oct 2014","49,529,848.74"}, {"Jan 2015","46,840,850.458"}, {"Apr 2015","12,525,643.728"}}, 0); } }
DataSet dataSet = KPIHelper.getDataSet(kpi); if (dataSet != null) { assertDataSetValues(dataSet, new String[][] {