Hi, I have a crosstab and I have a column that is showing the totals for the year of the members in the different rows.

For example, I have in the rows cars, tables and chairs.
There is a column showing the sales for those products for example for the whole year.

Then I have a prompt value with the months. So if I select august, in another column it is showing the sales of august.

But I want the first column to still show the total of the year ignoring that filter of month.

If anyone could help me please. I have tried different ways but selecting the month it changes also the first column.

Thank you!!

I have (2) calculated fields in a data source that is the sum of multiple columns in dollars.    When I place these 2 columns in a report, it will show the row if there is a value greater than zero in either column.  If both columns are zero, it omits the row completely.  I've tried all different ways including a calculated field and a query calculation.  Any idea on how to fix this?

Thank you very much bus_pass_man for your reply.
I have one question please.
I have checked the relationsships (joins) and they are all related, but where to check in Framework Manager the relation level in each dimension with the facts?

I am lost there and not sure how to check it.

Thank you very much

Quote from: bus_pass_man on 03 Apr 2025 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 03 Apr 2025 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.