Stack Overflow
Stack Overflow

Questions tagged [cognos-8]

Cognos Version 8 is a reporting tool from IBM used widely for Business Intelligence.

Any question related to Report Studio, Query Studio, Analysis Studio, Metric Studio, Metric Designer, Event Studio, Framework Manager, PowerPlay Studio and Analytic Applications in Cognos 8 and above. Cognos is IBM's business intelligence (BI) and performance management software suite. The software is designed to enable business users without technical knowledge to extract corporate data, analyze it and assemble reports.

About Cognos Cognos is composed of nearly three dozen software products. Because Cognos is built on open standards, the software products can be used with relational and multidimensional data sources from multiple vendors, including Microsoft, NCR Teradata, SAP and Oracle.

The Cognos 8 BI suite, which was first introduced in 2005, is IBM’s leading performance management software. Cognos 8 BI’s capabilities include reporting, analysis, dashboarding and scorecards, delivered through a web-based service-oriented architecture (SOA).

In October 2010, IBM released Cognos 10, which integrates Cogos with other IBM products, including SPSS Predictive Analytics and Lotus Connect. Cognos 10 comes with mobile capability, allowing users to access a complete version of Cognos from mobile devices such as tablets and smartphones.

IBM also offers Cognos Express, which is designed for small to mid-sized companies. The Express edition allows companies to utilize the functions of Cognos 8 BI, while also adding planning, budgeting, and forecasting functions.

IBM’s Cognos products are used by over 23,000 companies around the world, and are consistently ranked in the “leaders” category of Gartner Magic Quadrants for Business Intelligence.

149 questions
1
vote
2 answers

Cognos equivalent of Excel Sumif() function without a static variable

Here is the following example that I found that does work as a sumif function. total( case when [free of charge flag] = 'FALSE' then [Total Margin] else null end for [Item Code]) My question is how to replace the 'FALSE' portion…
C.Penrod
  • 11
  • 6
1
vote
1 answer

Query in COGNOS (Report Studio)

I have this follow query; the objective is to filter this query by day. I will use this same query, but now a month. How to do? WITH DATAS(DATA_CALC) AS( SELECT DATE(#prompt('DataIni')#) AS DATA_CALC FROM SYSIBM.SYSDUMMY1 UNION ALL SELECT…
chewie
  • 333
  • 2
  • 3
  • 19
1
vote
2 answers

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 options like extract(year, sys_date)*100 + extract(month, sys_date))*100 cast(extract( year, sys_date), varchar(4)) + cast(extract(…
Excited_to_learn
  • 361
  • 3
  • 11
  • 25
1
vote
1 answer

Difficulty in performing Addition in query calculation in Cognos Report Studio version 10.2.1

I am trying to perform 'Addition' function for three columns horizontally in Cognos Report Studio version 10.2.1 For eg: I want the output to look like this Col1 |Col2 |Col3 |Col4(Calculated Col) 12 |16 |10 |38 1 |5 |2 …
Excited_to_learn
  • 361
  • 3
  • 11
  • 25
1
vote
1 answer

cognos: database view and business view

as fas as I know, in Framework Manager, the first step to build the database view. In the second step: is to build business view why they done? what is the difference between the two?
user3327547
  • 11
  • 1
1
vote
2 answers

Dynamic Query Item Used for Sorting

I'm using Cognos Framework Manager and I'm creating a Data Item for a dynamic sort. I'm creating the Data Item using a CASE WHEN, here's my sample code: CASE #prompt('SortOrder', 'string')# WHEN 'Date' THEN WHEN 'ID' THEN
Erick Garcia
  • 832
  • 2
  • 12
  • 29
1
vote
1 answer

Cognos - Crosstab report broken out by DateRange (week starting on Sunday)

I've been working on this a while and I haven't found too much on the web to help so hopefully someone can assist. I'm using Cognos 8.4.1 with SQL Server as a data source. I have a date field that holds date and time. Our client would like to see…
Amanda Brine
  • 311
  • 2
  • 4
  • 13
1
vote
1 answer

passing Jan of selected year by default in prompt

I have 2 year-month prompts. If I don't select any year-month in 1st prompt, report should by default, run from January of the same year, selected in 2nd prompt. My prompts are value prompts and have string values. Please help me materialise the…
Rashmi
  • 11
  • 2
1
vote
0 answers

Getting JS Errors When Using jQuery in Cognos Report

I am using Cognos 8.3 and am trying to incorporate jquery/jquery ui into one of my existing reports. I have an HTML block on the page with the following:
Dan Appleyard
  • 7,405
  • 14
  • 49
  • 80
1
vote
1 answer

Display 0 values as 0 instead of \0 in CSV files in Cognos reports

I am trying to run a CSV report in Cognos and it is displaying 0 values as \0. Could someone let me know if there is any way of displaying it as a 0. I tried to change the properties in Data Format but nothing works
user2063055
1
vote
0 answers

How to add complex header/footer to list report in Cognos?

I want to build a list report with complex footer and header, the issue is: if the column number of footer is bigger than the list body.it seems difficult to add more column to the footer. If I add list footer, the column number is just as same as…
Tom
  • 2,857
  • 9
  • 46
  • 59
1
vote
2 answers

Validation of date using Javascript in cognos

When the users select the To Period as < From Period then an error message should be thrown to select a period >= From Period When the user selects more than 12 months then a warning message should be displayed as "The report will take more time…
Raj
  • 21
  • 2
  • 5
1
vote
1 answer

Date Prompt in Cognos Report

I'm a Cognos Developer and I'm having a trouble about "Date Prompts". I have a "Date Prompt" with the option "Edit box" selected in the "Select UI" and I want when the user change the chosen date an onchange event fires. Now I'm using JavaScript…
e.longo
  • 11
  • 2
1
vote
0 answers

How to change the tooltip text dynamically in cognos charts

I have an issue in cognos chart , I have placed a data item in the chart series and name it criteria. The data item contains a case statement when (Metrics = 7) then ([Ace]) when (Metrics = 5) then ([Effort]) when (Metrics = 9) then ([Defect])…
Raj
  • 13
  • 1
  • 6
1
vote
1 answer

Use summary data in row calulations on a report?

I am using Cognos Report Studio 8.4.1. I have a list report where I want to use a query calculation to create a new column of data, but the calculation needs two numbers from the summary (subtotal) of the data I want to do the calculation for. Is…
Kaine
  • 113
  • 1
  • 8
1 2
3
…
9 10