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 to get average time in Cognos 11

I am working on a data where I have to calculate average time attendance for days of the week or month Our Data source is Cognos 11 how to get average time in Cognos 11?
Khalid
  • 11
  • 1
1
vote
1 answer

How should I build a report so that the dashboard acts like a filter?

I want to create a drill-through function from a Cognos Analytics 11 Dashboard to a report. Although I have some experience with the dashboard-module, I'm pretty unfamiliar with reports. How should I build the report, so that the dashboard acts…
1
vote
1 answer

Is there way to create Gantt Chart in IBM Cognos Analytics 11.1 R2?

I am trying to build a Gantt chart in IBM Cognos Analytics 11.1 R2. There is no option in Visualizations where I can create Gantt chart. Is there any other way I can create a Gantt chart. Data I have is One project with multiple activities and…
1
vote
2 answers

Cognos Analytics, multiple columns in crosstab but only one row in measure

I have a problem where in a crosstab with multiple columns there are multiple rows of measures where I would only like to have one. The crosstab looks like this: |-----Amount-----| …
jfp
  • 73
  • 7
1
vote
1 answer

Order column chart by count ID

I have data on neighbourhood complaints regarding dogs, noise, garbage etc. I'm trying to visualize with a column chart. The neighbourhoods on the x-axis have to be ordered by the count (occurences) on the y-axis. Alfabetical ordering is default,…
1
vote
0 answers

How to use getElementBy in Cognos11 to get the Value of a textelement?

Heiho:-)## I got some text elements/singletons in a Cognos 11-report to show some calculated values. I added some JavaScript with d3.js to visualize those values. I tried to get the value from a text element with…
saphie
  • 11
  • 3
1
vote
1 answer

COGNOS 11.1.3 - Drop down prompt disable parameter name and dotted line

I have a question about value prompt in Cognos 11.1.3. I have a required value prompt with selected drop down UI. Prompt is using static choices. The problem is that in Cognos 11.0.3 we disabled showing of parameter name and dotted line in UI by…
3georgo3
  • 95
  • 1
  • 14
1
vote
1 answer

Can not have element children within a simple type content

Using Cognos 11.0.13.1, but I have seen this problem reported as far back as 8.3. I am getting this error message intermittently when I create a list that returns no results. It happens both in page preview and when I run the report. I have seen…
dougp
  • 2,810
  • 1
  • 8
  • 31
1
vote
1 answer

Looking to complete an Else If statement

Wanting to create a new If Else statement that categorizes by two conditions from different columns. The first one is IsAdult and some of the values have 'adult' in them which is why I used contains; same goes for 'clipped' under the ISCLIPPED…
GammaRay
  • 13
  • 5
1
vote
1 answer

Javascript broken after migrating from cognos 10.2.2 to cognos 11

I have migrated the reports from Cognos 10.2.2 to Cognos "11.0.13.1 LTS" version. The java script governing the prompt page is currently broken after migrating to 11. This is working well and good on 10.2.2. Did something change on Cognos 11 or some…
yoga
  • 710
  • 5
  • 11
1
vote
1 answer

Cognos on startup sends a test email to the notification default sender. How can this email be stopped or changed?

We have a cron job that automates the stop and start of cognos. When Cognos Starts an email is automatically sent with the following subject "Test message from IBM Cognos Configuration" This email is sent every day to the address in the config…
VAI Jason
  • 534
  • 4
  • 14
1
vote
0 answers

IBM Cognos Analytics with jQuery/DataTables drawn or setData function problem

The following JavaScript works fine if I pass t_dataSet into DataTable but does not work (e.g no data) if I instead pass this.dataSet. define( ['jquery', 'https://cdn.datatables.net/1.10.19/js/jquery.dataTables.min.js'], function($, Datatables)…
Patrick Garner
  • 3,201
  • 6
  • 39
  • 58
0
votes
0 answers

Cognos Job to send one email with all reports

In the older versions of Cognos we had Events which run multiple reports and at the end it can send 1 email with all the reports attached in one email. This is good when sending a report packet to users with different but related reports in one…
0
votes
0 answers

Login via URL in IBM Cognos Analytics

I would need an URL for Login in IBM Cognos Analytics - so that you dont need to type in the user and the password (should be contained in the URL). This should directly link to an existing dashboard. I tried the instructions of this IBM Page…
Jasmin
  • 1
  • 1
0
votes
1 answer

Cognos 11 Reports: I am using a date prompt in a filter and in data items but receive Error QE-DEF-0426

I have a date prompt in a filter: [Fiscal Year - INFY] = substring(year(?Date?),3,2) but also use the prompt in a data item to determine how to calculate inventory amount: `CASE CAST(month(?Date?),INTEGER) WHEN 1 THEN 0 WHEN 2 THEN…
Alan Marsh
  • 39
  • 1
  • 5