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
1
vote
1 answer

Cognos Analytics aggregate for multiple conditions

I'm currently trying to create a data item expression within Cognos Analytics report builder to aggregate some data. I'm a novice in building expressions in Cognos as generally I would export the data and work with it separately, but this report…
Pipousial
  • 13
  • 3
1
vote
0 answers

Custom visualization in Cognos Analytics

I look a guide about custom visualization in Cognos Analytics, because the IBM guide is completely unintelligible. I don't know how map a visualization code in Cognos. I know that I must run a "customvis create" procedure. The main problem is when i…
Palczando
  • 23
  • 4
1
vote
1 answer

cognos cache for story, dashboard and report

Q1: If I set "Data cache = On" in a dashboard or story, What is the default cache expire duration for story and dashboard ? I don't see any thing about it in document. I need a…
2015evanotes
  • 89
  • 10
1
vote
0 answers

Is it possible to create a custom equation in the group summary in COGNOS version 11

I’ve created a report in COGNOS which groups all duplicate orders together which works well. I’m trying to work out if there is a way to do a custom equation within the group summary to total the value for all entries within the group but then minus…
aidan330
  • 53
  • 5
1
vote
1 answer

cognos navigation to next + 1 page javascript

I would like to create 3 navigations in Cognos 11 Report from prompt page, to be able to quick navigate to page2, page3 and page4. Below is script I found in internet, it uses JS and HTML item functionality. I used it in prompt page but Im able to…
johnt
  • 79
  • 6
1
vote
0 answers

Scheduling a monthly report - save to local drive

At the moment, our scheduled monthly reports are saved at the Cognos Server. However, I wonder if there is a way to save them to a local drive, as a .xlsx-file. How can I achieve this, using CA 11.1.6 on-premise. Thanks in advance!
E. van Dongen
  • 89
  • 8
1
vote
1 answer

COGNOS report for duplicate data only

I’m using COGNOS 11 and I’m trying to create a report that only returns the duplicate data in a row only. I’ve tried everything in the IBM user guide but not happening for me. Probably a simple solution but it’s been a long day, any help would be…
aidan330
  • 53
  • 5
1
vote
2 answers

Cognos Static prompt values to be passed to SQL

I have a static prompt which is a single select. In that I have two values lets call it A and B. So when I select option 'A' my report pulls all data from the DB which is expected. So when user Select option 'B' the report should pull only the…
Girish
  • 49
  • 8
1
vote
1 answer

Cognos Analytics - Report does not load when combining two dimensions

If I want to use two dimensions in a crosstab, the report starts to process (no errors) but does not finish to load (after 30 minutes). When I use the dimension individually the report is ready after 30 to 60 seconds. Both Dimensions have a 1 to 1…
Maeaex1
  • 703
  • 7
  • 36
1
vote
1 answer

Cognos 11 Analytics on premises - save generated html code when running a report

I'd like to know if there's a way to view and save the html code that's generated behind the scenes of a cognos report when it's being run. We are using Cognos 11 on premises. Thanks!
lhookway
  • 11
  • 1
1
vote
3 answers

How do i count only those records that are being shown based on a parameter in cognos and not the entire data based on a condition?

Okay so i have a data sheet which has Purchase Order data in it with dates included now i have created a new report with a date prompt page where the user chooses the start and end dates and based on that we will show the PO's which fall in between…
Ranit Sen
  • 11
  • 2
1
vote
0 answers

Is there any way to just see not edit a user cognos dashboard?

I use cognos-11 and I made a dashboard for a cognos consumer. I delivered it but the consumer when open it sees the edit/preview icon. I want the consumer to just open the dashboard, filtering the data and use the various drill downs without has…
eMazarakis
  • 122
  • 1
  • 13
1
vote
0 answers

Exclude/limit to current year from Prompt values- Cogno BI 11

I have a prompt that allows users to select multiple years and provides data with each selected year as a column. However, I would like to provide a singleton with an average for all prior years. So if the user selects 2016, 2017, 2018, 2019, 2020…
ealiv
  • 11
  • 1
1
vote
1 answer

Cognos Reprompt button auto runs report

I have a report that has a reprompt button on the prompt page, which is all cascading prompts, and then a back button on the report page that brings you back to the prompt page. So the idea is you can run the report go back to the prompt page from…
cecilia13
  • 19
  • 5
1
vote
4 answers

List of Users belonging to a particular group in Cognos

I need to find the list of users which belong to a particular group in Cognos by querying the Content store database which is SQL SERVER .
NITESH HEGDE
  • 49
  • 5
1 2
3
…
13 14