Cognos Analytics

​In Cognos 11 Auditing, what is the simplest way to parse out the report path into separate fields?

Thanks,
Jen

​In Cognos 11 Auditing, what is the simplest way to parse out the report path into separate fields?

Thanks,
Jen

As Norbert said, you can use position and substring. If you open the Audit FM Package in Framework Manager and view some of the query items it will give you and idea of what to do. Specifically have a look at the Package Query Item under Run Reports.

if ([Audit].[COGIPF_RUNREPORT].[PACKAGE] = '' ) then (' ')
else
if ([Audit].[COGIPF_RUNREPORT].[PACKAGE] = 'null') then (' ')
else
if(position('/package[', [Audit].[COGIPF_RUNREPORT].[PACKAGE])>0)
then(substring ([Audit].[COGIPF_RUNREPORT].[PACKAGE], position('/package[', [Audit].[COGIPF_RUNREPORT].[PACKAGE])+16, position(']', substring ([Audit].[COGIPF_RUNREPORT].[PACKAGE], position('/package[', [Audit].[COGIPF_RUNREPORT].[PACKAGE])+16)) -2))
else
if(position('/module[', [Audit].[COGIPF_RUNREPORT].[PACKAGE])>0)
then(substring ([Audit].[COGIPF_RUNREPORT].[PACKAGE], position('/module[', [Audit].[COGIPF_RUNREPORT].[PACKAGE])+15, position(']', substring ([Audit].[COGIPF_RUNREPORT].[PACKAGE], position('/module[', [Audit].[COGIPF_RUNREPORT].[PACKAGE])+15)) -2))
else
if(position('/uploadedFile[', [Audit].[COGIPF_RUNREPORT].[PACKAGE])>0)
then(substring ([Audit].[COGIPF_RUNREPORT].[PACKAGE], position('/uploadedFile[', [Audit].[COGIPF_RUNREPORT].[PACKAGE])+21, position(']', substring ([Audit].[COGIPF_RUNREPORT].[PACKAGE], position('/uploadedFile[', [Audit].[COGIPF_RUNREPORT].[PACKAGE])+21)) -2))
else
if(position('/dataSet2[', [Audit].[COGIPF_RUNREPORT].[PACKAGE])>0)
then(substring ([Audit].[COGIPF_RUNREPORT].[PACKAGE], position('/dataSet2[', [Audit].[COGIPF_RUNREPORT].[PACKAGE])+17, position(']', substring ([Audit].[COGIPF_RUNREPORT].[PACKAGE], position('/dataSet2[', [Audit].[COGIPF_RUNREPORT].[PACKAGE])+17)) -2))
else
(substring ([Audit].[COGIPF_RUNREPORT].[PACKAGE], 1, character_length( [Audit].[COGIPF_RUNREPORT].[PACKAGE])))

​In Cognos 11 Auditing, what is the simplest way to parse out the report path into separate fields?

Thanks,
Jen