Stack Overflow
Stack Overflow

Questions tagged [cognos-bi]

IBM Cognos Business Intelligence is a web-based, integrated business intelligence suite by IBM.

It provides a toolset for reporting, analysis, scorecarding, and monitoring of events and metrics. The software consists of several components to meet the different information requirements in a company.

358 questions
2
votes
2 answers

Dynamic SQL versus using the model

We started using COGNOS about 3 years ago. We have used COGNOS 8 and are now on COGNOS 10. We are constantly being told that using dynamic SQL queries instead of using the COGNOS model is extremely bad in that it causes performance issues and that…
Mark
  • 135
  • 2
  • 14
2
votes
2 answers

Getting logon error in Cognos bi 10.2 while running it

Hi I am new to cognos and using the trial version of cognos(bi_dev_trial_ed_10.2.1_win_en) and getting this error while running it Error: QE-DEF-0325 The logon failed for the following reason:RQP-DEF-0068 Unable to connect to at least one database…
Raghu
  • 817
  • 1
  • 7
  • 21
2
votes
2 answers

Is it possible to colour a cell with value from data in Cognos BI?

Let me first be clear. I'm not asking about how I do conditional formatting in Cognos BI. If there were a simple Red/Amber/Green colour scheme, based upon value ranges then I could do that. If it were a static list of colours, which never…
Chris Kemp
  • 2,069
  • 2
  • 18
  • 27
2
votes
1 answer

Data in Rows Instead of Columns

The default List layout uses column headers with columns of data beneath them. This will not work for my report. I need to create an employee profile report that will return about 75 fields (job title, location, tax status, payroll deductions,…
user3925217
  • 21
  • 1
  • 2
2
votes
3 answers

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 I have hard coded the value [DateCol] = '201406' in Detail filters to get the current month and year records. But I want to dynamically have this value…
Excited_to_learn
  • 361
  • 3
  • 11
  • 25
2
votes
1 answer

SDK to extract the contents of the Cognos Web Page

Currently I'm working in Cognos v10.1.2 . Is there any SDK to extract the contents of the Cognos Web Page? We are developing a monitoring window for the end users where they can view the status of their report instead of mails and calls. The…
arunpandiyarajhen
  • 643
  • 12
  • 20
  • 51
2
votes
2 answers

Is it Possible to Change the Report Page Name Dynamically based on the Prompt Value in Cognos?

Currently I'm working in Cognos v10.1.2 . I do have a requirement that the report page name (The worksheet name of the report's excel output) should dynamically change based on the prompt value selected. How could we achieve this in Cognos. Thanks…
arunpandiyarajhen
  • 643
  • 12
  • 20
  • 51
2
votes
2 answers

Can Bursting the Cognos 8 Report Studio Report reduce the server load instead running them manually 200 times a day?

My Cognos 8 Server is already slow as it is handling a number of Jobs which is used to Burst thousands of Report Studio Reports a day. Moreover, In the same server users are manually generating a particular report around 200 times a day. My Question…
Robin Agrahari
  • 807
  • 3
  • 11
  • 24
2
votes
2 answers

Filter Performance in Cognos SUBSTRING Vs LIKE

I'm Working in cognos 10.1 now. I'd like to find the names which start with 'AB', 'CE', 'JA'. I'm concerned about the query's performance as the query subject (table) contains about 1,000,000+ records. Which filter should I use? substring…
arunpandiyarajhen
  • 643
  • 12
  • 20
  • 51
2
votes
3 answers

Report Studio template

I am trying to schedule 10 reports that go to the same table and ask for the same columns, except that they differ in a key value (i.e. the report selects column a, b, c from table A but differ in the where clause = 'CLIENT1', = 'CLIENT2', etc). I…
TheMadCapLaughs27
  • 346
  • 3
  • 18
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

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

How to login onto cognos 8.4 bi using a simple php script?

Current state: I have cognos 8.4 bi running on a iis 6 and it runs authentication on openldap. I have a script written in php which also can authenticate using this openldap. Aim: Use only the php script for login-purpose and then send the…
justastefan
  • 595
  • 5
  • 18
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

Drools vs. Cognos

I am relatively new to the concept of rules engines and was trying to work with Drools. Has anyone already worked this tool before and is it similar to Cognos? My understanding was that Cognos is a reporting tool and Drools will promote more…
JJunior
  • 2,831
  • 16
  • 56
  • 66
1
2
3
…
23 24