AnsweredAssumed Answered

Error while executing a NSQL

Question asked by Krishna4452769 on Feb 26, 2014
Latest reply on Feb 26, 2014 by Krishna4452769

Hi All,

I am getting error NPT-0103: Error when trying to execute the query while trying to execute below query, Please help

 

SELECT @SELECT:DIM:USER_DEF:IMPLIED:USER_LIST:rownum:row_num@,       
         @SELECT:DIM_PROP:USER_DEF:IMPLIED:USER_LIST:EWO_AI.Code:Code@
,        @SELECT:DIM_PROP:USER_DEF:IMPLIED:USER_LIST:EWO_AI.Name:Name@
,        @SELECT:DIM_PROP:USER_DEF:IMPLIED:USER_LIST:EWO_AI.Subject:Subject@
,        @SELECT:DIM_PROP:USER_DEF:IMPLIED:USER_LIST:EWO_AI.Status_Code:Status_Code@
,        @SELECT:DIM_PROP:USER_DEF:IMPLIED:USER_LIST:EWO_AI.full_name:full_name@
,        @SELECT:DIM_PROP:USER_DEF:IMPLIED:USER_LIST:EWO_AI.NAME1:NAME1@
,        @SELECT:DIM_PROP:USER_DEF:IMPLIED:USER_LIST:EWO_AI.DUE_Date:DUE_Date@
,        @SELECT:DIM_PROP:USER_DEF:IMPLIED:USER_LIST:EWO_AI.nna_bus_analyst:nna_bus_analyst@
,        @SELECT:DIM_PROP:USER_DEF:IMPLIED:USER_LIST:EWO_AI.nna_ewo_status_nissn:nna_ewo_status_nissn@
,        @SELECT:DIM_PROP:USER_DEF:IMPLIED:USER_LIST:EWO_AI.enh_hours_total:enh_hours_total@


FROM
(
Select  I.CODE,I.NAME,CAI.Subject,CAIA.Status_Code,SR.Full_name,SR1.Full_Name NAME1,
CAIA.DUE_Date,P.nna_bus_analyst,
P.nna_ewo_status_nissn,P.enh_hours_total,P.enh_hours_total
FROM INV_INVESTMENTS I,cal_action_items CAI,cal_action_item_assignees CAIA,odf_ca_project p, cmn_lookups_v l, SRM_RESOURCES SR,
SRM_RESOURCES SR1
WHERE p.id = i.id
and l.language_code ='en'
AND l.lookup_type = 'NNA_EFFORT_TYPES'
and l.lookup_code = 'MINOR_ENH'
and CAI.ID = CAIA.ID
and CAI.OBJECT_ID = I.ID
and SR1.ID = P.nna_bus_analyst

)EWO_AI
WHERE @FILTER@

Outcomes