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

Cognos Mobile constant 401

Could anyone point me in the right direction of what may be causing me to see multiple requests on my Cognos BI server. When I review my IIS logs I see three attempts for each request. The first two get a 401 response, and then eventually the third…
Chris Kemp
  • 2,069
  • 2
  • 18
  • 27
0
votes
0 answers

Remove old reports from IBM Cognos UI for BI

We have some old reports which are not being used anymore by the business and wish to remove/archive these. I have 2 queries related to this: a) What is the best way to find if a report has not been used for the past 12+ months? b) Is there any…
gagneet
  • 35,729
  • 29
  • 78
  • 113
0
votes
2 answers

Search and Select box does not have a default value

We have a report that requires users to be able to search from a field [Templates] and then select the 1 or more than 1 Templates to filter by. However, the report spec. also calls to be able to return the set of all Templates. I have done a lot…
ASheppardWork
  • 95
  • 1
  • 2
  • 12
0
votes
2 answers

Cognos direct link to report without username or password

I have Cognos report that i want it when clicking on it's URI to get direct into it without requesting the username and password any suggestion about methods that could be used ?, i have no problem to make the URI use default username and password…
user3734290
  • 41
  • 1
  • 11
0
votes
1 answer

Performance tuning in Cognos Report Studio

Working in Cognos Report Studio 10.2.1. I have two query items. First query item is the base table which results in some million records. Second query item is coming from a different table. I need to LEFT OUTER JOIN the first query item with other.…
Excited_to_learn
  • 361
  • 3
  • 11
  • 25
0
votes
0 answers

How to add automatic filters to Excel output in Cognos reports?

I am working on a project in Cognos Report Studio version 10.2.1. One of the business requirement is that the output format of the report should be in Excel 2007 with auto filter on the headers of the row. I tried inserting one html item above the…
Excited_to_learn
  • 361
  • 3
  • 11
  • 25
0
votes
2 answers

Incompatible data types in CASE STATEMENT

I am converting a SAS code into Cognos Report Studio version 10 where am stuck at a point where there is data formatting needed. IF SDW_STAT ^= '' THEN PRINCIPAL_BAL = TOT_PRIN; Where '' represnts single quotes without any space I tried writing a…
Excited_to_learn
  • 361
  • 3
  • 11
  • 25
0
votes
2 answers

How do I create a summary data item in Cognos Report Studio?

I am working on a Cognos Report Studio Version 10 where I have to convert SQL code into Data Items. I have all the Columns required in the package to drag as Data Items in the query but I am stuck where there's calculated fields. This is one of…
Excited_to_learn
  • 361
  • 3
  • 11
  • 25
0
votes
1 answer

Merging 4 queries in Cognos Report Studio

Recently started working on Cognos and I am facing quite a few challenges. Though some of them I was able to rectify, with some of them I'm just not able to understand the problem. I am creating a report in Cognos where I used a SQL code to join 4…
Excited_to_learn
  • 361
  • 3
  • 11
  • 25
0
votes
0 answers

Calculated field in Cognos Report Studio

I am creating reports on Cognos Studio and trying to add a calculated field named Record. Following are the conditions used to create this calculated field: Dataitem: Record: IF (com = ‘MASTERLINE’ THEN (com + ‘ ‘ + ML) ELSE (com + ‘ ‘ +…
Excited_to_learn
  • 361
  • 3
  • 11
  • 25
0
votes
3 answers

is there any Birt web portal(open source) similar to cognos connection

I am looking for something like where user can login to run/view reports, schedule them etc.
user3574045
  • 1
0
votes
1 answer

Chart's y-axis line minimum value

I am having a problem with chart properties. Before, there is an option to set the minimum value. I was able to set it but it suddenly changed and I can't find the option to set that again. Does anyone know how to change it from this: into…
user3462803
  • 170
  • 1
  • 2
  • 10
0
votes
0 answers

Cognos Report Studio: DMB-ECB-0088 A DMB cube build limit has been exceeded

I'm running a report (Snapshot attached). If I filter the dates range for 1-6 months it went well. But if I filter it for a year the report throws an error. DMB-ECB-0088 A DMB cube build limit has been exceeded. I searched over for this error, and…
Nuh
  • 27
  • 3
  • 9
0
votes
0 answers

IBM Cognos Report Studio: Inserting Data Items from same Dim on Report Page

I have tried to insert two data items to the report page, in which one is an element from a dimension (lets say CurrentItem), and the other one is just parent(CurrentItem) I have already done the same for elements from another dimension, which…
Skovly
  • 234
  • 1
  • 8
  • 22
0
votes
0 answers

IBM Cognos Report Studio: Is it possible to make one of the drill-through definitions standard?

I have an element in one of my reports with multiple drill-through definitions in the collection. This is fine, however, I want to make one of these definitions the standard one, so that when the user left-clicks the element, this definition will be…
Skovly
  • 234
  • 1
  • 8
  • 22
1 2 3
…
23 24