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
1
vote
2 answers

Cognos Visualization Export to Excel

I'm currently testing some functionalities in Cognos Analytics 11. My goal is to export a report to an excel file. The report should have multiple pages, each containing a list of data and a graph visualizing the data. Currently when I do this, the…
Sievag
  • 33
  • 5
1
vote
2 answers

cognos report alternate two pages

enter image description hereVersion: cognos report 11.1.7fp2 Hi, I have two pages, page1 and page2 and I want them to alternate. Is that possible in cognos? I have a customer that wants me to print the report in pdf page1 [grant#123 details], then…
grasshopper
  • 23
  • 5
1
vote
0 answers

Gaps and Islands analysis in Cognos

Using Cognos Analytics 11.1.7IF9, but asking about Cognos Analytics/Business Intelligence report development in general. Continuation of my SQL question regarding gaps and islands. For performance reasons, I have created SQL code using CTEs and have…
dougp
  • 2,810
  • 1
  • 8
  • 31
1
vote
1 answer

Tab order on prompt page

Using Cognos Analtyics 11.1.7IF9. I have a user who, oddly enough, wants Cognos to make his workflow more efficient. (The nerve!) He thinks that if he can use the TAB button to navigate a prompt page, he'll be faster because he never needs to…
dougp
  • 2,810
  • 1
  • 8
  • 31
1
vote
1 answer

Information repeating on subsequent pages

Using IBM Cognos Analytics 11.1.7IF8 I am developing a report that should have multiple lists of information on the report page, separated by category headers. The problem is that "page" will likely span multiple, physical pages on a printed…
dougp
  • 2,810
  • 1
  • 8
  • 31
1
vote
1 answer

How to generate Authentication Token in Cognos Analytics 11.x

I am very much new to IBM Cognos. I want to fetch the metadata from Cognos env.(cloud/on-prem) to my java application. Metadata like reports, dashboards, data sources, namespaces and etc. I am ready to use Java SDK or REST Services. So I want to…
Kranthi.Gogikar
  • 31
  • 5
1
vote
0 answers

Need a help to Run reports without html pagination

Currently, I am using Cognos BI 10.1.1. Now I want to write a program to execute a report in HTML format using Cognos SDK. But I am getting partial data instead of entire data but in PDF all data is displaying. My suspect is on Pagination. Can…
Vigneshwaran B
  • 13
  • 3
1
vote
0 answers

Cognos Analytics Rest Api/Api-docs 404 not found issue

I was using Cognos SDK for development purpose, now I am planning to shift to Cognos analytics server rest API. Following documentation, I tried to frame the URL as http:///api/api-docs, but I ended in 404 not…
Salman Khan
  • 11
  • 1
1
vote
1 answer

How to remove the blank column in my Cognos report?

I have an IF statement (Please see below), it works but also gives me the true result and also the False result in some of the cases. IF([Payroll History].[Deduction/Benefits Pay History].[Deduction/Benefit Type Code] ='MED' AND [Payroll…
bidevkelly
  • 23
  • 4
1
vote
2 answers

Run/Open a report with URL parameters

The idea is to call from outside of Cognos the link of the report with some parameters. So the user will not need to put the parameters when he opens the report. They will automatically filter the parameters. Using URL parameters or something like…
Andrey Hartung
  • 765
  • 5
  • 11
1
vote
0 answers

what is the difference between Gateway URI and Dispatcher URI in cognos

what is the difference between Gateway URI and Dispatcher URI in cognos ? https://www.ibm.com/support/pages/framework-manager-cognos-analytics-single-sign-sso-gateway-uri Why the gateway URI needs a alias ? What is that for?
2015evanotes
  • 89
  • 10
1
vote
0 answers

Custom visualization in Cognos Analytics

I look a guide about custom visualization in Cognos Analytics, because the IBM guide is completely unintelligible. I don't know how map a visualization code in Cognos. I know that I must run a "customvis create" procedure. The main problem is when i…
Palczando
  • 23
  • 4
1
vote
0 answers

Scheduling a monthly report - save to local drive

At the moment, our scheduled monthly reports are saved at the Cognos Server. However, I wonder if there is a way to save them to a local drive, as a .xlsx-file. How can I achieve this, using CA 11.1.6 on-premise. Thanks in advance!
E. van Dongen
  • 89
  • 8
1
vote
2 answers

Cognos Static prompt values to be passed to SQL

I have a static prompt which is a single select. In that I have two values lets call it A and B. So when I select option 'A' my report pulls all data from the DB which is expected. So when user Select option 'B' the report should pull only the…
Girish
  • 49
  • 8
1
vote
1 answer

Cognos Analytics - Report does not load when combining two dimensions

If I want to use two dimensions in a crosstab, the report starts to process (no errors) but does not finish to load (after 30 minutes). When I use the dimension individually the report is ready after 30 to 60 seconds. Both Dimensions have a 1 to 1…
Maeaex1
  • 703
  • 7
  • 36
1 2
3
…
23 24