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
Cognos Analytics / An error while performing oper...
Last post by marsh06usn - Yesterday at 02:35:48 PM
I am trying to do a Union between three queries but keep receiving the An error occurred while performing operation 'sqlPrepareWithOptions' status='-126'.  I am calculating week number by the function week(date) in each of the three queries.  One of the queries seems to be a different type of date than the other two, however, in my mind the function week() should return the same data type.  Nevertheless, I still tried to cast the data items to first integer, then string (using varchar(10)) and numeric.  I still receive the same error.  What is interesting is that numeric doesn't work for one of the data items.

Anyone come across this?  Any advice?
#2
Upgrading to Cognos Analytics / -
Last post by Drissurax - Yesterday at 07:20:05 AM
Thank you very much for the help, Gaurav. Unfortunately, that solution still does not work. I appreciate your help very much though. I understand if its just a lost cause, ha.

With the rapid advancements in AI and analytics, is it possible that IBM Cognos could evolve into a self-aware entity, and what would be the implications for data privacy and business intelligence?
 
Someone sending me in private message me this links, what is it? ( dark market link  dark market url darknet market   )
#3
Reporting / Event Studios - insert hyperli...
Last post by starrynight99 - 17 Feb 2025 05:05:40 PM
Is there a way to insert a hyperlink in an alert using Event Studios? 
#4
ChatGPT / Re: What are you asking ChatGP...
Last post by starrynight99 - 17 Feb 2025 05:01:55 PM
I needed to shorten very long instructions to 150 characters.  Chat GPT did it in 2 seconds what would have taken me hours!
#5
Announcements / -
Last post by Drissurax - 17 Feb 2025 04:16:53 PM
This thread will list all Eternal MU Updates, please visit frequently to get updated.

WEB .= Updates concerning the entire website
x10 ..= Updates concerning the x10 non-rebirth server
x100 = Updates concerning the x100 rebirth server
x1000 = Updates concerning the x1000 rebirth server


Thank you.

With the rapid advancement of big data technologies and AI-driven analytics platforms, is IBM Cognos Analytics equipped to remain competitive, or is it at risk of becoming obsolete? How can the Cognos community ensure it adapts and thrives in this ever-evolving landscape? ( onion dark website  bitcoin dark web dark market onion   ) what is mean? and for what i getting it every day in my PM?
#6
Reporting / Error occurred when retrieving...
Last post by wlewi92 - 17 Feb 2025 02:31:01 PM
Cognos version: 11.2.4 FP5
Windows Server 2019

This is an intermittent issue, reports sometimes (more often than not) do not complete and return the following error, "XQE-JDB-0011 Error occurred when retrieving the database charset."  Other times the same report using the same package and same parameters run complete successfully. I have searched far and wide and haven't found a remedy, can someone point me in the right direction?
#7
COGNOS ReportNet / MOVED: Invite de date
Last post by MFGF - 15 Feb 2025 12:48:19 PM
#8
Reporting / Re: Invite de date
Last post by MFGF - 15 Feb 2025 12:47:57 PM
Quote from: HBROGNIART on 12 Feb 2025 07:54:26 AMComment paramétrer les dates minimale et maxim

In English, your question seems to be asking how to configure minimum and maximum dates? I'm assuming this is for a date prompt? I'm also assuming this is the minimum and maximum dates the prompt will permit?

Typically this is something you can use JavaScript to do. There is a great article from CognosPaul (PMSquare) that describes how to do this:

https://pmsquare.com/resource/blogs/custom-javascript-in-cognos-analytics-date-prompts-and-datasets/

You posted this in the Cognos ReportNet board, but that product has been obsolete for 20 years. I am moving the post to the Cognos Analytics board - assuming this is what you are using?

Cheers!

MF.
#9
Administration and Security / Re: Urgent !! - Cognos 11.0.12...
Last post by MFGF - 15 Feb 2025 12:33:51 PM
Quote from: Lokesh Reddy on 31 Jan 2025 07:10:10 AMHi Cognos Community !

Urgent !!!

One of our On-Prem Oracle Database has been migrated to Oracle Cloud (ADW)

We are in the phase of testing our Cognos Data Source Connection to Oracle ADW.

we obtained tns entries (host, port, service name) for this cloud DB

Below things we have in our Cognos servers.

1) Oracle Client v12.1.0.2

2) ojdbc8.jar (v21.6.0.0.1)


As part of testing, we have created new Data Source Connection in Cognos DEV environment and provided all the connection parameters.

OCI connection is getting succeeded but we are facing challenges for JDBC connection.

Does anyone has idea on how to create Data Source Connection from Cognos v11.0.12 to Oracle ADW Cloud DB ?

Looking forward for your inputs and guidance..

Thanks,

Lokeswara




Hi,

It depends on which version of java you are using with your Cognos install as to which is the correct jdbc driver to download and use for Oracle. If you are using Java 1.5, you need the odbc5.jar driver, and if you are using Java 1.6, you need the odbc6.jar driver.

https://www.ibm.com/docs/en/cognos-analytics/11.1.0?topic=databases-oracle

Whichever Java you have, I assume odbc8.jar is incorrect?

Cheers!

MF.
#10
Reporting / Filter Based on Maximum Total ...
Last post by BANKNOise - 14 Feb 2025 12:19:47 PM
I have a report that aggregates account balances for each customer.  The report includes a column with a maximum query calculation because I want to see the representative that is responsible for handling the customer.  A few of the customers have multiple representatives, so I want another maximum query that reports the representative with the highest aggregate account balance.  When I apply the query, I'm shown the maximum individual account balance instead of the maximum aggregate account balance.

The first expression below is the column I'm using for my max query.  The second expression is my maximum query which reports maximum individual account balances, not the maximum aggregate.  Any ideas on how to resolve this issue?   

case
when = 'S'
then 0
when [Customer Max] > [Account Balance]
then [Account Balance]
when [Customer Max] > 0
then [Customer Max]
else [Account Balance]*[Customer Percentage]
end

maximum ([Balance] for [Customer])