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

How to count the lines with the specific value at Cognos 11?

lets say i have a column with many lines but only two values, A and B: i am trying unsuccessfully to count only lines with A - in a summary calculation for a dashboard (without making a new column for this specific calculation) the expression which…
avish
  • 37
  • 7
0
votes
0 answers

COGNOS REPORT assign dynamically default prompt value with Java Script

I am working with Cognos 11. I have a list of parameters for a list of users. My problem is that I can't set a default value because each client has different data. For example: I have a client that has data until NOV-2019 and another FEB-2020. I…
MaBe Moreira
  • 25
  • 4
0
votes
2 answers

How to display unique record in dashboard's table visualization Cognos

I have a Cognos Dashboard with table visualization and my database structure will be like this image. I want to display data like this image by using distinct value. but what I got is sum of all values like this image.
Vigneshwaran B
  • 13
  • 3
0
votes
0 answers

Any one have experience with Cognos Gantt Chart?

I can see in Legacy Visualisation in Cognos have a Gantt chart option. I tried to create but it is not working. I have Planned start date and end date and Actual Start date and end date. How can I create a Gantt chart in IBM Cognos Analytics 11.1…
WonderWoman
  • 33
  • 4
0
votes
1 answer

Add data to a value prompt using javascript in Cognos 11

I would like to know if we can add data in a value prompts using java script? The data doesn't come from any query subject, but hard-coded in java script? For example, I have a value prompt named 'country'. And if I want a display value: 'US' and…
Hardik Binnani
  • 1
0
votes
1 answer

ideas for creating a report

Colleagues, I really need your advice on how to create a report with the following format in Cognos Analitics: I only have the value "amount of money" and the dimensions "date" and "Person", and I need to display in the report the value for a…
Alexandra Astakhova
  • 1
0
votes
1 answer

Which is the right way to set the default value for date prompt on cognos prompt function?

I have an optional date prompt , on my cognos report. And I want to pass the value into an SQL query, but if I won't give a value I want the macro to take a default value. I am trying the following format , but it seems that it is not working Where…
eMazarakis
  • 122
  • 1
  • 13
0
votes
1 answer

How to have multiple dimension X-axis in clustered column [Cognos]

In Cognos report, I would like to show Month and Week nested together in X-axis . E.g in April , i have week 16 and week 17. How to show it? When i tried to put the item in 'extra categories', it will not show up in visualization
Jolin
  • 231
  • 3
  • 14
0
votes
1 answer

Using MermaidJS in a Cognos Analytics 11 report

I'm trying to build a dynamic gantt chart in my Cognos 11 report using MermaidJS but it keeps returning the error: "Uncaught ReferenceError: mermaidAPI is not defined" It seems as though the browser can't find my reference to the Mermaid library but…
Grim Coder
  • 394
  • 2
  • 12
0
votes
1 answer

How to make a column based on another specific column's values?

Hello I am trying to make a report where I have something like +--------------+---------------+----------------------+-------------+ | Employee ID | Employee Name | Manager Employee ID | Manger Name…
hptsandroid
  • 1
  • 1
0
votes
0 answers

Merging cells in crosstable in Cognos Analytics 11

Help me please: i develop report in Cognos Analytics 11 with crosstable. I need merge two cells, in one row of facts of crosstable ? merging like in row r2, r3
Albert F
  • 1
  • 2
0
votes
2 answers

Edit 'no value' in crosstabs - Cognos Analytics dashboard

Is there a way to edit the 'no value' in the cells of a Cognos Analytics (11.0.13) dashboard crosstab visualization? I would like to change it into 0. Thanks in advance.
E. van Dongen
  • 89
  • 8
0
votes
2 answers

Cognos SDK Parameters to run a report

I am trying to write a java application to access a report in Cognos 11. I am trying to pass a parameter into the report. For now, it's proof of concept so it is hardcoded string. Problem is when I use this method, the output HTML file is the…
ajspacemanspiff
  • 478
  • 1
  • 10
  • 21
0
votes
2 answers

Cognos Analytics - save weekly reports to local drive

In the current situation weekly scheduled reports are saved to the Cognos server. However, I was asked if there is a way to save them to a local network drive. Is this possible (documentation on this issue will help too)? We're using Cognos…
E. van Dongen
  • 89
  • 8
0
votes
1 answer

Cognos 11 Analytics

First time posting. Our fire response agency just moved to Cognos 11 after qRep. I know little to nothing about SQL, modules, cubes, or data analytics, but I'm one of the few in our agency that can write an excel function so I guess I am considered…
Ryan51104
  • 11
  • 1
1 2 3
…
13 14