Iām trying to get ācleanā report path for giving Cognos 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 play with SUBSTR, INSTR and LENGTH (REPLACE is not working) functions (Iām using Oracle 10g), but already killed most of my afternoon, but didnāt go far. Even if Iām getting one scenario, Iām afraid that I wonāt be able to get dynamic folder structure all the time i.e. one time Iāll have 4 folders and next time it will be 2 or 5, so not sure how to capture that.
what is the purpose of a clean report path? Do you want to report directly on the audit database and change the path format in a report, or preform a ETL job and write the result in a new table and query on this table?
I need this for a report. Report with a status/health of the system, so this will be part of dashboard. Displaying path directly from Audit db would be a garbage, donāt you think?
i used ultra-edit as a reformat (kind of ETL)step in order to get the format i wanted and loaded the results from MotioPI and Cognos audit data in a database. With framework manager i created a framework in order to run reports with it.
Iām not familiar with this tool and itās not free if I want to try it, but anyway, I guess Iām missing something with your method. If you used built-in ultra-edit macro, how can you use it with FM? Can you provide a little more insight on that?