If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Recent posts

#2
Reporting / Re: Error in Reports with Html...
Last post by Vanceavash - Yesterday at 04:41:45 AM
#5
Reporting / Re: Running Count off of a Ran...
Last post by jsibley - 04 Sep 2026 09:22:25 AM
I figured it out.
running-count([Initiated Date] for [Employee Number], [Rank])
#6
Мы — один из лучших хостингов игровых серверов.
У нас гарантирована работа вашего сервера круглосуточно,
мы предоставляем надёжную защиту уровней L3-L7,
а также мы используем только качественное и современное оборудование.
https://lix.li/qPLFLj
#7
Reporting / Running Count off of a Rank
Last post by jsibley - 03 Sep 2026 03:57:35 PM
I have workflow set up for approvals.  One person can have multiple approvals span over different days.  I tried doing a running count like this running-count([Initiated Date] for [Employee Number]).  The result gives me a running count of all of the employee number ignoring the Initiated Date.

I switched it rank seems to count the numbers well.  The challenge is I want to have a running count based off a rank like this:
1   1
1   2
2   1
2   2
2   3

I switched the Auto group & summarize button on and off and it didn't help.  Any ideas?
#8
Reporting / Re: Cognos Audit Report – Extr...
Last post by Good Friend - 24 Aug 2026 12:01:54 PM
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.
#9
Reporting / Re: Cognos Audit Report – Extr...
Last post by dougp - 24 Aug 2026 11:53:20 AM
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.
#10
Reporting / Cognos Audit Report – Extracti...
Last post by Good Friend - 24 Aug 2026 09:48:05 AM
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.