Quote from: bus_pass_man on 10 Nov 2025 06:22:31 AMSince you have not documented the nature of the data I can't provide much guidance other from my surmises based on the usual patterns.

I really don't think I have encountered a situation where an expression would return multiple rows due to an expression when there are only one record for an entity.

I think it possible that there are multiple records for entities in your db.  You would need to know this. Knowing the nature of the data and the metadata would determine how to approach the problem, which would require you to step back and not seek some method to tweak your expression but to seek to define the problem more clearly.  One thing you would need to do to accomplish this would be to understand the nature of your data.

I think it possible that, given the likelihood of there being multiple records for any particular entity, you are seeking to have your report return the latest record for an entity, where the value of a column is some condition.

It is possible that the time state of a particular record is captured in a column. 

If so, there is the possibility that the latest record could have a value which is not (as in your case) 'passed'. It is not clear what you want to do in that case.




----

I think your situation deals with two common patterns of behaviour.  The first being a report author trying to model.  This sort of calculation should be better dealt with in the model or, even better, during ETL.  The second being an over-abstraction of the problem as data has semantic meaning which would partially define the bounds of the problem.

Thanks for the response! Sorry I wasn't being very clear about the description. So for the source data, in the DB, field A for every single record (case), could have 0 entry, 1 entry, 2 entries, etc. Take field A as "Physical Test Date", and if a person did a test there would a date entered as value 1, and then another test on a different date as value 2. My function is looking for all the people that did a test on a certain date (value 1) and output their records (rows) as "Pass". But my Case When function, it seems like because person A has other test dates than value 1, so it outputs 1 row as Pass but another row as blank.

Thanks all!  The previous posts were very helpful to create this query for our Content Store on SQL Server to search the report XML (spec) for the occurrence of "sqlText" which indicates a manual SQL object in the report and return the Report Name and Path.  Set Content = 'report' (Dashboards and Analysis do not have Manual SQL) and set the Path to a target folder or all of Team Content by adjusting path like 'Team Content\Consumer Products\%' in the query below to customize for your search criteria.

/****** Script for Reports with Manual SQL Queries command from SSMS  ******/
With CognosContent AS (

Select a.CMID, a.PCMID, b.NAME, b.Name as Parent, c.name as Content

,Cast(b.NAme  as varchar(max)) as path

, 0 as level

from cmObjects a

inner join CMOBJNAMES b on a.CMID = b.CMID

inner join CMCLASSES c on a.CLASSID = c.CLASSID



Where b.ISDEFAULT = 1

and a.PCMID =0

and a.CMID = 2



UNION ALL

Select a.CMID, a.PCMID, b.NAME as parent, d.NAME, c.NAME

, d.path + '\' +  CAST (b.Name as varchar(Max))  as path

, d.level + 1 as level

from cmObjects a

inner join CMOBJNAMES b on a.CMID = b.CMID

inner join CMCLASSES c on a.CLASSID = c.CLASSID

inner join CognosContent d on a.PCMID = d.CMID

Where b.ISDEFAULT = 1

)

Select CMID, NAME as ReportName, path, level, content from CognosContent

Where

Content = 'report' --or Content = 'dashboard' or content = 'analysis'
and path like 'Team Content\Consumer Products\%'
AND CMID IN ( SELECT DISTINCT CMID FROM ( select S.CMID, try_convert(xml,s.SPEC).value('count(//*[local-name()="sqlText"])', 'int') CustomSQL

from CMOBJPROPS7 s where s.spec is not null ) A WHERE A.CustomSQL>0 )
order by path

Since you have not documented the nature of the data I can't provide much guidance other from my surmises based on the usual patterns.

I really don't think I have encountered a situation where an expression would return multiple rows due to an expression when there are only one record for an entity.

I think it possible that there are multiple records for entities in your db.  You would need to know this. Knowing the nature of the data and the metadata would determine how to approach the problem, which would require you to step back and not seek some method to tweak your expression but to seek to define the problem more clearly.  One thing you would need to do to accomplish this would be to understand the nature of your data.

I think it possible that, given the likelihood of there being multiple records for any particular entity, you are seeking to have your report return the latest record for an entity, where the value of a column is some condition.

It is possible that the time state of a particular record is captured in a column. 

If so, there is the possibility that the latest record could have a value which is not (as in your case) 'passed'. It is not clear what you want to do in that case.




----

I think your situation deals with two common patterns of behaviour.  The first being a report author trying to model.  This sort of calculation should be better dealt with in the model or, even better, during ETL.  The second being an over-abstraction of the problem as data has semantic meaning which would partially define the bounds of the problem.

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.