If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Problem with CASE Statement

Started by KEKeogh, 13 Apr 2010 03:47:31 PM

Previous topic - Next topic

KEKeogh

Everything I see says I'm doing this right but I keep getting dashes (--) in the column.

I have the following CASE Statement.

CASE [DSR].[VIEW_APPLN_AVAIL].[APPLICATION_NAME]
WHEN 'ADR' THEN 'Khurana'
WHEN 'Aegon Checkfree' THEN 'Keller'
WHEN 'Avg Cost' THEN 'Khurana'
WHEN 'AWD' THEN 'Khurana'
ELSE 'Unassigned'
END

Aggregate Function = Automatic
Rollup Aggregate Function = Calculated
Column Format = Text

Any help is appreciated.

Kathie

CognosPaul

Aggregate functions will only work with numeric data types, so the rollup aggregate function should be set to automatic or none.

Is this a list or a crosstab?

KEKeogh

Sorry I forgot that, it's a crosstab.

Changing the Rollup didn't seem to work either.  Now instead of getting the dashes, each different THEN option came out as a column header.

CognosPaul

This is probably your problem. Are you trying to put this data item into the measures section?

Put it in either the columns or the rows and it should work fine.

KEKeogh

I'm putting it in between the Column headings but still not working.


CognosPaul

what happens when you put it in the columns? Is it still giving you the '--'? What happens if you put it into a list?

KEKeogh

Not quite sure how I did it but it finally worked.