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

How to Create Event/Agent to monitor report distribution

We have some Cognos reports that are distributed via email; however, they are not always successfully sent. I'm trying to use Event Studio to create a Job/Agent that will monitor these reports and report the distribution status, but am not having…
flwr_pwr
  • 150
  • 4
  • 16
0
votes
1 answer

How to access database behind Cognos Connection (10.2)

We are using Cognos Connection as a web interface to create/manage Cognos reports via a connection to an Oracle database. We have some reports that are saved to the file system (which I believe means the file system on the server in which Cognos is…
need_java
  • 127
  • 2
  • 4
  • 13
0
votes
2 answers

For cube building do we need to use Cognos Transformer or Cube Designer?

For Cognos cube building I heard about using Cognos Transformer?. But now I see there is an another tool called Cube Designer?. Which one do we need to use for normal cube building?. Is it Cognos Cube Designer latest and succeeded the other one ?.
Explorer
  • 295
  • 1
  • 12
0
votes
1 answer

For new Cognos report do we need to use query studio or Report Studio?.Where to setup the query for the report?

I'm complete new to the Cognos BI. After the data modelling in Framework manager we publish the Cognos package to public folder. From there if we want to create a new report which one do we need to use?. Query Studio or Report Studio?. I know for…
Explorer
  • 295
  • 1
  • 12
0
votes
2 answers

Cognos Transformer built cubes - Are they packages like Framework Manager built packages?

To create new report we use framework manager to create the package to use with the Cognos Report studio?. Can we use the Cognos Transformer to built cubes in the reports?. Are those Cognos Transformer built cubes a PACKAGE?. Can we use this…
Explorer
  • 295
  • 1
  • 12
0
votes
0 answers

For new report creation do we need to use Cognos Framework Manager or Cognos Transformer

If we want to create a new Cognos report do we need to use Cognos framework manager or Cognos Transformer for the required dataset for the new report?.
Explorer
  • 295
  • 1
  • 12
0
votes
1 answer

Cognos use javascript to clear 2 out of 4 prompts

I have a report which contains 4 prompts. These prompts are located on the actual report page. This is a report created against the metrics studio package. prompt 1 is strategie and always needs to be selected. prompt 2: is a scorecard…
Karoos
  • 1
  • 1
0
votes
1 answer

Cognos Administration with Oracle RAC

I am a support technician for my company that uses an Oracle RAC database to support a few web applications, including Cognos. I have no experience with Cognos and cannot access Cognos but I've watched quite a few videos on youtube and I think I…
cognos_newb
  • 1
0
votes
0 answers

I can't combine both Percentage and Total in a Cognos Crosstab

I can't combine both Percentage and Total in a Cognos Crosstab My goal is to create a crosstab that would show both percentage and total. The problem that I'm getting is that I can only choose one between PERCENTAGE and TOTAL. If I tag the Aggregate…
BA82283
  • 251
  • 4
  • 9
  • 22
0
votes
1 answer

List unsold items per customer

I am working on a Cognos Report to display a list with Customers and Items that were never purchased by those customers, but I can't reverse the association to find the "excluded" Items. My relevant tables and relationships are: Customers 1..1 <-->…
Helvio
  • 707
  • 1
  • 7
  • 15
0
votes
1 answer

IBM Cognos FM test total rows return 2 rows, but when test samples return only 1 row

I'm having an issue with IBM cognos framework. When i test samples, it returned the result not true, only 1 row returned. Although the table in database has 2 rows and when i test total rows it returned 2 rows too. At database At cognos…
Jack
  • 1
  • 2
0
votes
1 answer

Grouping, missing data - Cognos Report Studio

In IBM Cognos Report Studio I have a data structure like so, plain dump of the customer details: Account|Type|Value 123-123| 19 |2000 123-123| 20 |2000 123-123| 21 |3000 If I remove the Type from my report I…
gemmo
  • 1,286
  • 2
  • 16
  • 33
0
votes
1 answer

Cognos SDK DataSourceConnection Powercube

I am currently working with the Cognos SDK and I want to add a DataSourceConnection to a DataSource that is in "IBM Cognos PowerCube" - Query Mode / Type. I managed to add a DataSourceConnection to a DataSource but the Query Mode appeared to be in…
Finn von Holten
  • 108
  • 10
0
votes
1 answer

Can i use IBM Cognos Navigator and IBM Cognos Search on a web application

I am currently working on a project that requires me to use existing IBM Cognos reports in a JavaScript web application. I am stuck on how to integrate all the functionalities provided by IBM Cognos. Is there any API that i can use for this and if…
Edwin Kato
  • 543
  • 3
  • 11
0
votes
1 answer

adding conditional prompt to Cognos 10 sql based query

Cognos BI version: 10.2.2 using report studio I have a report with one prompt p1 and its a sql query based report. Prompt UI: p1 is a DropdownList(use value, display value) 1-All, 2-value2, 3-value3, 4-value3 I am trying to add condition based…
fidel
  • 3
  • 2
1 2 3
…
23 24