Top "Cognos-10" questions

Cognos is an IBM subsidiary which provides a range of business intelligence and performance management products.

IBM Cognos Report Studio: Value prompt default selection from prompt "default text" parameter

I have a value prompt that references the parameter 'Year_Parameter', and a list with one column (a Data Item …

Read More
cognos cognos-bi cognos-10
Converting a Date Format to YYYYMM in Cognos Report Studio

I have a date column in a format 12 May, 2014 I want to convert that into yyyymm/ 201405 format. i tried multiple …

Read More
sql datetime cognos cognos-8 cognos-10
Automatic filter for current month and year in Cognos Report Studio ver 10

I have a query item which filters records by a date column which is in format 'YYYYMM'. As of now …

Read More
cognos cognos-8 cognos-bi cognos-10
Using Case Function to make NULL values appear as blank

I keep getting error that my Case Function is incorrect. My goal is to use the Case Function to make …

Read More
cognos-10
Convert a column that has a data type of integer into date in Cognos report studio

I have a column that appear like this and the data type is integer. I get that data from AS400 …

Read More
sql-server datetime cognos-10 cognos-bi
Cognos equivalent of excel's sumif() function

I'm familiar with Excel and SQL, but new to Cognos. I'm doing a conditional sum on [Total Margin] for each […

Read More
cognos sumifs cognos-8 totals cognos-10