The question external monitoring can be answered with JMX: https://www.ibm.com/docs/en/cognos-analytics/11.1.0?topic=metrics-monitoring-system-externally

What RDBMS?

For SQL Server:
[Study Error Message] like '[a-zA-Z]-%'
For MySQL (and maybe Oracle):
REGEX_LIKE([Study Error Message], "^[a-zA-Z]-.*")

Hello -

Cognos does not do a good job of saving those outputs.
Everything you are doing seems correct - then Cognos deletes them from the Content Store.

That is why we created a Module in MetaManager for it "Content Extractor" It saves the outputs to a file system and then you can switch the retentions to whatever number you want, and Cognos will delete all the outputs that are more than X number you have set.  Obviously if it is set to 0 it saves them forever.
You can also save the outputs and other content in a MetaManager Backup Module for later restoring options.   

Got it.  I missed a step.  You don't leave it blank, you leave it at the default.  So you'd schedule it with an end date of 1901-01-01.

For the field to have numeric as well as alphabets, the data type has to be char/varchar/string.

Even in a character data type, 1 till 9 is considered lower than A so try:

[Study Error Message] >= 'A-'

If that doesn't work then try:

 substring([Study Error Message],1,1) not in ('1','2','3','4','5','6','7','8','9') and
 substring([Study Error Message],2,1) = '-'

I'm trying to filter rows in a v11.2.3 report to include content based upon just the first character of a string.  However, I know that my data can include any numeric or character value; and, I'm really only interested in filtering to include a single alpha character followed by a dash and then the rest of the string is irrelevant.

I've tried this...

  [Study Error Message] like '_-%'

...but I get rows that include values like "1-" and "2-" as well as "A-" and "B-".

Is there a different wildcard I can use instead of an underscore to exclude the numeric values?

Thank you kindly.

No. If there is a default date specified and no date is entered then the default value will be considered and in that case the filter will work and the result will be data only till the current day.

Except that the date must be required.  If the date filter is optional, the date prompt is optional and using the "edit box" UI, and no value is entered, the result is all rows.

This should work:
[Date]= #prompt('End Date', 'date', 'current_date')#

Hello Everyone,

Can you help me with the following issue:
Query Service's Current heap size allocated 95% of memory while admin console does not show any Background or Interactive activities. How to understand what consumes so much memory?  What is the cause of the issue?

Quote from: krishdw85 on 10 Sep 2024 12:23:26 PMHi Team,

i have a start date & end date in my report and whereas start date is static and end date should be always current date as per scheduled which is tuesday in my report.
I somehow unable to recall how to set  default slections in cognos 10.2  Can someone advice how to set end date as current date for default prompt in scheudle.

Regards,
Krish

There is a property of the Date prompt where you can put a default selection. Put 1901/01/01 there. In the query, put a filter like:

( ?EndDate? = 1901-01-01 and [Date] = current_date)
                     OR
( ?EndDate? <> 1901-01-01 and [Date] = ?EndDate? )