Quote from: bus_pass_man on Yesterday at 05:53:45 PMif ( PRODUCT_LINE_CODE  = 991)
then ('')
else ( cast (PRODUCT_LINE_CODE, varchar(4) ))

Maybe something like this?

Quote from: bus_pass_man on Yesterday at 05:53:45 PMif ( PRODUCT_LINE_CODE  = 991)
then ('')
else ( cast (PRODUCT_LINE_CODE, varchar(4) ))

Maybe something like this?

That was easy!!! Thanks!!! I appreciate you

if ( PRODUCT_LINE_CODE  = 991)
then ('')
else ( cast (PRODUCT_LINE_CODE, varchar(4) ))

Maybe something like this?

I'm trying to do a "simple" case statement to make two fields(Last Name and DOB) in my output show blank for a specific Member ID.

Here is the one that works....

CASE
WHEN [Report Query].[MEMBER ID] = 12345
then ' '
else
[Report Query].[LAST NAME]
end

[MEMBER ID] is an integer
[LAST NAME] is a string

Here is the one that won't work:

CASE
WHEN [Report Query].[MEMBER ID] = 12345
then ' '
else
[Report Query].[DOB]
end

[MEMBER ID] is Integer
[DOB] is dateTime

I googled and found that I have to cast and ive tried casting both fields to VARCHAR(10) and other formats without any luck. Anybody have any input? Can I do the casting right in the statement or do I cast the data item first then use that in the CASE statement? If anybody can send along how the statement should look that would be great. FYI - I didnt have to CAST either field in the first example TO blank out LAST NAME.

The textbox prompt has a multi-line property

How many CPU cores?
How much RAM?
How many concurrent users?
What version(s) of Windows Server?

I have a report consisting of financial transactions. I'd like to allow the user to enter several values, and then filter the report to return results where any of those values are contained in the [Description] field.

I'd like to have the user type them into a text box. I've tried a single textbox with the user entering words with a delimiter, such as 'word1;word2;word3'. I've also tried a multi-select enabled textbox, and multiple text boxes.

I thought the simplest would be to have 4 textboxes. The problem I run into is if I use multiple text boxes, I can't figure out how to make the filter work but also not have all text boxes as required. I set them as not required on the prompt page, but the filters I try make them required anyway.

My objective is to allow the user to enter up to 4 keywords to search for in the description field. If they only enter 2, I want to only return results containing one of those 2 and disregard the other 2 empty text boxes.

Is this possible? Any help is appreciated!

Using Cognos 11.2.4 and MS SQL Server database.

I am running CA 12.03 with a distributed windows server environment on virtual machines. It seems once users start using the system the java process is over 70 and even into the 90s for CPU utilization. Memory usage is between 30 and 40 percent. Once the number of users drop down under 10 the java.exe for the dispatchers doesn't drop down. If I change the active Content Manager to a secondary content manager the java processes on the dispatchers drops below 10% and will increase over an hour or so. Also, if I stop one of the two dispatchers this will clear the processing. I do not have any scheduled jobs or DQM in use. My logging is minimal or basic and the logging ports are unique. The reports that do run on demand are quick lees than a minute. I have also confirmed my virus software is not scanning the Cognos folders.

Has anyone seen this behavior before? Maybe a setup with my VM? Any suggestions welcome.

If you're working with a bunch of files and need to automate changes, scripting is your best bet. I've had to deal with similar issues when merging and editing multiple video clip. It's frustrating when everything is all over the place. What helped me the most was finding software that let me edit and piece everything together in one go without too much manual work.

Good Afternoon Cognos Gurus,

This is happening in Cognos v11.2.3.  Unfortunately, I don't have any experience with this function from any prior Cognos releases because this is the very first time I'm trying to use it.

First off, I am a senior level Report Author presumably with significant Cognos accesses assigned to me by some Administrator long ago.  I don't experience the following symptom myself using my routine Window login but other lower-level Cognos users do.

Here is the situation and symptom:
1.  I authored a report.  It is stored in a Teams folder that everyone has access to.  The report contains no prompts.
2.  I used the routine Share function within the Teams Content folder to copy the URL which points to that report uniquely. 
3.  I can successfully use that URL to launch directly to that report using either a desktop shortcut or from an MS Edge browser from the Cognos Production Server or from other servers or workstations.
4.  We use single-sign-on so in either of those instances, I am not interrupted with a Windows login nor a Cognos login.  The report simply renders.
5.  However, when I have other less powerful users attempt to launch using the same URL (via shortcut or browser), more-often-than-not Cognos stops the user and prompts for login.

All users who are testing - and getting this inconsistent but frequent result of the unintended interrupting Cognos login prompt - have already authenticated with Windows login and can successful run and render the report from where it is stored in the Teams folder once they login to Cognos.  I know it sounds crazy but the interrupting login prompt doesn't appear consistently for anyone - some users can launch directly to and render the report just like I can.  At other times, the same users seem not to be able to launch the same URL without being prompted for Cognos login.

Can anyone suggest what settings might be impacting the ability for the report URL to take advantage of single-sign-on and bypass the Cognos login?

Repeating values such as that will happen if the query is being projected below the fact grain.   

I think you would need to confirm what dimensions have relationships to your fact and to what level in each dimension.

For example, assume you have a time dimension consisting of years, months, and days.  Assume that you have a fact table which consists of facts which exist at the day level.  Assume you have another fact table which consists of facts which exist at the month level.  Cases like this are scenarios such as actual values versus planned values.  If you tried to have a query with a month-level fact and days you will get repeating values.  If you have correctly modelled, the summaries should not double count.