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
2
votes
1 answer

What is the difference between Query Studio and Report Studio in Cognos?

What is the difference between Query Studio and Report Studio in Cognos? Could anyone explain me in detail? Thanks in advance.
arunpandiyarajhen
  • 643
  • 12
  • 20
  • 51
2
votes
1 answer

Could I execute multiple expressions when a single condition is true in case..when statement in SQL?

I wanna display multiple statements when a single condition is true in case..when statement in SQL. Eg: case when (condition is true) then print "A" print "B" . . . . print "Z" when (condition2 is true) then print "Z" print "Y" . . . . print…
arunpandiyarajhen
  • 643
  • 12
  • 20
  • 51
2
votes
2 answers

How do I escape the # character in Cognos?

I have created a pass-through Query Item in Cognos 8 Framework Manager that requires the # character as part of the query. Unfortunately this gets interpreted by Cognos as the opening of a macro. How do I escape the # (number sign/sharp) character…
Robert Davis
  • 2,255
  • 2
  • 21
  • 21
2
votes
1 answer

I want to edit my decimal number.How I give it pattern?

I want to give a pattern in cognos. like this my number : 12.20 my wanted number : 12.2 i want to delet 0 how I give pattern.
user1474138
1
vote
2 answers

IBM Cognos IF/casewhen + _days_between

I have a liste of value and when a value = something i want it to calcultate a number of day between 2 dates. Error: "QE-DEF-0459 CCLException Incompatible data types in CASE statements" Exemple: CASE WHEN ([Statut dossier] = 'Att 1 sv') THEN…
sophie morin
  • 13
  • 2
1
vote
2 answers

Cognos Report Studio: CASE and IF Statements

I'm very new in using Cognos report studio and trying to filter some of the values and replace them into others. I currently have values that are coming out as blanks and want to replace them as string "Property Claims" what i'm trying to use in my…
jiwon chang
  • 21
  • 2
1
vote
1 answer

Join and max date with null values

I need to return the most recent (max)date for a patient_ID where a vital value exists - it's not simply the max. encounter date for the patient_ID, it must have a corresponding vital value. I also only want encounters where vitals value <>'' and…
RNH_2021
  • 13
  • 3
1
vote
0 answers

Migrating Reports From Cognos8 to SSRS Report Builder 3

My company is beginning to migrate from Cognos8 to Microsoft SQL Server Report Builder 3, and we have some very complex reports within Cognos8 that need to move across. I have seen mentioned online that using the XML from the Cognos8 report, you can…
MikeLanglois
  • 25
  • 7
1
vote
1 answer

Continuous dates in Cognos

I need some suggestion to generate a continuous dates in between a specified selected date range in Cognos. I can create a separate Data item for this but I don't know what to do after that. Looking for a quick help
user9204747
  • 13
  • 2
1
vote
1 answer

Is it possible to pass parameter in the cognos by SQL?

I am having SQL query as "select * from all_objects where owner = : owner;". Can it be possible to create prompt with this query in cognos 10.2.2.Please suggest me.
lucky
  • 25
  • 1
  • 6
1
vote
2 answers

removing duplicates in cognos 10 based on non duped column/field

The report below produces the id, name, primary (whether the user is the primary user or not (Y or N) and the date the user joined. I don't want any duplicate id's in the report and I want to base the condition to remove dupes on the primary column.…
chase_33
  • 11
  • 1
  • 3
1
vote
0 answers

How to write the below function in cognos FM(filter)

EXISTS (SELECT 1 FROM Common.Com_macss_Account a WHERE COM_MACSS_PREMISE.prem_nb = a.prem_nb AND a.ACCT_TYPE_CD IN ('E', 'EO') ) The above expression is in BO(Universe). Need to write it in cognos FM (Filetr). Tried CASE statement but didn't…
Maggie 14
  • 11
  • 1
1
vote
1 answer

Cognos Report Studio: Display search terms and options from select and search prompt in a report

Is it possible to display the search terms and option selected by the user from a select and search prompt? Ideally the customer wants to enter these on a prompt page and then have them displayed in the report output. Further Detail: The customer…
james.mullan
  • 149
  • 2
  • 3
  • 16
1
vote
0 answers

Converting Cognos Reports to SSRS Reports

I am writing a Java code to convert the Cognos report file(.xml) to SSRS report file(.rdl). If anyone can guide me how to convert listGroups and sortList of Cognos to of SSRS. …
Shubham Mehta
  • 81
  • 1
  • 7
1
vote
0 answers

Cognos - data item for retrieving a hard-coded data not working

I have a data item that pulls a list of static historical data for the employee headcount upon request, it is a double-nested case statement with hard-coded number for our historical data and the query looks like this: CASE ([Year]) WHEN…
Green Demon
  • 4,078
  • 6
  • 24
  • 32
1
2
3
…
9 10