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

Cognos Analytics Dashboard - baseline in barchart

I want to draw a baseline in a barchart visualization in a Cognos (CA 11.0.13) dashboard. The baseline is an average over a time period of six years. However, I'm not able to find out how to achieve this. I'm looking forward to an explanation! Kind…
E. van Dongen
  • 89
  • 8
0
votes
1 answer

Cognos Analytics - connect to database

I'm experimenting with the dashboard functionality of Cognos Analytics. However, I do not know how to make a connection between the source of the data (the application) and Cognos, so that the data refreshes automatically. Also, I'm not able to find…
E. van Dongen
  • 89
  • 8
0
votes
2 answers

How to create a Calculation based on multiple criteria in IBM Cognos

I am trying to create a calculation in Cognos based on a number of Criteria. For example, I want to get a count of all of the records in my data set that have the following criteria: Data_Level = "Aggregate" Problem_Area = "Request" IsResearch =…
JasonR
  • 399
  • 4
  • 8
  • 26
0
votes
1 answer

Cognos 11 - One column List wrap

I have a report that has one column list report that is sectioned off based on a data item. What i would like to do is have that one column continue horizontally instead of vertically so it fits on one page. I tried using repeater and repeater table…
cecilia13
  • 19
  • 5
0
votes
1 answer

FOR fuction causing comatibilaty issues looking for alternate of FOR fuction

I am using DQM package in Cognos 11 report Studio. I have two queries which are joined to make a third query. In third query I am using filter condition as [Cardex].[Transaction Date] = maximum( [Cardex].[Transaction Date] for [Cardex].[Lot/Serial…
Pushp Sharma
  • 11
  • 1
  • 3
0
votes
3 answers

Multi select check box - cascade option in cognos

I am using Cognos 11.0.8 version . I am using a multi select check box which pulls data from database. I have another multi select checkbox, which gets populated based on the values selected in the first multi select checkbox. On selecting the items…
Venkat
  • 89
  • 12
0
votes
1 answer

XQE-GEN-0018 QUERY SERVICE INTERNAL ERROR HAS OCCURRED, PLEASE SEE THE LOG FOR DETAILS WHEN QUERYING DMR

I am getting error as XQE-GEN-0018 QUERY SERVICE INTERNAL ERROR HAS OCCURRED, PLEASE SEE THE LOG FOR DETAILS. We have published our CQM package to DQM package . When I point to old package which has type compatible , report run both in Cognos 10 and…
Pushp Sharma
  • 11
  • 1
  • 3
0
votes
1 answer

What high available architecture for IBM Cognos?

Forgive my basic question, but i'm looking for a high available architecture for IBM Cognos 11.x ? I came accross some definitions, with 2 Gateways, multiple dispatchers and one content store. But i didn't find it convenience. Thank you for your…
Youssef Sbai idrissi
  • 339
  • 2
  • 10
0
votes
2 answers

Cognos Analytics Detail Filters - filter from another query

I am trying to create a new report with a filter based on another query. For instance I have a bunch of fields and want to add this type of filter: if place code = '22' then provider state = 'PA' else no filter. I have tried writing to separate…
David Redden
  • 19
  • 2
0
votes
1 answer

Cognos 11.0.13 DMR crosstab, how to set the drill through for the correct year when there are two facts -- Current Year Sales and Prev Year Sales

How can I pass the correct year in the drill through? When using a list - each column can have it's own drill In a crosstab, the drill through appears to be the same for all cell values (showing metrics) In this example, the crosstab has two metrics…
VAI Jason
  • 534
  • 4
  • 14
0
votes
2 answers

Where can I find the executed query of cognos 11.1 report?

I have a report on Cognos Analytics 11.1, with prompt pages. When I run the report I want to see/find the query which is executed on oracle DB with the prompt values that I am passing through. Do you know If there is a log file , which keeps this…
eMazarakis
  • 122
  • 1
  • 13
0
votes
2 answers

Cognos HTML Output Generates multiple rows for each column

I have report that has 6 Query Calculation Columns in a List. Each column feeds from the same field 'Sale Number': IF( 'Metric 1' IN ?pCompany?) THEN ( CASE WHEN ( [Metric] = 'Metric 1' ) THEN ( count( distinct [Sale Number] FOR [Metric],…
Pramod
  • 1,411
  • 11
  • 35
  • 66
0
votes
1 answer

I want to create cross tab to count total number of project in each year and active project

I am new in using Cognos and I have data for the overall project, and I need to create some kind of table or cross tab may be to count the overall project of each year and how many of them are active, canceled and inactive I have tried using a cross…
WonderWoman
  • 33
  • 4
0
votes
0 answers

Invalid Login Response when attempting to access an IBM Cognos Analytics

we are using cogons 11 and hosted in linux server.When I attempting to access an IBM Cognos Anlaytics using web browser it gives 'Invalid Login Response'. When I start the server it work few times and get slow and suddenly give this error.Previously…
heshjse
  • 878
  • 2
  • 14
  • 30
0
votes
2 answers

How to use the exceptjoin in Cognos-11?

I don't get an except join to work in Cognos-11. Where or what am I missing? Some understanding for a beginner in this branch would be nice ;-) What I've tried so far is making two queries. The first one holds data items like "customer",…
Ekfa
  • 93
  • 3
  • 15
1 2 3
…
13 14