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
0
votes
2 answers

Date arithmetic in Cognos 8

What I need is a data item expression which outputs the starting date of the current quarter of last year. Finding the current year is easy, as is subtracting 1 year from that date. But beyond that I get stuck. I currently have an ugly if…
Ben Brocka
  • 2,006
  • 4
  • 34
  • 53
0
votes
1 answer

COGNOS gives error 'Column ambiguously defined'

When I try to run a report in COGNOS Report Studio, I get error : ORA-00918: column ambiguously defined Now there is no way to get the runtime sql and test it out against the oracle db. So I am left groping around. My question is...when we develop…
Victor
  • 16,609
  • 71
  • 229
  • 409
0
votes
1 answer

Can not get HTTP Header in COGNOS Custom Authentication provider

I am working on implementing COGNOS Custom Authentication provider (Java) with SSO (Oracle Access manager(OAM)). The way OAM works is that it looks for a Valid Session Token Cookie in every HTTP/HTTPS request and when not found it redirects to the…
user961954
  • 3,214
  • 2
  • 17
  • 24
0
votes
1 answer

How can I summarize data across all records in a report?

I have a report with section footers summarizing a count of data items in each section. I'd also like an overall footer with a count of all items on the entire report. I'm currently using count([Value] for [Grouped Value]) This is how I can get…
Ben Brocka
  • 2,006
  • 4
  • 34
  • 53
0
votes
1 answer

Calling an oracle stored procedure form COGNOS

In this link IBM they explain how to use an Oracle stored procedure with COGNOS. They are doing : create or replace package body project_pk as procedure project_sp (tproj IN numeric, result1 in out project_type1) is begin open result1 for select…
Victor
  • 16,609
  • 71
  • 229
  • 409
0
votes
3 answers

Title "not centered" when the report is being run using excel 2007

I'm working on an existing cognos report where a user specifically asked me to make changes. When the user runs the report, they run it in excel. When the user downloads the report to excel the title isn't centered. This threw me off because when…
LOZ
  • 1,169
  • 2
  • 16
  • 43
0
votes
2 answers

Pass chart title as parameter to drill through report

Does anyone know if there is a way to pass the title of a chart/graph to a drill-through report? When you setup the drill-through definitions, there does not appear to be an option to select. Only the pass data value and pass parameter options are…
Mark
  • 135
  • 2
  • 14
-1
votes
2 answers

Get a parameter value in JavaScript

In Cognos 8.4, I have a prompt, "NAME", and its parameter p_name. How do I get that parameter through JavaScript? shows a JavaScript error. Why? Is my approach correct?
shanmugam
  • 143
  • 1
  • 4
  • 14
-1
votes
3 answers

01722-invalid-number error

SELECT * FROM COACH_SHOP_OPERATION_F WHERE TRUNC(coach_last_event_dt)=TO_DATE(TO_CHAR('MAY 25,2015','DD-MON-YYYY'),'DD-MON-YYYY') Running this query results in error: 01722-invalid-number
Prateek Agrawal
  • 11
  • 1
-1
votes
2 answers

How to incorporate a Javascript function with the cognos Finish button?

I'm working on Cognos 10.1 report studio. There is a requirement where I should incorporate a javascript function with the Cognos Prompt button ("Finish"). I've tried all possible ways I know but I couldn't achieve it. Please help me. I should…
arunpandiyarajhen
  • 643
  • 12
  • 20
  • 51
-1
votes
3 answers

Cognos 10.1 Frameowrk Manager get automatically updated if there is any change in Database

For eg. I have created a project in Framework manager based on a Database. I have created Report also based on this FM. Now after some time if any changes come in my database(Updation). Is it possible to automically update FM as Database data…
user2783444
  • 31
  • 2
  • 5
-1
votes
1 answer

How can i show each own values of bars at progressive chart in cognos?

I completely say what i want to ask in title? how can I show each own values of bars at proggressive charts. I dont want to shown total values.
CompEng
  • 7,161
  • 16
  • 68
  • 122
-1
votes
1 answer

How can I see the items which settled in drill behaviour in View Tabular Data?

I have a chart.And I allow Drill up and Drill down option.I have a filter that it effect my chart. When I want to view tabular data with setting my parameter , I dont see which I want.Its just show data items like dont effect paramater.It s dont…
CompEng
  • 7,161
  • 16
  • 68
  • 122
-1
votes
2 answers

How I hide default legend?

I want to define conditional legend. I give a colour to one thing. but when my report is running, yes the colour is setting but in a legend show different colour to same thing.In chart it shows colour which I want but in a legend it shows up…
CompEng
  • 7,161
  • 16
  • 68
  • 122
1 2 3
…
9
10