Stack Overflow
Stack Overflow

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
2
votes
1 answer

Copying from report output

Cognos Analytics 11.1.7IF9 Searching the web for "Cognos report copy" produces many results about copying a report spec to the clipboard. That's not what this question is about. Using the interactive viewer in Cognos Analytics means users can't…
dougp
  • 2,810
  • 1
  • 8
  • 31
2
votes
0 answers

How to disappear a warning message from the Cognos Dashboard visualization?

I have a visualization on dashboard (cognos 11.1.4) which is a bar chart. When my displayed data is too much a warning message (a yellow triangle with an exclamation mark) appears at the upper right corner of the visualization with the following…
eMazarakis
  • 122
  • 1
  • 13
1
vote
0 answers

why are we getting a Identifier not found '_row_id' in Cognos 11

XQE-V5-0005 Identifier not found '_row_id'. CAF-WRN-2082 An error has occurred. Please contact your administrator. The complete error has been logged by CAF with SecureErrorID:2023-08-07-14:40:30.341-#33 User is getting the above error and can't run…
Pam
  • 11
  • 1
1
vote
1 answer

IBM Cognos 11...Using Conditional Block with variable to select a Date Selector Type in a drop down on a prompt page

I have the Prompt page working in Page Design, I have a Block variable and a "Current Block" setting for each of 3 selection possibilities, if the customer wants to only select entire Fiscal Years, a checkbox selector for those years shows, if by…
WendellFry
  • 11
  • 4
1
vote
1 answer

Cognos Query Join Relationship Cardinality Guidance Needed

I have two queries 'Stock' and 'Dues' that I combined using a query join to create Stock_&_Dues as I want the data from both queries to populate in the same report page. For some reason I'm getting all the data from 'Stock' and 'Dues' when both…
aidan330
  • 53
  • 5
1
vote
2 answers

Data Items for queries not showing in Insertable objects view on COGNOS version 11.1.R7, how do I fix this please?

Our version of COGNOS Analytics was recently updated to 11.1 R7 and we now seem to have lost a function previously available to us. This was to be able to add data items to a query then when building report pages drag and drop from the available…
aidan330
  • 53
  • 5
1
vote
2 answers

IBM Cognos IF/casewhen + _days_between

I have a liste of value and when a value = something i want it to calcultate a number of day between 2 dates. Error: "QE-DEF-0459 CCLException Incompatible data types in CASE statements" Exemple: CASE WHEN ([Statut dossier] = 'Att 1 sv') THEN…
sophie morin
  • 13
  • 2
1
vote
1 answer

Conditionally format crosstab cell based on aggregate values for row

I have a cross tab report that has categories as the rows and the month/year. Additionally, I have the average and std dev for each row. For…
S. Melted
  • 253
  • 1
  • 10
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
1 answer

Finding duplicate records based on a TaxKey

I have a some data with a Tax Key, along with their name, address, etc. There are duplicate TaxKey's which I have been tasked to write a report for. I have tried the filters, by doing COUNT(Taxkey) > 1, but it doesn't bring up any data. Can…
Craig
  • 11
  • 1
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 display multi select parameter in data item Cognos Analytics

I am using IBM Cognos Analytics 11.0.13. I want to pass a multi select parameter to a data item in a query. When I try to place the parameter in a data item, the multi select feature goes away and I can only make one selection. For example, the end…
laubnerb
  • 21
  • 3
1
2 3
…
13 14