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

#91
Administration and Security / EveryOne and access for portal...
Last post by bobr12 - 19 Oct 2026 02:00:53 PM
CAS 11.2.1, SSO works
Any user who doesn't have any rights (at least I can't find EveryOne in roles in folder Cognos) but knows address of CAS can put adress in browser and open it. He see nothing except empty folders but is it possible to make some settings that users who doesn't have rights could't open portal at all?
May be some SQL queries for Content Store exists which shows EveryOne in roles (and I simply don't find EveryOne in all roles)

Also PAL (IBM Planning analytics) using CAS for authentication. Group EveryOne has some rights in it, and any user who doesn't have any rights in CAS can see objects of Group EveryOne because user who authorized from CAS is in EveyOne now
#92
Report Studio / Re: Comments in report express...
Last post by MichaelTaide - 08 Oct 2026 03:02:51 AM
Instead of criticism advise the problem decision.
 
 
__________
#93
Reporting / Emails reports with status "Wa...
Last post by jeremywv - 23 Sep 2026 02:01:47 PM
I have a bunch of reports that run on a schedule and email to clients.   I've noticed lately that the jobs are showing as "Waiting" under activities, yet seem to be emailing successfully.  I believe this started after I upgraded to 12.1.3. 

They show as waiting, but this when I got into details:
Information
CNC-SDS-0408 There are email messages waiting to be sent.
Information
CNC-SDS-0409 The email messages were sent to 4 recipients.

Has anyone seen this?
#94
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])
#95
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?
#96
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.
#97
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.
#98
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.
#99
Reporting / Sorting in Event Studio
Last post by jsibley - 20 Aug 2026 05:05:30 PM
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?

#100
Dashboards / Cognos 12.1 issue with schedul...
Last post by bhill - 05 Aug 2026 11:50:40 AM
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.