Print Page - Get “clean” report path from Audit Reports from folders in 10.1 version

Title: Get “clean” report path from Audit Reports from folders in 10.1 version
Post by: cognosbi.dwh on 09 Nov 2020 06:53:55 AM

I'm trying to get "clean" report path in Cognos 10.1 report using Audit package "Run Reports>Report search path" or "COGIPF_RUNREPORT>REPORT PATH". What I'm getting now is /content/folder[@name='Folder1′]/folder[@name='Folder2′]/folder[@name='Folder3′]/folder[@name='Folder4′]/report[@name='MyReport'], but what I expected is Folder1>Folder2>Folder3>Folder4>MyReport.

I tried by using SUBSTR, INSTR and LENGTH (REPLACE is not working) functions.

Can anyone help me on this ?

Title: Re: Get “clean” report path from Audit Reports from folders in 10.1 version
Post by: dougp on 09 Nov 2020 10:19:51 AM

I use REPLACE. Maybe your syntax is off. Read up on the REPLACE function.

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: cognosbi.dwh on 09 Nov 2020 06:53:55 AM