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

Average of top counts and use it in conditional prompts in Cognos

Im using Cognos 10.2.1 My question has two parts to it. How to calculate an average of top 20 count. Can I use this to conditional format my bar chart. I did use feeder queries and tried to get the average of top counts but am now receiving a…
Ashish B Sathish
  • 121
  • 2
  • 4
  • 16
0
votes
1 answer

use array output in other class

Good day! I have a method which returns me an array of report names System.out.println(bc[i].getDefaultName().getValue() i want to use array output in other class, how i need to linked method outpud in my array in other class? Method is: public…
Egor Rogov
  • 3
  • 2
0
votes
1 answer

IBM Cognos Connection - Web - excel ODBC

We use IBM Cognos Connection. I'm not entirely sure how it works. But we login on the web and run queries off it. I am aware that Excel can use ODBC to directly import data from a database into the spreadsheet. What I am unsure of is that - is IBM…
gemmo
  • 1,286
  • 2
  • 16
  • 33
0
votes
1 answer

How to invoke second page only when click on text item in list

I have report which has two page says page1 and page2. Page1 has list object. When I run the report page1 should display with list column values. when I click any of test item from list column1 then second page should appear. Please can you guide me…
Shubhi
  • 1
0
votes
1 answer

Show the same rank in drill through report as the same in Summary report

I have a report in which I display the Student Name, their marks and the rank based on the marks.On clicking on the student name a drill through report opens and their details are displayed. In the drill through report also I have to show the rank…
Saraban
  • 3
  • 2
  • 5
0
votes
1 answer

Custom naming for page layers Cognos

Using Cognos 10.2.1 and reporting studio. Im generating a report with the page layers filter context option. However, the names are automatically generated based on the page name. For example, if the page name is Hello, it beocomes…
user2177988
  • 1
  • 2
0
votes
1 answer

Cognos change datasource of existing package

I have a package that was exported from a Cognos 10.2.1. development server and imported into a new server. I now need to change the data source on that package on the new server but am unable to find where to do this. Note, I cannot just add a new…
Alex
  • 507
  • 1
  • 5
  • 7
0
votes
1 answer

Cognos 10.2.2Stitching of Burst Outputs

we have cognos report which is running with bursting as "yes" and give close to 70 outputs. we get 70 different PDF files but my requirement is to get 1 PDF file with 70 pages(all burst outputs). Every help is appreciated.
Yash Agarwal
  • 1
0
votes
1 answer

Setting a maximum value for a variable. Cognos

I started working in BI and I was given a brain teaser since I came from C# and not SQL/cognus. I get a number. It can be between 0 and a very large number. When I get it and it's below 1,000 everything is dandy. But if it's bigger than or equal to…
Datner
  • 315
  • 2
  • 9
0
votes
1 answer

To Prevent Auto Submit from generating the report in Cognos

I have 3 prompts. 1st Prompt contains the values A & B. On selecting A the remaining 2 prompts should get hidden and upon selecting B the 2 prompts should show. All the 3 prompts are mandatory. Can anyone help me achieve this scenario?
Saraban
  • 3
  • 2
  • 5
0
votes
1 answer

Cognos Web Reports 7: Change Source of a Custom Report View

Is it possible to change the source of a custom report view in Cognos Web Reports? We're using version 7.5. Cheers James
james.mullan
  • 149
  • 2
  • 3
  • 16
0
votes
1 answer

Getting the maximum of values in Cognos in a Query

I have a query which consists of 3 columns, ID, Name, Start Date Each ID has 2 or more start dates. The start date might be having the same value for some ID's say for eg: Id 281 contains start dates as 12-03-2011 12:00:00 and 12-03-2011 12:00:00.…
Saraban
  • 3
  • 2
  • 5
0
votes
0 answers

Cognos Report Studio Crosstab drill thru

I have a Crosstab report (10.2.2) which has 4 sub-reports that when you drill-through each report. I have drill-through on the row (TOS Level1) and would like to do that to the columns for (Emp Level 2 & 3). However when i go from prompt pages the…
vbnewbie
  • 29
  • 5
0
votes
0 answers

Conditional groupings in Cognos 10

I am developing a report for a University. They require around 15 different groupings of their choice (e.g. Campus, Faculty, Course, School, Program, Major, Minor, Nationality, Mode of Study... and the list goes on). They require the Headcount and…
Norman Bentley
  • 640
  • 5
  • 20
0
votes
1 answer

Cognos integration with asp.net web page

I wanted to integrate cognos and fetch the reports in pdf/chart format from cognos server. I have not worked much on cognos framework. I have checked other question also for the same but not got any proper answer to this question. Please help!
Akhilesh
  • 171
  • 2
  • 20
1 2 3
…
23 24