Stack Overflow
Stack Overflow

Questions tagged [cognos-bi]

IBM Cognos Business Intelligence is a web-based, integrated business intelligence suite by IBM.

It provides a toolset for reporting, analysis, scorecarding, and monitoring of events and metrics. The software consists of several components to meet the different information requirements in a company.

324 questions
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
  • 82
  • 1
  • 11
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
  • 15
  • 3
1
vote
2 answers

COGNOS: Compare column with previous column in a crosstab with dnamically generate columns

- Hi all, i need to change the color of the values based on a condition. If the value of the previous column is lower then the actual value then the value should be blue otherwise the value should be grey. I am working with a crosstab and the…
Kre
  • 69
  • 8
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,…
E. van Dongen
  • 79
  • 7
1
vote
1 answer

Can't see LDAP users on CognosBI site

I am using ApacheDS for a ldapserver. I set it up and can connect with Apache dashboard but not another 3rd party app(Cognos BI). I have the following configuration: uid=admin,ou=system password: admin IBM Cognos V11 Cognos Setting for clarity:…
shaselai
  • 67
  • 13
1
vote
1 answer

How to remove all characters before a specific character in Cognos Report Studio 10.2

I have columns with different company names. In front of each company name there is a Company_ID. After the Company_ID a specific character = _ divides the ID from the Name. For example i have 111_Mercedes 11B4324_Apple 38A_Google A1ZH8_Airline I…
Kre
  • 69
  • 8
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,003
  • 6
  • 35
  • 55
1
vote
0 answers

Dynamically change pdf export of report name in Cognos 10.2.1

I have a report called "Sales". This report is run once a month by a scheduled job and sent by email in PDF format. My users want to have the month of the data to be shown in the filename, for example "Sales_201901" for the January execution…
Servando
  • 11
  • 3
1
vote
1 answer

Parameters from Cognos Audit Database

Using: IBM Cognos Analytics 11.0.7 Microsoft SQL Server 2016 I'll start off by admitting that my XML parsing knowledge is weak. I'm trying to use the Cognos Audit database to get useful information about report parameters that users have chosen when…
dougp
  • 1,383
  • 1
  • 3
  • 16
1
vote
0 answers

Getting YTD amount for months in cognos in a chart

I am trying to make a line Graph in Cognos Analytics where I want to show 6 months in the x axis upto the month selected in the prompt. The $$ amount should be YTD for each month. so for Feb it should be Jan+feb, for march it should be Jan+feb+mar…
Rey
  • 13
  • 3
1
vote
2 answers

In Cognos BI, how do I select first/last element of a dropdown parameter to be the default?

I've racked my brain trying to find an easy way to do this and I think I'm going to have to resort to a programmatic solution (if that's even possible). I'm using Cognos BI 8.4 and have a query set up to retrieve all distinct dates from my database…
paxdiablo
  • 772,407
  • 210
  • 1,477
  • 1,841
1
vote
1 answer

Cognos Analytics 11

I'm trying to read logs in Cognos Analytics 11.0.7 and prior there was a logviewerv2 that made reading logs very simple. I read in a form that in version 11.0.6, IBM removed this feature. I was hoping to get confirmation on this, and if there are…
Chris Markel
  • 13
  • 2
1
vote
1 answer

% Modulus Operator in DB2 V.9

I'm new to querying from a DB2 but have a scenario where I need to select vendor payments that are divisible by 5 with no remainder, over 1k, and three or more payments of the identical amount. SELECT T.VendorID, T.Amount, T.Date, ROW_NUMBER () …
BStinson
  • 13
  • 1
  • 3
1 2
3
…
21 22