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

#11
Security / Re: setup a password protectio...
Last post by ClaytonMercer4518 - 31 Oct 2026 12:19:12 AM
For setting up password protection for PDF you can use this tool (https://www.pdfchamp.com/).
#13
Report Studio / Re: Table of Contents with hyp...
Last post by ClaytonMercer4518 - 31 Oct 2026 12:12:50 AM
A clickable table of contents with hyperlinks to specific report pages makes navigation much easier and helps readers quickly find the information they need.
#14
Administration and Security / Re: EveryOne and access for po...
Last post by bobr12 - 20 Oct 2026 03:31:32 AM
Found the issue.
There are 2 PAL servers on one CAS. So if user is in some groups of one server and in no groups on the second he can come in the second with rigths of EveryOne

If you delete user from all groups he can't enter at all on portal and consequently on any PAL server
#15
Reporting / Bursting
Last post by Good Friend - 19 Oct 2026 10:53:23 PM
Hello Friends,

Has anyone implemented Cognos bursting with the following requirements?

Dynamic file naming: Generate different Excel filenames based on the burst recipient or Org ID.

Blank report delivery: Even when there is no data for a particular Org ID, the recipient should still receive a blank Excel report (with column headers), provided the burst key matches between the burst query and recipient query.

What I've tried: For dynamic file naming, I created a calculated data item in the report query by concatenating the Org ID and Report Name. I then used that data item as the Label under Burst Groups in Burst Options, but it didn't change the generated Excel filename.

Has anyone successfully implemented either of these requirements using standard Cognos bursting, or is additional customization needed?

Any suggestions or workarounds would be appreciated. Thanks!
#16
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
#17
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.
 
 
__________
#18
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?
#19
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])
#20
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?