Hello All,

Quick question about a customized data item in my Cognos report that uses Case When function, the logic is as below:

CASE WHEN (Field A = 'Value 1')
THEN 'Pass'
END

For this data item, I wanted to look for field A which could have multiple values entered, Value 1, Value 2, Value 3, etc... and only those records that have their field A with an entry of Value 1, would display a "Pass" in the output. However, I realized that without specifically defining an ELSE condition in the Case When statement, it defaults as "ELSE NULL" so for those records with Value 1 in field A, it generates an extra blank row in the output, like this.

Record Number   Field A Yes/No
Record 1       
Record 2
Record 3        Pass
Record 3
Record 4
Record 5        Pass
Record 5

Because for Record 3, and Record 5, they both had multiple data entries into field A and only one entry was Value 1, so the Case When function checks Value 1 and outputs a Pass as a row, but then because there's also Value 2 so it outputs an extra blank row. My question is, how do I modify the logic to avoid generating the extra rows for Record 3 and Record 5?

First post here and thank you for your help in advance!
 

This topic has been merged into Cognos Installation on Azure VM.

Quote from: srini.madhala on 03 Nov 2025 06:33:35 AMHi All,

I installed cognos 11.2.4 FP6 on azure VM, tried configuring content, audit & notification store and while trying to start cognos services it throws an error:
"CFG-ERR-0106 IBM Cognos Configuration did not receive a response from the IBM Cognos service in the time allotted.
Check that IBM Cognos service is available and properly configured"

Checked with IBM, IBM suggested to disable antivirus and install and also asked to check if the ports are blocked.
I checked 9300 port is connected.

Any suggestions to overcome this issue please.

Regards,
Srini.

Have you looked through the cognosserver.log log file to see what is happening? It's likely there are other errors before this one that might help you pinpoint what is causing the issue.

Cheers!

MF.

What environment?  (production or non-production) - Non Prod
What kind of Azure VM?  Azure Native or AVS?  Maybe not an issue because I'm assuming that at this point you're using an Analytics Administrator license to stand up a dev box.  IBM allows licensing Cognos for Azure Native using the standard PVU licensing.  IBM considers AVS being "soft partitioned".  With a PVU-based license model, you would need to purchase enough licensing for every CPU in the cluster.  Considering this is Microsoft Azure, that may be thousands of CPUs. - Azure Native.
How many virtual CPU cores? -8 vCPUs(Standard_D8ds_v4)
How much RAM? - 32 GB
What OS? - Windows Server 2022 Standard
After the message appeared in Cognos Configuration, what happened after you waited another 30 minutes?  Did Cognos start successfully? - Cognos start button is greyed out and restart and stop buttons enabled. But it still show - "CFG-ERR-0106 IBM Cognos Configuration did not receive a response from the IBM Cognos service in the time allotted.
Check that IBM Cognos service is available and properly configured"

However while i try to launch cognos, dispatcher is still initializing error -

https://www.ibm.com/support/pages/dpr-err-2109-dispatcher-cannot-service-request-time-dispatcher-still-initializing

When saving a schedule today I got a warning message I have never seen:

QuoteUpdate schedule

If you click OK, the time zone for this schedule will change to your time zone. To close the schedule without changing it, click Cancel.

I don't see anywhere to set the time zone for a schedule.
Is this message because I just changed from Daylight time (PDT) to Standard time (PST)?
Does this warning really mean nothing?

This is a slightly different question, but I'll respond here because it looks like I missed the initial question I can provide different details.

The original question lacks detail.  What kind of audit?  Was this for an IBM license compliance audit?  Or was it a security audit by your local cybersecurity office?

...and what are your needs?  Are you providing reporting through Cognos to the entire planet?

If you use Cognos only internally...
License compliance:  Remove Everyone from the System Administrators role.  Add users and groups to roles and groups as appropriate for your needs.
Security compliance:  I would not disable the Everyone group.  Just remove it from all other groups and roles.  In my case, I had initially added Everyone to Analytics Users to match our license structure.  After discussing with my cybersecurity folks, I added Authenticated Users and removed Everyone.

The new question also doesn't provide enough information.  What are your needs?  I use Cognos only internal to the organization.  So I removed Everyone and Anonymous from all roles and groups.  But if you want to expose Cognos externally (on the Internet) and want users to not need to log in, you'll need one of these groups for that.

I don't know about "not provided" appearing as your profile.  That's probably a question for IBM Support.

You didn't provide enough information.

• What environment?  (production or non-production)
• What kind of Azure VM?  Azure Native or AVS?  Maybe not an issue because I'm assuming that at this point you're using an Analytics Administrator license to stand up a dev box.  IBM allows licensing Cognos for Azure Native using the standard PVU licensing.  IBM considers AVS being "soft partitioned".  With a PVU-based license model, you would need to purchase enough licensing for every CPU in the cluster.  Considering this is Microsoft Azure, that may be thousands of CPUs.
• How many virtual CPU cores?
• How much RAM?
• What OS?
• After the message appeared in Cognos Configuration, what happened after you waited another 30 minutes?  Did Cognos start successfully?

I see this message every time I start my underpowered dev box.  (Azure Native, 2 CPU cores, 16 GB RAM)  Then I wait for Cognos to start completely and it runs fine, just slow.

Hi All,

I installed cognos 11.2.4 FP6 on azure VM, tried configuring content, audit & notification store and while trying to start cognos services it throws an error:
"CFG-ERR-0106 IBM Cognos Configuration did not receive a response from the IBM Cognos service in the time allotted.
Check that IBM Cognos service is available and properly configured"

Checked with IBM, IBM suggested to disable antivirus and install and also asked to check if the ports are blocked.
I checked 9300 port is connected.

Any suggestions to overcome this issue please.

Regards,
Srini.

Hi All,

I installed cognos 11.2.4 FP6 on azure VM, tried configuring content, audit & notification store and while trying to start cognos services it throws an error:
"CFG-ERR-0106 IBM Cognos Configuration did not receive a response from the IBM Cognos service in the time allotted.
Check that IBM Cognos service is available and properly configured"

Checked with IBM, IBM suggested to disable antivirus and install and also asked to check if the ports are blocked.
I checked 9300 port is connected.

Any suggestions to overcome this issue please.

Regards,
Srini.

Hi,

I'm a newbie in the configuration of SCI.
Have you got a document explaning step by step what to do to configure, like with the anonymous and everyone roles, ...

Thanks

Sorry for my bad english