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

How to use a calculated data item in a chart in cognos?

Currently I'm working in Cognos 10.1 and I'm facing this problem. I've a data item (date) and using that I've calculated the day of the date (i.e sunday, monday...etc). I want to use it in the chart X-axis, to find the total sales on each day.…
arunpandiyarajhen
  • 643
  • 12
  • 20
  • 51
0
votes
1 answer

How can I setup Data Sources in Cognos 10

When I attempt to create a new package a new window opens in order to select the desired data source from the list. The list is empty although I have succesfully defined and tested a datasource through Cognos Administration > Configuration > Data…
jayt.dev
  • 975
  • 6
  • 14
  • 36
0
votes
1 answer

Cognos calculating work days between two days

In a package, I have two namespaces with a structure as below: NamespaceA -> work_id, start_date, end_date NamespaceB -> calender_date, is_holiday I want to calculate the number of working days between start_date and end_date for each work_id.…
Rasika
  • 1,980
  • 13
  • 19
0
votes
1 answer

What does "QE-DEF-0469 QE Message" mean?

I'm working on Cognos 10.1. For a report, I've updated the package. When I open the report in report studio, it is showing an error like QE-DEF-0469 QE Message. What does it mean? Earlier responses would be appreciated. Thanks.
arunpandiyarajhen
  • 643
  • 12
  • 20
  • 51
0
votes
0 answers

External Java Authentication for IBM Cognos 8

Is it possible to right/configure a custom authentication java module, such that the authentication is done by java. If authentication is true then pass only loggedin user id to cognos and do business logic based on this like drop down or data…
paramupk
  • 626
  • 1
  • 11
  • 32
0
votes
1 answer

Using sysdate in Cognos Report

My cognos report uses sysdate-n to retrieve records for a specified date. The report execution time varies. Suppose my report runs into the next day i.e past 12:00 am would that mess up records received or do the records retrieved depend only on the…
Sana
  • 147
  • 1
  • 1
  • 13
0
votes
1 answer

How to control the report output in Cognos 10.1?

Currently I'm working Cognos 10.1 report studio. The requirement is that the output should be in such a way that the crosstab should appear in a default size in all the pages eventhough the outputs differ. The crosstab size should be same in all…
arunpandiyarajhen
  • 643
  • 12
  • 20
  • 51
0
votes
1 answer

How to pass two values when a bookmark is clicked in crosstab?

I'm working with a crosstab in cognos now. Page 1 contains crosstab Page 2 contains list Fact - Revenue Dimension - Product line, Year If I click on the revenue (cell value) it should goto the particular record in another list which is located in a…
0
votes
1 answer

Data Manupulation Issue in cognos

One column contains the below case statement, when data is rendered the negative decimal value comes up wrong. correct Value= -0.9 but it displays as .-9 i tried manipulating by changing data format etc. but not getting correct result I want to…
Raj
  • 21
  • 2
  • 5
0
votes
2 answers

What is the error in this case...when statement?

Could anyone say what is the wrong with the below statement. Currently I'm working in cognos 10.1.1 case when extract(month,_last_of_month (current_date))=1 then ('January') when extract(month,_last_of_month (current_date))=2 then…
arunpandiyarajhen
  • 643
  • 12
  • 20
  • 51
0
votes
1 answer

Cognos report outputting different result sets

My work uses Cognos 8.3 for our reports. I have been given a task in resolving an issue where a particular report displays different data for the same request. I have a report that takes in a multi-valued parameter (p_id=123&p_id=456). It is…
Dan Appleyard
  • 7,405
  • 14
  • 49
  • 80
0
votes
1 answer

Capture Value In Table Upper Case Or Lower case

I want to SELECT * FROM table1 WHERE name=petter Now if there is many type of petter in table like PETTER , Petter And petter. Want all this three (PETTER, Petter, petter) to be considered which command is for this in cognos report studio? Or in…
Raj
  • 21
  • 2
  • 5
0
votes
1 answer

Cognos 8 Reports- Specify decimal separator for different locales

I have a Cognos-8 based report which has several number columns. I have set the decimal separator for these columns explicilty as Number Decimal Places: 2 Decimal Separator: period (.) Negative number symbol: () When I run the report in the…
uno
  • 99
  • 1
  • 3
  • 11
0
votes
1 answer

Limit data to be generated in cognos cube generation by year

Ive been working with cognos from a year now but I stumble into another problem that needs urgent workaround resolution. I have this model that automatically generates cube (using a batch file) every day. the generation is successful although the…
jrdb0916
  • 1
  • 1
0
votes
1 answer

How can I fix excel appearance in cognos ?

I make a report as pdf.It s fine. But when I export it to excel ,there are many sheets on excel . I do not wan to it.I want to 1 sheet.How can I fix this? Thanks.
CompEng
  • 7,161
  • 16
  • 68
  • 122
1 2 3
9
10