WHERE J2GDATE(SDPPDJ) BETWEEN ‘’ and ‘’ –AND sdco = #ParamValue(?Company?)# AND sdco = 00500 AND TRIM(sdmcu) = ‘50031’ AND TRIM(sdLITM) =’63111′ AND SDROUT = ‘998’ AND SDSHPN > 0 AND (sdlttr’32’ ) A ) A ) AAĪs I am not using FM model, I cant use J2GDATE function to convert Julian date to Georgian Date (which a DB function) in Query Filter page.

SELECT SDPPDJ, sdco ,sdmcu, SDLITM, SDDSC2 ,sdlocn ,CARTONS,SELL ,VOLUME ,WEIGHT ,DRY_CASES ,FRZ_CASES ,RFG_CASES ,OPS_CASES ,OTHER_CASESįROM ( Select A.* ,rsscvl/10 volume,rswgts/10000 weight From ( SELECT SDPPDJ, sdco ,sdmcu, SDLITM, SDDSC2,sdlocn ,rswgts ,rsscvl ,SDSOQS CARTONS,(SDAEXP/100) SELL ,DRY_CASES ,FRZ_CASES ,RFG_CASES ,OPS_CASES ,OTHER_CASES FROM ( SELECT CASE WHEN xhfrth=’DRY’ THEN SDSOQS ELSE 0 END DRY_CASES, CASE WHEN xhfrth=’FRZ’ THEN SDSOQS ELSE 0 END FRZ_CASES, CASE WHEN xhfrth=’RFG’ THEN SDSOQS ELSE 0 END RFG_CASES, CASE WHEN xhfrth=’OPS’ THEN SDSOQS ELSE 0 END OPS_CASES, CASE WHEN xhfrth=’DRY’ THEN 0 WHEN xhfrth=’FRZ’ THEN 0 WHEN xhfrth=’RFG’ THEN 0 WHEN xhfrth=’OPS’ THEN 0 ELSE SDSOQS END OTHER_CASES, SDPPDJ, sdco ,sdmcu, SDAN8, ABALPH ,absic, SDADDJ ,SDLITM,SDDSC2, sdlocn, SDROUT ,ABALKY,rsstsq, SDSRP1,sddoc,sdshpn,rswgts ,rsscvl, rsldnm, xhssts,drdl01, (SDSOQS), SDAEXP from ( select * from PRODDTA.F4211 A Note: I am very new to Cognos and trying to create a POC to go ahead with Cognos for our BI solution. If you could please look into below Native SQL which I am using would give you a better idea what I am trying to achieve.

Cognos sql prompt