Questions tagged [cognos-11]

Questions addressing IBM Cognos Analytics 11 in particular. Also add the general [cognos] tag to your question.

Cognos Analytics integrates several features to help understanding your organization data, and make effective business decisions.

200 questions
1
vote
1 answer

How do I add timestamp to Cognos 11 file written to share folder

I have a file that is written by Cognos 11 to a shared folder. Problem is that each time Cognos writes the file, it uses the exact same file name. Subsequent outputs fail if the file name already exists. So, I need something line a timestamp…
1
vote
0 answers

In Cognos 11, how can I find all subscriptions for one email address?

In Cognos 1, I have been asked to change all subscriptions for one email address to another. Since the email address is a group email address and does not have a user account in Cognos, I am unsure how to find all of the subscriptions. Any help…
1
vote
3 answers

What is the different between using "IN" vs using "=" inside a query?

I'd like to understand the best way to restrict items in a query. For example Query1 returns a list of ID's based of specific detail filters. I would like Query2 to return only items where Query2.ID is the same as Query1.ID. Which Query2 Detail…
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…
1
vote
0 answers

Change default value of Select & search prompt Cognos 11.6

I am trying to configure the Search And Select Prompt in Cognos Analytics 11 to change the default option from Starts with any of these keywords to Contains any of these keywords. I found on internet some answers but they are not working with newer…
John
  • 69
  • 6
1
vote
2 answers

Why is my COGNOS report taking 11-12 hours to run?

I have a daily scheduled COGNOS report created by someone else a few months ago. This developer left the company over a month ago. From what I'm told this report ran fine. Then a week before the developer left the company, it began to take longer…
woods
  • 243
  • 4
  • 10
  • 20
1
vote
0 answers

Cognos Crosstab Rows - label value from data

Using Cognos Analytics 11.7.1IF1021 In the past I have added a label in a row label using the result of a data item. Today, I'm having trouble. View tabular data returns the expected results. When I run the report, I get all of the correct…
dougp
  • 2,810
  • 1
  • 8
  • 31
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
1 answer

How to display default value from prompt macro in value prompt CA11?

I was wondering if it is possible to display the default value from a prompt macro in a Value prompt. My prompt macro looks like this "#prompt('pMonth','MUN','[Previous Month]')#" so my goal in the value prompt would be to have 202103 displayed…
Rubrix
  • 191
  • 12
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

Parametrized URL to set dashboard filters for Cognos

We want to pass some Parameters from our UI to Cognos Dashboard (IBM Cognos Analytics 11.1 R7 (LTS)) via url method. Is it possible for Dashboard to set filters dynamically from url or with SDK ? We are planning to embed the Dashboard URL within…
Marouen Bk
  • 11
  • 1
1
vote
1 answer

How to generate a Cognos report for different email receiver?

How to generate a Cognos report for different email receiver? I've a report need to send to different people. The difference of each report is the background picture of it which has the receiver's email address on it. On the other words, how to get…
2015evanotes
  • 89
  • 10
1
vote
0 answers

cognos embedded - filters passed via API

I wonder on whether it is possible with congnos embedded in watson studio to dynamically apply filters in the URL or via API. I found this repository which contains JavaScript API reference documentation for IBM Cognos Analytics with classes and…
massi
  • 21
  • 1
  • 4
1
vote
0 answers

how to set a default value in a filter in the cognos 11 dashboard when opening the dashboard?

I have a dashboard in cognos 11.1.7 and I need that when the user opens the dashboard it shows the data of the current month and the user can change the month.
1
2
3
13 14