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
6
votes
2 answers

How to expose cognos reports as web service

please let me know what are the API’s available in Cognos? what are the API's required to expose cognos reports as web services for mobile apps? Thanks in advance.
Sudheer
  • 71
  • 1
  • 3
5
votes
1 answer

IBM Cognos Report Studio: Value prompt default selection from prompt "default text" parameter

I have a value prompt that references the parameter 'Year_Parameter', and a list with one column (a Data Item Expression) that references the same parameter as the value prompt in this way: #prompt('Year_Parameter')# The value prompt has some…
Skovly
  • 224
  • 1
  • 8
  • 22
4
votes
1 answer

Cognos SDK documentation / tutorial or something like that

I need to embed cognos analytics reports in my web application with a high degree of integration such as custom UI of reports list, custom UI of report controls and so one. As far as I understand sdk is intended for this purpose, but i cant find any…
Vladimir Kravets
  • 329
  • 6
  • 17
3
votes
4 answers

How to resolve cannot find symbol error?

I'm trying to use a Java program provided by IBM. See the code below. When I try to compile this program, C:\Temp>"C:\Program Files (x86)\Java\jdk1.6.0_25\bin\javac.exe" GetOrphanMyFolde rs.java I get an error saying GetOrphanMyFolders.java:96:…
jrara
  • 14,677
  • 28
  • 85
  • 117
2
votes
1 answer

Need help building a Data Item in Cognos Report Studio

So I have a table with employee name, job and shift. Each employee (Row) has a unique name, a non unique job and one of 4 shifts (A, B, ,C or D). I want to create a Data Item called "Shift A Employees" that that for each job it spits out one…
Isaiah Beets
  • 23
  • 2
2
votes
2 answers

Uploading default theme to IBM Cognos Analytics via script

With Cognos 11, is there any way we can upload a theme using powershell/sql scripts, perhaps by modifying configuration files or the content db? So I have a scenario in which I need to upload a default theme to Cognos, but would like to avoid to do…
Ken Timothy
  • 637
  • 7
  • 24
2
votes
1 answer

How to create banded columns in Cognos Report Studio

How do you create banded columns in Cognos Report Studio? Here is an example of banded columns taken from this link: EDIT: Maybe this search string will help find this page? "Cognos Report Studio, how to create column band"
Soenhay
  • 3,628
  • 4
  • 29
  • 53
2
votes
0 answers

The request failed with an empty response. when calling third party server

I am trying to integrate cognos BI server with console application when I tried to connect to server I am getting error state as 'The request failed with an empty response.' credentialXML.AppendFormat("{0}",…
Akhilesh
  • 171
  • 1
  • 19
2
votes
1 answer

Is there any way to avoid the top rows with NULL values that has one column value (One of the table Business Key) in Cognos report prompt values

Is there any way to avoid the top rows with NULL values that has one column value (One of the table Business Key) in Cognos report prompt values When the user does not select any value in the value prompt (Cognos Report Portal) and clicks FINISH…
BongReyes
  • 195
  • 1
  • 4
  • 15
2
votes
1 answer

How to automatically update the IBM cognos Framework manager metadata?

I am new to IBM Cognos, I have created a project using DB2 as a data source. When I added some extra rows to my table it's not reflecting into my project. Is there any way to automatically update the database data into Cognos Report studio. Please…
Pavan Kumar
  • 205
  • 1
  • 13
2
votes
1 answer

Cognos Calculate Variance Crosstab (Dimensional)

This is very similar to Cognos Calculate Variance Crosstab (Relational), but my data source is dimensional. I have a simple crosstab such as this: | 04-13-2013 | 04-13-2014 --------------------------------------- Sold | 75 …
Abraham
  • 460
  • 4
  • 22
2
votes
1 answer

Dynamically adding pages in cognos reports

I have a requirement to fulfill where i have to fetch data from the data source.. In that the number of pages in a report might vary due to the number of times the customer has purchased. Basically Customer Number is the primary Key and based on the…
Raghu
  • 807
  • 1
  • 7
  • 21
2
votes
1 answer

How to prevent label truncation in a Cognos BI Pie Chart

I'm trying to create a pie chart in Cognos BI that shows complete labels. I can't figure out how to do this. I have included an image that shows how the current report truncates the labels and places three dots (...) at the end of each label. I have…
Michael Riley - AKA Gunny
  • 5,058
  • 4
  • 38
  • 78
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
  • 115
  • 2
  • 13
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
  • 807
  • 1
  • 7
  • 21
1
2 3
…
21 22