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
1
vote
0 answers

ibm cognos transformer multiple fact table not supported by dimension

i'm actually working on a solution that have two fact tables, and i need to add one more fact table so the etl work fine i add my new table to the pack in ibm framework manager , and i make relations between my fact table and other tables "tables…
a.mh
  • 11
  • 3
1
vote
0 answers

Cognos report column with zero width appearing

I have a Cognos report with a few calculation columns that are necessary not to be hidden otherwise there are alignment problems. The grouping is quite intricate and requires these columns to be there. In order to hide the calculation columns I set…
Dimitris
  • 2,030
  • 3
  • 27
  • 45
1
vote
1 answer

How can I remove the commas from a multi-select parameter in Cognos 10 Report Studio?

I started with a text prompt where a user can enter a string representing days in a single week. For example, M = Monday, and MWF can be typed in to choose Monday, Wednesday, and Friday. I've just changed the prompt to a multi-select value prompt,…
Rick Henderson
  • 326
  • 3
  • 14
1
vote
2 answers

Cognos 10 fixed MM/dd but variable year

Want to set July 01 as month and day but have a variable for the year. Always want to default to year of most recent past July 01. Has to work within the parameters present in Cognos 10.2. Tried several If statements with date2strings and…
Gilgo
  • 15
  • 4
1
vote
1 answer

Cognos, How can I track all burst reports and recipients

In Cognos environment there are many reports scheduled to be delivered to user's email id. How can I track all those reports without doing lot's of manual work. Using audit package's Run Jobs and Run Reports I am not able to track reports which are…
RanchiRhino
  • 786
  • 4
  • 21
1
vote
2 answers

removing duplicates in cognos 10 based on non duped column/field

The report below produces the id, name, primary (whether the user is the primary user or not (Y or N) and the date the user joined. I don't want any duplicate id's in the report and I want to base the condition to remove dupes on the primary column.…
chase_33
  • 11
  • 1
  • 3
1
vote
0 answers

Cognos Drill Through Report Issue With Boolean Variable

I'm running a drill though report on multiple pages. Page1 contains the source report. A target report is on Page2. I want the target report page to only render when a specific data item value is selected in the source report. Normally a Boolean…
hheld01
  • 11
  • 1
1
vote
1 answer

Can we reduce the column size and wrap the text in excel 2007 output of cognos report

Is there any way in cognos report studio where we can shrink the column width when the report runs in excel output. The column is really wide in excel output. Is there any way we can use javascript to reduce the column width in excel. The output…
Kashyap MNVL
  • 603
  • 4
  • 13
1
vote
0 answers

Display Missing Value in Chart Series in Conditional Palette in Cognos

My current scatter plot chart has a conditional palette for the series. I am able to set a specific color for each value except for missing values (or null values). I am able to see the text and color I have chosen for the missing values, but no…
Katie
  • 362
  • 3
  • 14
1
vote
0 answers

Cognos Report studio scenario for a report development

I have a scenario in which I have table A which has fixed data of 7 rows as below : Range 0-59 60-119 120-179 180-239 240-299 300-499 500+ Now I have another table B in which I have units.. I have to show all records of Table A and then the units…
Rajesh kumar Jha
  • 11
  • 1
1
vote
0 answers

Missing values in Cognos Report prompt

I have a problem with missing values in a Cognos Report Studio value prompt. I have two queries Query 1 contains business unit and sales (measure) Query 2 contains only business unit (no measures) Query 1 shows all the possible business units and…
Dag Eirik Bøe
  • 11
  • 1
1
vote
1 answer

Passing Data Source Connection value through URL in Cognos 10.x

I have a data source with multiple connections.I need to pass Data source connection as a parameter in the URL to select the connection at run time. Currently I get a prompt page for choosing the connection value. I don't want the prompt page to…
moh
  • 1,426
  • 2
  • 16
  • 43
1
vote
1 answer

Hide specific columns in Cognos 10

I have created a crosstab in Cognos 10 & I have specified the logic for each row. I also have specified the logic for the column but I have a problem. As shown in the attached picture, when I run the report, the column is showed 2 times. The column…
Marin
  • 69
  • 2
  • 12
1
vote
0 answers

Cognos - Get a Text 'Continued' every time the list breaks to a new page

I have a report with multiple lists in a single page. The output of the report is in PDF and the user wants an indicator like 'Continued' every time any of the list breaks from one page and goes to a new page. They don't want to set the pagination…
surya
  • 11
  • 1
1
vote
1 answer

Cognos - Showing every month on x-axis when some months don't have values

Let me first say I am very new to Cognos and have mainly learned by just manipulating items within active reports. I am having an issue with creating a graph that acts like a time series. I want it to display every month (with multiple values in…
Katie
  • 362
  • 3
  • 14
1 2 3
…
25 26