Eclipse BIRT Designer Version 4.6.0.v201606072122in/templates/blank_report.gifltr96staticdatetruesimpletext-boxUnformattedstaticdatetruesimpletext-boxUnformattedmetadataBidiFormatStrILYNNdisabledMetadataBidiFormatStrcontentBidiFormatStrILYNNdisabledContentBidiFormatStroracle.jdbc.driver.OracleDriverjdbc:oracle:thin:@10.0.0.27:1521:sukkurFinanceZjEyMzQ1Njc4ZQ==1MONTH_CASESdecimal2MONTH_AVERAGE_CASESdecimal3PROD_MONTHstring4PROD_WDdecimal5NO_DAYSstring6LINE_IDdecimal7IDLE_DAYSdecimal8LINE_DESCstring9MONTH_NOdecimalData Source1MONTH_CASESMONTH_CASESdecimal2MONTH_AVERAGE_CASESMONTH_AVERAGE_CASESdecimal3PROD_MONTHPROD_MONTHstring4PROD_WDPROD_WDdecimal5NO_DAYSNO_DAYSstring6LINE_IDLINE_IDdecimal7IDLE_DAYSIDLE_DAYSdecimal8LINE_DESCLINE_DESCstring9MONTH_NOMONTH_NOdecimal=TO_DATE(@fdate,'yyyy/mm/dd') AND ADATE<=TO_DATE(@tdate,'yyyy/mm/dd')
GROUP BY ADATE, LINE_ID--, CASES
) temp
GROUP BY TO_CHAR(PROD_WD,'MON-YY'),to_char(last_day(PROD_WD),'DD'), LINE_ID
) MC
WHERE MC.LINE_ID=PROD_VIEW_NEW.line_id
AND ADATE>=TO_DATE(@fdate,'yyyy/mm/dd') AND ADATE<=TO_DATE(@tdate,'yyyy/mm/dd')
AND TO_CHAR(ADATE,'MON-YY')=MC.PROD_MONTH
GROUP BY MC.PROD_WD, MC.PROD_MONTH,mc.no_days, MC.LINE_ID, LINE_DESC, EXTRACT(MONTH FROM ADATE)
ORDER BY MC.LINE_ID, TO_DATE(Prod_Month,'MON-YY') ]]>NewTabularHierarchydecimalMONTH_NOstringPROD_MONTHNewTabularHierarchy1stringLINE_DESCdataSetRow["IDLE_DAYS"]decimalData Sethtmlnew Date()]]>Data CubeIDLE_DAYSGroup/PROD_MONTHGroup1/LINE_DESCsolidthinsolidthinsolidthinsolidthinDataIdlealltrueIDLE_DAYS_Group/PROD_MONTH_Group1/LINE_DESCGroup1/LINE_DESCsolidthinsolidthinsolidthinsolidthinAggregationalltrueIDLE_DAYS_Group1/LINE_DESCsolidthinsolidthinsolidthinsolidthinsolidthinsolidthinsolidthinsolidthinGroupGroup/MONTH_NOMONTH_NOsolidthinsolidthinsolidthinsolidthinGroup/PROD_MONTHPROD_MONTHsolidthinsolidthinsolidthinsolidthinGroup1Group1/LINE_DESCLINE_DESCsolidthinsolidthinsolidthinsolidthinsolidthinsolidthinsolidthinsolidthinsolidthinsolidthinsolidthinsolidthinsolidthinsolidthinsolidthinsolidthinsolidthinsolidthinsolidthinsolidthinMONTH_NOdimension["Group"]["MONTH_NO"]decimalPROD_MONTHdimension["Group"]["PROD_MONTH"]stringLINE_DESCdimension["Group1"]["LINE_DESC"]stringIDLE_DAYS_Group/PROD_MONTH_Group1/LINE_DESCmeasure["IDLE_DAYS"]decimalGroup/PROD_MONTHGroup1/LINE_DESCSUMIDLE_DAYS_Group1/LINE_DESCmeasure["IDLE_DAYS"]floatGroup1/LINE_DESCsumDataIdleif (data["IDLE_DAYS_Group/PROD_MONTH_Group1/LINE_DESC"] == null)
{
data["IDLE_DAYS_Group/PROD_MONTH_Group1/LINE_DESC"] = 31
}
else
{
data["IDLE_DAYS_Group/PROD_MONTH_Group1/LINE_DESC"]
}integerAggregationintegerGroup1/LINE_DESCSUMExpressiondata["DataIdle"]