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

#1
General / Re: How Do You Usually Bring I...
Last post by cognostechie - 30 Aug 2025 06:48:52 PM
My idea is that you have to use all methods of marketing. One might be better than the other but all channels should be used. There are companies who sell information of which company uses which software. Dun & Bradstreet is one of them. Global Software Leads is another. YouTube and other media can also be used. Users forums also. 
#2
Reporting / Re: Cognos Images
Last post by dougp - 26 Aug 2025 10:27:41 AM
I would think that "../images/" leads to <CA Install>\images.  But that wouldn't work because images should be in <CA Install>\webcontent\bi\images.

I remember Cognos having trouble with images years ago.  I'm not 100% certain how (or if) I completely fixed it.  But it seems that presenting images in PDF and XLSX outputs is what the new Image Service is all about.  Have you tried that?
#3
Reporting / Re: Is it possible in a report...
Last post by dougp - 26 Aug 2025 10:11:03 AM
You can create a filter based on any data element available to the report.
#4
Reporting / Is it possible in a report to ...
Last post by jonathan.brotto@imperiald - 25 Aug 2025 03:48:42 PM
I have experience with other tools and was wondering how to filter a report by date.
#5
General / How Do You Usually Bring In Ne...
Last post by lukwiso - 19 Aug 2025 03:29:58 PM
I'm curious how people in different industries go about finding new leads. Do you mostly run ads, rely on word-of-mouth, attend events, use social media, or something else? I figure every niche has its own way of doing things, so I'd love to hear a mix of ideas.
For me, I've been experimenting with a few options this past year. One that worked well was BestMovingLeadsProviders.com, which is geared toward the moving industry. The leads I got were pretty solid, and I noticed both the number and quality of inquiries improved quite a bit.
Has anyone else here tried using a third-party lead provider? Did it end up being worth it, or did you find other strategies that delivered better results?
#6
Administration Lite / Re: Reports getting stuck in P...
Last post by Kavya - 18 Aug 2025 01:40:59 PM
Hello All,

I have Cognos 11.1.7 instance running on Linux server for about 3 years now. I have 39 scheduled reports that are scheduled to email like daily/hourly/weekly. All these scheduled reports were running as expected until last 2 weeks. Since Start of this month, we are seeing many reports getting stuck in Waiting/pending status. If we have a report scheduled to run hourly, for example 9 AM report gets stuck in waiting/pending status. But 10 AM report runs fine and sends email to users. This is sporadic. Today, I have created a new report and add it to the schedules. But I do not see this report in "Upcoming Activities". I tried restarting complete Cognos services, nudging Batch report service. Nothing worked.

Does anyone have any idea or solution for this issue ?

Thanks.
#7
Reporting / Cognos Images
Last post by jburchill - 18 Aug 2025 12:01:24 PM
Hello all, I am having issues getting the images to work.  I created a Virtual directory on the IIS server with webdav enable and authored the permissions like I've found on the internet.  I can get the image to show in html, but it doesn't work on PDF or Excel.

Any thoughts on this?

Also, where does "../images/" lead to?  I have yet to figure that out.
#8
Agreed that for the complex reports, both would need technical developers but Power BI still scores on easier reports for which the users don't need technical knowledge. The interface is much more user friendly for easy stuff. They prefer to make 4 easy reports instead of one complex report in Cognos giving them their independence. 
#9
Administration and Security / Cognos Analytics Assistant
Last post by dougp - 15 Aug 2025 04:39:07 PM
One of the new/improved features of Cognos Analytics 12.0.4 is the AI Assistant.  And I know that my management team is chomping at the bit to use any new AI feature that becomes available.

So I thought I'd try using these features.  Blocked!  "This data source has not been enriched."

Looking at the manual option for enriching a package, it looks like all I can do is tell Cognos which columns are date/time or location.

What I was hoping for is that my users can ask natural language questions of packages containing thousands of columns of non-trivial data.  So a user might ask a simple question like, "Show me expenditures by month for the last biennium for job number XE343401."

So, Cognos would need to know:
  • A job number is WorkOrderGroupNumber or WorkOrderNum + GroupNumber.
  • Expenditures could be called Expeses, Expended, Actual, etc.
  • "last" biennium is 2023-2025.  The 2023-2025 biennium is the same as the biennium with begin year 2023 or the sum of FY2024 and FY2025.  Also relevant, for system load and query performance reasons, is that since the user is asking for only one biennium of financial data, using the biennium begin year column on the fact table will help because that is how the database is partitioned.  You get a query performance improvement of 2x to 40x if you craft the SQL properly.
  • There are 24, 25, or 26 "months" in a biennium, depending on whether the employee works primarily with budget, program management, or accounting subjects.
...and when the user is asking for months from financial data, they are not asking for something that is really date/time data.  They are fiscal periods, not really months.  But they still need to be presented in the correct order, and there may be a need to forecast even though it is not considered time-based data (since only accountants - and not the Cognos devs - think there are 13 months in a year).

I do have available to me a data catalog that maps business terms to data objects.  So that could help.

How do I feed synonyms and other relevant vocabulary and business relationships to the AI?
#10
Seems like that on the surface -- attending training asking trivial questions against trivial data.  But when the business user needs to answer a real-world question using actual data...  How many end users do you think will become experts in DAX and M?