Questions tagged [cognos-10]

Cognos is an IBM subsidiary which provides a range of business intelligence and performance management products.

Cognos is a division of IBM (since 2007) which produces products designed to help businesses with business intelligence, operations intelligence, performance management, and workforce analytics.

Some of its software products are similar to SAS or MicroStrategies, both "pure-players" in the industry of business intelligence.

Questions with this tag deal with version 10 of the Cognos SDK.

Resources

382 questions
1
vote
0 answers

Bursting COGNOS reports include CC or BCC possible?

I am currently bursting a Cognos 10 report with a list if dynamic email address and a unioned in static list. The problem is all the recipients wind up in the "To" field. Is there a way/trick to get the static (unchanging hard coded) email addresses…
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:…
user4347600
1
vote
2 answers

Create a SQL query based Daily report with Incremental Records

I have a requirement to create a crosstab using a database which loads only incremental records. Please consider the following sample, Table1: DAY ACCOUNT NO SALES GENDER 1-Apr-2019 ACC01 5000 MALE 1-Apr-2019 ACC02 6000 …
xplorerdev
  • 365
  • 1
  • 3
  • 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
  • 12
1
vote
1 answer

Filter for Report with options for relative Dates throws errors

I am building the filter for a report in cognos report studio that uses parameters from a prompt page. The idea is to give the user who will be running the report the option to specify a start date and an end date (and select only the business trips…
Torric
  • 15
  • 4
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
3 answers

Exporting individual Congos Reports via command line

I'm trying to work out how I can export individual Cognos Reports via the command line, for the purposes of source versioning in Git at a report-by-report level. I presume XML would be the output format. I read that the Cognos SDK can help but you…
flipcode
  • 621
  • 2
  • 9
  • 19
1
vote
2 answers

Cognos Report with Multiple value prompts

I currently have a report that have 9 value prompts items,so far I can only load the prompts with the values that the user can select from, however the desired results should be based on user selection for example if user selected from value prompt1…
Dingo mk
  • 11
  • 3
1
vote
1 answer

How to format crosstab corner in Cognos

I am using crosstab in my report where i wanted to hide crosstab corner (say "Contract count") but when i tried setting box type equals to none, the output overlapping the column fields into the place of crosstab corner. I want rows to be get…
VIRAL_ZONE
  • 43
  • 1
  • 7
1
vote
0 answers

Cognos report number formatting into 1 decimal form

I have two different reports in Cognos. Whereas in both the reports I have the field called "%Target". In the report 1 the field is directly coming from db and in the report 2 the field is formulated. My question is for e.g. if a value is 98.47%…
1
vote
3 answers

Cognos Report Studio (case statement) - Syntax error

I have a case statement in Cognos report studio in which if the date is 1st of the current month of previous year then it should fetch data for last whole month (1 to the last date) data of the previous year. I think it is a syntax error. Below is…
VIRAL_ZONE
  • 43
  • 1
  • 7
1
vote
1 answer

Is it possible to pass parameter in the cognos by SQL?

I am having SQL query as "select * from all_objects where owner = : owner;". Can it be possible to create prompt with this query in cognos 10.2.2.Please suggest me.
lucky
  • 25
  • 1
  • 6
1
vote
0 answers

Cognos Report Studio Error Invalid to Compare Sets

I am using Cognos Report Studio in Cognos 10.2.2. I am trying to create conditional rendering by displaying text the same color as the background (for the purpose of not suppressing a crosstab space) when certain conditions are met. It apppears to…
1
vote
1 answer

COGNOS Report Studio - How to view all tables/columns from a datasource using SQL?

I am creating a report on Report Studio, using SQL queries. I add the SQL object to the queries pane and set a data source. How can I list the datasource's tables (and the table's columns) using SQL queries? If it helps, the underlying database is…
1
vote
1 answer

How do you prevent a Cognos report from allowing you to filter data items that don't exist in the report?

I have a list report, and it pulls from a query subject that contains the following products: a, b, c, d, e. However, the report query contains a filter that filters for a, b, c. Once you execute the report in HTML it displays products a through…