Stack Overflow
Stack Overflow

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
0
votes
0 answers

Remove old reports from IBM Cognos UI for BI

We have some old reports which are not being used anymore by the business and wish to remove/archive these. I have 2 queries related to this: a) What is the best way to find if a report has not been used for the past 12+ months? b) Is there any…
gagneet
  • 35,729
  • 29
  • 78
  • 113
0
votes
2 answers

Search and Select box does not have a default value

We have a report that requires users to be able to search from a field [Templates] and then select the 1 or more than 1 Templates to filter by. However, the report spec. also calls to be able to return the set of all Templates. I have done a lot…
ASheppardWork
  • 95
  • 1
  • 2
  • 12
0
votes
1 answer

cognos creating full time format

I keep searching and trying to find way to display time that i subtract between two time stamp as full format like hours:mins:secounds not just hours or mins only did anyone pass that before thanks!
user3734290
  • 41
  • 1
  • 11
0
votes
1 answer

Cognos Chart add values on it active report

I created chart to show all data by 24 hours of the day the thing here it only show that in in the 24 hours for example it might show only 13 as there no other intersect in the database i want to show all 24 hour and it hit the column on 13 if it's…
user3801861
  • 1
  • 2
0
votes
2 answers

Cognos direct link to report without username or password

I have Cognos report that i want it when clicking on it's URI to get direct into it without requesting the username and password any suggestion about methods that could be used ?, i have no problem to make the URI use default username and password…
user3734290
  • 41
  • 1
  • 11
0
votes
1 answer

Cognos Chart filtering

I made the pie chart clickable in active report and linked to data deck and to filter on lists but the thing here if it's possible to multi select on chart and how to make it reset to show all items I can't make it anti select so it show all as when…
user3734290
  • 41
  • 1
  • 11
0
votes
1 answer

Cognos Promptmany function

I'm trying to use promptmany function to make the prompt optional to the user incase didn't select be default value as arrival announced the thing here when i use the function : [STAGES] in (#promptmany ('STAGES','string','Arrival announced')#) I…
user3801861
  • 1
  • 2
0
votes
0 answers

One cross tab shows values of 10 queries Cognos

I have 10 lists with queries and each of them have item called timetaken i want to show this item of the 10 lists in one cross tab in row and no coloumns show like 10 rows each for each timetkane in each of them Thanks
user3734290
  • 41
  • 1
  • 11
0
votes
1 answer

Using Union in Cognos BI

I have report that contain 10 queries each query has a filter related to a parameter. When I union them all and show them in a graph it's not condiring the filtering that been made on the each of the 10 queries it get all. Anyone have any advise…
user3801861
  • 1
  • 2
0
votes
1 answer

Performance tuning in Cognos Report Studio

Working in Cognos Report Studio 10.2.1. I have two query items. First query item is the base table which results in some million records. Second query item is coming from a different table. I need to LEFT OUTER JOIN the first query item with other.…
Excited_to_learn
  • 361
  • 3
  • 11
  • 25
0
votes
1 answer

SSO b/w cognos and websphere portal

I know we can enable SS b/w Cognos and WebSphere portal server using LTPA token or Shared secret. I know the steps to do to achieve this SSO, but If I am not using the cognos portlets in websphere portal, would the SSO work?
aryanRaj_kary
  • 503
  • 2
  • 7
  • 28
0
votes
0 answers

How to add automatic filters to Excel output in Cognos reports?

I am working on a project in Cognos Report Studio version 10.2.1. One of the business requirement is that the output format of the report should be in Excel 2007 with auto filter on the headers of the row. I tried inserting one html item above the…
Excited_to_learn
  • 361
  • 3
  • 11
  • 25
0
votes
2 answers

Incompatible data types in CASE STATEMENT

I am converting a SAS code into Cognos Report Studio version 10 where am stuck at a point where there is data formatting needed. IF SDW_STAT ^= '' THEN PRINCIPAL_BAL = TOT_PRIN; Where '' represnts single quotes without any space I tried writing a…
Excited_to_learn
  • 361
  • 3
  • 11
  • 25
0
votes
2 answers

How do I create a summary data item in Cognos Report Studio?

I am working on a Cognos Report Studio Version 10 where I have to convert SQL code into Data Items. I have all the Columns required in the package to drag as Data Items in the query but I am stuck where there's calculated fields. This is one of…
Excited_to_learn
  • 361
  • 3
  • 11
  • 25
0
votes
1 answer

Cognos Report - same query multiple times with different parameters to multiple tabs of 1 XLS

I need to produce a Cognos Report that produces 12 tabs. Each tab contains the same sort of report simply run for a different parameter value, for example, the month of the current year. I would like to reuse the SQL and define it only once and have…
Chad
  • 23,658
  • 51
  • 191
  • 321
1 2 3
…
25 26