Identify All Reports with ONLY Optional Prompts

[adam_mc]

Does anyone know of a way to easily identify all reports system wide that only have optional prompts?
We have a number of large and potentially long running reports that use multiple prompts that we want the business to only be able to run a version that requires them to enter at least one prompt.
By forcing entry of at least one prompt this will speed up performance of business ad-hoc reporting whilst we secure the full open-ended report to run at a less system impactful time.

We know how to enforce the entry of single prompt, but are looking for a quick way to identify all reports needing changing.

Thanks in advance,
Adam.

[CognosPaul]

This is difficult. Prompts can appear in multiple ways.

Are you using any embedded prompts in the metadata model? Are you using prompt macros?

Do you have motio or meta manager? One thing you might try doing is having it attempt to run every report - if it fails with needing to populate a parameter you can remove it from your list.

[TomCognos]

Ok. I have a round about way of getting you mostly there. Done a bit of work in the past with SQL on the content store. Will post the full sql (MS SQL), just because its ridiculously handy. This is running on 11.0.11

You can easily modify the ReportSpec column sql that will contain the xml to filter on the appropriate tags i.e. required="false" for optional prompts. Though this will most likely return filters that are optional as well. So may need a bit of extra work to narrow down the field.

It's fairly raw due to the on going development with loads of commented out code due to different requirements of the code over time.

In its current state it brings back report/object location, i.e. team content or my folders with owner, name, object type (report dashboards analysis etc), Path, object owner, package name, xml.