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

how to split a data coming from database while creating report in Cognos studio

I am getting value from the single column of a database like this in the report Name: Raghu Age: 23 blood group: o+ Address: Bangalore But I need it to appear like this Name: Raghu Age: 23 blood group: o+ Address: Bangalore I mean each thing in…
Raghu
  • 817
  • 1
  • 7
  • 21
0
votes
1 answer

Unable to connect Cognos 10.2.1 from java

I'm trying to connect cognos 10.2.1 from Java and fetch a report. I get the below error. This is not happening everytime i run the java code. log also says that the java code trying to fetch cognos port is throwing error. Someone please…
confused human
  • 401
  • 8
  • 23
0
votes
1 answer

IBM Cognos- difference between burst key, burst group

I'm new to bursting in cognos and would like to know what the difference between a burst key and burst group is.
Neil P
  • 2,920
  • 5
  • 33
  • 64
0
votes
1 answer

Path is not properly set. Cognos will fail to start

I am trying to run Cognos (using IBM Cognos Configuration). But I received this error: [ERROR] The variable PATH is not properly set. IBM Cognos will fail to start. When I checked my environment variables, it contains: C:\Program…
roxsap
  • 137
  • 2
  • 7
0
votes
0 answers

Cognos 10: Rendering Performance IE vs Firefox and Chrome

I've been dealing with a particularly slow running page which I've been attributing to issues with the queries. In IE 9 or 11 (with compatability view settings enabled) the report consistently runs for over 1 minute without completing. I've tested…
james.mullan
  • 149
  • 2
  • 3
  • 16
0
votes
1 answer

Cognos Installation and IIS Setup issues

I installed cognos 10.1 and done IIS Setup for windows 7, However while trying to access cognos connection with help of url the Cognos Connection home page is not coming properly and attached the home page screen shot as well, In Home page its…
0
votes
0 answers

Access throwing unparseable records error from Cognos Report

Before I begin, yes I know everything I am about to explain is back-asswards but at the moment it is what I have to work with. My organization is in the middle of a Cognos 10 BI implementation, at the moment we are having HUGE performance issues…
pegicity
  • 359
  • 1
  • 3
  • 12
0
votes
1 answer

Import the Cognos 10 Trial GOSALES schema (with data) into Oracle Database

I have installed the Cognos 10.2 Trial version. The installation comes a sample schema called "GoSales". I would like to import the GoSales schema into my Oracle database. This will enable me to view the GoSales Schema in a database query tool…
Ababneh A
  • 1,104
  • 4
  • 15
  • 32
0
votes
1 answer

Cognos output. Issues with MHT and Excel

I'm new to Cognos 10. Been playing with it since yesterday and having issues with my outputs. I'm working with an active report. Dunno if that's the right one to use, but I haven't used Cognos in 3-4 versions. First, the only output available is…
yoelbenyossef
  • 393
  • 1
  • 7
  • 26
0
votes
0 answers

Case statement causing RSV-SRV-0042 trace back error in cognos

I get this error because of the case statement included in the query item used for my year prompt use value. the prompt does what I want but combined with the month prompt which points directly to a table I get the error message. here is the case…
dee_14
  • 1
  • 1
  • 1
  • 1
0
votes
0 answers

My Javascript function breaks my cognos report after I hit submit 3 times

I have some HTML buttons that I created that bring up different value prompts and to the right of them is a submit button. Everything works great the first few times. But everytime on the third time I push the submit button, everything goes white,…
giff1
  • 101
  • 1
  • 12
0
votes
1 answer

Cognos Content store - decode objid

I want to get a report of all user names and User IDs. I got the User names but see the UserIDs are in encrypted format. Please help me on How to decrypt the objid in the Content store table CMOBJPROPS1 or any other way to achieve this?
0
votes
2 answers

How to remove percent character from a string in Cognos?

I have a string field with mostly numeric values like 13.4, but some have 13.4%. I am trying to use the following expression to remove the % symbols and retain just the numeric values to convert the field to integer. Here is what I have so far in…
user2525624
  • 15
  • 1
  • 3
0
votes
1 answer

Cognos BI and Active Directory Global Catalog

I've got AD forest with 2 domains, users and groups are separated to different domains (users in first, groups and other resources in second). And if you want to use AD in a such way you have to connect via 3268 port (global catalog). But I ran into…
Vladimir Kravets
  • 330
  • 6
  • 21
0
votes
2 answers

Generate multiple PDF for a single report in COGNOS

I need to use COGNOS 10 to generate a report that will have about 300 pages. I want each page saved as a separate pdf file. Is there a way to automagically do this or do I need to run the report 300 times manually.