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.

324 questions
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
  • 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
  • 251
  • 3
  • 9
  • 24
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
  • 603
  • 11
  • 20
  • 48
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
  • 797
  • 3
  • 10
  • 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
  • 603
  • 11
  • 20
  • 48
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
  • 344
  • 3
  • 16
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
  • 603
  • 11
  • 20
  • 48
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
  • 585
  • 5
  • 18
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,751
  • 15
  • 50
  • 66
1
vote
1 answer

Run/Open a report with URL parameters

The idea is to call from outside of Cognos the link of the report with some parameters. So the user will not need to put the parameters when he opens the report. They will automatically filter the parameters. Using URL parameters or something like…
Andrey Hartung
  • 473
  • 4
  • 9
1
vote
0 answers

Custom visualization in Cognos Analytics

I look a guide about custom visualization in Cognos Analytics, because the IBM guide is completely unintelligible. I don't know how map a visualization code in Cognos. I know that I must run a "customvis create" procedure. The main problem is when i…
Palczando
  • 13
  • 4
1
vote
2 answers

Cognos Static prompt values to be passed to SQL

I have a static prompt which is a single select. In that I have two values lets call it A and B. So when I select option 'A' my report pulls all data from the DB which is expected. So when user Select option 'B' the report should pull only the…
Girish
  • 29
  • 7
1
vote
1 answer

Cognos Analytics - Report does not load when combining two dimensions

If I want to use two dimensions in a crosstab, the report starts to process (no errors) but does not finish to load (after 30 minutes). When I use the dimension individually the report is ready after 30 to 60 seconds. Both Dimensions have a 1 to 1…
Maeaex1
  • 439
  • 3
  • 19
1
vote
3 answers

Convert IBM Cognos SQL which contains a filter to Microsoft SQL Server Query

I'm trying to convert IBM Cognos SQL which contains a filter to Microsoft SQL Server Query. I tried to apply the filter in the Microsoft SQL Server Query, but it didn't work. Here the IBM Cognos Query: IBM Cognos SQL select rank() over ( at…
Newbie SQL
  • 100
  • 11
1
2
3
…
21 22