I am new to CPM and Jasper Studio. I created a report in Jasper studio, in the report sql I have the following parameter that should be prompting for multiple vales to select from. When I run the report there is no value. Here is my parameter:
AND $X{IN, DWH_RES_OBS_MAPPING.OBS_UNIT, OBS_UNIT}
full sql:
<![CDATA[SELECT DWH_RES_RESOURCE.RESOURCE_NAME , DWH_TME_SHEET.PERIOD_FINISH_DATE ,
DWH_RES_RESOURCE.RESOURCE_MANAGER , DWH_LKP_SCI_DEPARTMENT.SCI_DEPARTMENT,
DWH_TME_SHEET_LN.TIMESHEET_STATUS , sum(DWH_TME_ENTRY_FACTS.TIME_HOURS)
FROM DWH_TME_SHEET DWH_TME_SHEET
INNER JOIN DWH_TME_SHEET_LN DWH_TME_SHEET_LN ON ( DWH_TME_SHEET.TIMESHEET_KEY = DWH_TME_SHEET_LN.TIMESHEET_KEY AND DWH_TME_SHEET_LN.LANGUAGE_CODE ='en' )
INNER JOIN DWH_TME_ENTRY_FACTS DWH_TME_ENTRY_FACTS ON ( DWH_TME_SHEET.TIMESHEET_KEY = DWH_TME_ENTRY_FACTS.TIMESHEET_KEY )
INNER JOIN DWH_TME_PERIOD DWH_TME_PERIOD ON (DWH_TME_SHEET.TIME_PERIOD_KEY = DWH_TME_PERIOD.TIME_PERIOD_KEY )
INNER JOIN DWH_TME_ENTRY DWH_TME_ENTRY ON( DWH_TME_SHEET.TIMESHEET_KEY =DWH_TME_ENTRY. TIMESHEET_KEY)
INNER JOIN DWH_INV_PROJECT DWH_INV_PROJECT ON ( DWH_TME_ENTRY.INVESTMENT_KEY = DWH_INV_PROJECT.INVESTMENT_KEY )
INNER JOIN DWH_LKP_SCI_DEPARTMENT DWH_LKP_SCI_DEPARTMENT ON (DWH_INV_PROJECT.SCI_DEPARTMENT_KEY =DWH_LKP_SCI_DEPARTMENT.SCI_DEPARTMENT_KEY )
INNER JOIN DWH_RES_RESOURCE DWH_RES_RESOURCE ON ( DWH_TME_SHEET.RESOURCE_KEY= DWH_RES_RESOURCE.RESOURCE_KEY )
INNER JOIN DWH_RES_RESOURCE_LN DWH_RES_RESOURCE_LN ON (DWH_RES_RESOURCE.RESOURCE_KEY = DWH_RES_RESOURCE_LN.RESOURCE_KEY AND DWH_RES_RESOURCE_LN.LANGUAGE_CODE='en')
INNER JOIN DWH_RES_OBS_MAPPING DWH_RES_OBS_MAPPING ON (DWH_RES_RESOURCE.RESOURCE_KEY = DWH_RES_OBS_MAPPING.RESOURCE_KEY)
WHERE DWH_TME_SHEET.TIMESHEET_STATUS_KEY <5
AND $X{IN,DWH_RES_OBS_MAPPING.OBS_TYPE_ID, OBS_TYPE_ID}
AND $X{IN, DWH_RES_OBS_MAPPING.OBS_UNIT, OBS_UNIT}
GROUP BY DWH_LKP_SCI_DEPARTMENT.SCI_DEPARTMENT,DWH_TME_SHEET.PERIOD_FINISH_DATE ,
DWH_TME_ENTRY_FACTS.TIME_HOURS,DWH_TME_SHEET_LN.TIMESHEET_STATUS ,
DWH_RES_RESOURCE.RESOURCE_NAME , DWH_RES_RESOURCE.RESOURCE_MANAGER
ORDER BY DWH_TME_SHEET_LN.TIMESHEET_STATUS]]>