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

Using Teradata Volatile tables in Cognos transformer

A cognos query turns out be a heavy CPU consumer which I tuned using Volatile tables. I'd like to know from someone who is familiar with implementing Volatile tables in Teradata via Cognos whether this is easily do-able . I did something like that…
user1874594
  • 2,277
  • 1
  • 25
  • 49
0
votes
1 answer

Cognos PDF report not visible in iframe

I have embedded a Cognos Connection in a web page using an iframe. I can login to Cognos and run reports without any issue within the iframe. I didn't feel any difference to accessing cognos in a iframe to cognos running in a normal browser web page…
Hiran
  • 698
  • 1
  • 10
  • 29
0
votes
1 answer

Is there a way to combine / overwrite data when using two sources in Cognos Report Studio?

I am using two sources in Cognos. Source #1 - Old source Source #2 - Current/New Source Previously there was only one source, that's source1. Then people from DW team started migrating/mirroring data from Source1 to Source2, eventually some data…
BongReyes
  • 205
  • 2
  • 7
  • 19
0
votes
1 answer

Cognos BI Icons and Meanings

I'm looking for a list of all the Icons used within Cognos BI and their meanings. Right now I'm specifically struggling with the blue Package Icons. I have two different blue icons: Solid Blue Blue with 3 small squares What is the difference…
Michael Riley - AKA Gunny
  • 5,074
  • 4
  • 42
  • 89
0
votes
2 answers

Getting CM-CFG-5024 error on content store upgrade when upgrading to Cognos BI 10.2.2

Tried to upgrade one Cognos instance from 10.2.1 -> 10.2.2 Existing 10.2.1 works just fine. Uninstalled 10.2.1 and installed 10.2.2 as per documentation. When trying to start the Cognos service i get a message i haven't seen before during…
e4rthdog
  • 5,103
  • 4
  • 40
  • 89
0
votes
2 answers

Cognos 10: restrict the items displayed in a value prompt based on the criteria in another value prompt

I'm trying to find a way to restrict the items displayed in a value prompt based on the criteria in another value prompt I have a report where the row and column values are dynamically selected using radio button value prompt: Row…
james.mullan
  • 149
  • 2
  • 3
  • 16
0
votes
0 answers

Cognos 10.2 Prompt API Refresh Cascading Prompt Without Page Refresh

I'm trying to find a solution where a user can refresh a prompt without refreshing the whole page. I have two prompts which cascade: promptA > promptB The desired behaviour is user makes selection in promptA user clicks a link or button to and…
james.mullan
  • 149
  • 2
  • 3
  • 16
0
votes
2 answers

Cognos query calculation - how to obtain a null/blank value?

I have a query calculation that should throw me either a value (if conditions are met) or a blank/null value. The code is in the following form: if([attribute] > 3) then ('value') else ('') At the moment the only way I could find to obtain the…
MaZe
  • 239
  • 1
  • 4
  • 13
0
votes
1 answer

How do I apply case function to a Leap Year that occurs every four years to a date formula in Cognos?

How do I apply case function to a Leap Year that occurs every four years to a date formula? I have this DATA ITEM 1 entitled INSURANCE TERM query in cognos that has a formula inside. (12 * _days_between([Policy Expiration Date],[Policy Effective…
BongReyes
  • 205
  • 2
  • 7
  • 19
0
votes
2 answers

How to exclude the February 29 - Leap Year in a Date column using Cognos 10 Report Studio?

How do I exclude the February 29 - Leap Year in a Date column in Cognos 10 Report Studio? This is the column that I'm using for my date prompt Below is the prompt that I applied on the date column Depicted below is the details and properties of…
BongReyes
  • 205
  • 2
  • 7
  • 19
0
votes
1 answer

How do I use the For clause to create a sum or total of an aggregated column in Cognos report studio?

How do I use the sum in Cognos report studio for the Final Policy Premium? Table 1 is the result (highlighted in Blue) that I currently get even if I set the Data Item (Final Policy Premium) into Total. My goal is to see the results as shown in…
BongReyes
  • 205
  • 2
  • 7
  • 19
0
votes
0 answers

Data Source Connection Error in IBM Cognos BI 10

I am trying to connect the below listed from the IBM COGNOS BI 10 through JDBC Drivers Connect LUW system which is having Postgresql, but I was getting error like " XQE-JDB-0004 A problem occurred finding the driver class "org.postgresql.Driver"…
Aishwaryameenakshi
  • 189
  • 1
  • 1
  • 9
0
votes
1 answer

Radio Button Group Selection in Cognos 10

In my cognos report i am trying to have two options. Once a "Select by NDC11" radio button is selected I should be able to select the values from the list box, and when the "Select by NDC11 Textbox" radio button is selected, I should uncheck the…
ashswet
  • 1
  • 1
0
votes
1 answer

Printing a PDF Cognos Report from the Cognos Viewer/Browser print settings overriding report settings

I have configured a report's orientation to portrait when the output is PDF. It displays correctly in the Cognos Viewer. However, when I click on the Print button on the right side in the Cognos Viewer, the orientation defaults to my browser's page…
AZP87
  • 1
  • 2
0
votes
1 answer

IBM Cognos not save properly the preset parameters

I have a problem with the preset parameters in cognos. I go to the properties and check in Report View's tab the "Prompt Values" saved (option "View all") and I see a specific value. Then I go to "Edit" and Cognos selects another value as default…
Agus Vago
  • 3
  • 2
1 2 3
…
23 24