Thanks, that helps. I do have access to query the Content Store, so I'll look into CMOBJPROPS7 and trace the CMID back to the report metadata. My main goal is to combine the report specification XML with the audit details and then parse the XML to identify the data items used by each report.

The official answer would be to use the Cognos Analytics REST API.  But I'm not using it for this.  I don't remember if it's because I had a working solution before the REST API came along and I'm just lazy, or if I found that the REST API couldn't (yet?) do what I needed in this regard.

If you can query the Content Store database, report specs are on CMOBJPROPS7.

Is there a way to create a Cognos Audit Report that includes report details such as report name, report location/path, report owner, package name, report specification/XML, and the data items used in each report?

I'm able to retrieve most of the report and audit details, but I'm having difficulty incorporating the report XML/specification and extracting the data items used within each report into the same output.

Has anyone implemented something similar or have suggestions on the best approach to retrieve and combine this information? All our content data is stored in Oracle database.

My overall goal is to find when employees come and go on leave, then send an email to IT letting them know the employee's status has changed.  I would like to send emails closer to real time than a longer report at the end of a day. 

In regular Cognos I use a running-count to find the latest information on things and filter by 1 after sorting dates descending.  When I try to go in Event Studio, I've figured out a way to do a running-count in there, but I'm not so sure I'm able to do sorting.  I would like to sort descending on the Status Start Date.  Is this possible?

We're running Cognos 12.1 with Business Analytics Dashboards. This happened with the last update, but we've noticed if we schedule a report for a certain day and time with html, pdf, and excel settings, that the report downloads as a empty file with a .532z extension. If there are no options set to download (pdf, excel), then it's fine as it just displays a html page. Has anyone ran across this before? Is there any fix for it? Our vendor we have, has zero answers and just wants to keep waiting for new versions to hope it fixes the issue. Attached is a zipped file of what we see.

Good afternoon,

I have a dahboard with multiple Visualizations using the same navigation path.
Is it possible to change the navigation paths for all these visualizations simultaniously?


Toine

I hope someone gets this!  I am a UKG customer and create many dashboards and reports for my organization.  I am attempting to add a visualization to a report and I am getting the error message 'Only a measure or a single value can be inserted in the selected location'.  It is a count of terms and for the 'Length' field.  It is a total calculation and I've used it extensively in dashboards.  What is weird is that I got it to work on the hires visualization.  At first it didn't work but I toggled on Autochart in properties and it let me add it.  Now while doing the terms visualization, it will not work.  I compared the properties side by side and they are identical.  I also compared the properties for the expressions as suggested on this site.  It will not let me add the terms count.  I also tried copying the visualization and changing the fields and it still won't work!  Please help!

With DMR, standard detail filters can be super tricky because Cognos tries to apply them after row retrieval, which often destroys performance or messes up rolled-up totals.
If you're filtering on member sets, try using dimensional functions like filter([MemberSet], [Measure] > X) or use a Slicer expression instead. If you have to use a detail filter, make sure you set the Application property to After Auto-Aggregation so it evaluates properly against the measure summaries rather than underlying relational rows.
Hope this helps! (Currently grinding through report tweaks while listening to audio via tunerhippo - keeps me sane during long Cognos debug sessions).

If it's just a couple of values, passing them as parameters keeps things clear and makes the function easier to reuse. Once the list starts getting long, though, I usually bundle related values into a single object or struct. It makes the code much easier to read and maintain later.

I've learned a lot just by reading older discussions here, and it's great to see how willing everyone is to help. Looking forward to picking up more Cognos tips and hopefully being able to contribute as I gain more experience.