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

373 questions
5
votes
1 answer

IBM Cognos Report Studio: Value prompt default selection from prompt "default text" parameter

I have a value prompt that references the parameter 'Year_Parameter', and a list with one column (a Data Item Expression) that references the same parameter as the value prompt in this way: #prompt('Year_Parameter')# The value prompt has some…
Skovly
  • 224
  • 1
  • 8
  • 22
4
votes
1 answer

Cognos equivalent of excel's sumif() function

I'm familiar with Excel and SQL, but new to Cognos. I'm doing a conditional sum on [Total Margin] for each [Item Code]. This result should show on each row for the each item. I've tried 2 approaches in Cognos and a proof of concept in Excel. See…
Fractional
  • 153
  • 2
  • 10
4
votes
1 answer

iSeries Datasource Locking

I have a data source set up on my AS400 (iSeries) and when Cognos accesses it through the client access ODBC driver, it locks the files on the AS400. Even if the report closes the files remain locked for a length of time. This causes issues with…
Jeff
  • 179
  • 2
  • 12
3
votes
1 answer

Error while connecting IBM Cognos 10.2.1 with Hive 0.11

I am trying to have Hive as a data source for Cognos 10.2.1. I am having Hive version 0.11. I placed the following Jars from the Hive server to Cognos Installation Directories (cognos_install_Directory\webapps\p2pd\WEB-INF\lib and…
Pavan Kumar
  • 205
  • 1
  • 13
3
votes
1 answer

How can we use JQuery in mht files?

I generated some active reports in cognos. Then I got across with this Dynamic reporting in Cognos using JQuery: http://www.ibm.com/developerworks/library/ba-pp-reporting-advanced-report-design-page647/ I generated some interactive reports with…
MChirukuri
  • 592
  • 5
  • 28
2
votes
1 answer

Trouble with formatting date prompt in Cognos Report Studio Version 10.2.1

I'm having trouble with an error that says: UDA-SQL-0144 An arithmetic exception was detected.[IBM][CLI Driver][DB2/NT64] SQL20448N "1993" cannot be interpreted using format string "YYYY-MM-DD" for the TIMESTAMP_FORMAT function. SQLSTATE=22007 I'm…
Jure Turjak
  • 53
  • 7
2
votes
1 answer

Need help building a Data Item in Cognos Report Studio

So I have a table with employee name, job and shift. Each employee (Row) has a unique name, a non unique job and one of 4 shifts (A, B, ,C or D). I want to create a Data Item called "Shift A Employees" that that for each job it spits out one…
Isaiah Beets
  • 23
  • 2
2
votes
1 answer

How to change Chore properties in cognos-tm1 process?

I need to turn on\off chore or change it's start time during proceess regarding some conditions, how can i do this?
Horosho
  • 613
  • 7
  • 21
2
votes
1 answer

How to create banded columns in Cognos Report Studio

How do you create banded columns in Cognos Report Studio? Here is an example of banded columns taken from this link: EDIT: Maybe this search string will help find this page? "Cognos Report Studio, how to create column band"
Soenhay
  • 3,628
  • 4
  • 29
  • 53
2
votes
0 answers

DPR-ERR-2002 While Connection Cognos 10.2.1 with Hive 0.11

I am new to Cognos and trying to connect Apache Hive 0.11 to visualize the data which is in Hadoop. I am using JDBC connectivity for doing this. While trying to connect these two systems, I got the following error, DPR-ERR-2002 Unable to execute the…
Pavan Kumar
  • 205
  • 1
  • 13
2
votes
1 answer

Add blank column to query

Is there a way to add a blank column to a query in Query Studio? I tried to use a calculation on an existing column but the only options that I get are for First Characters, Last Characters, Concatenation, and Remove Trailing Spaces. None of these…
Mark
  • 115
  • 2
  • 13
2
votes
3 answers

Using Cognos 10.1 which is better an Inner Join or an "IN" Filter?

I'm using Cognos 10.1 and I have a report that uses two queries each with the same primary key. Query 1: UniqueIds Query 2: DetailedInfo I'm not sure how to tell whether it's better build a report using the DetailedInfo query with a filter that…
Michael Riley - AKA Gunny
  • 5,058
  • 4
  • 38
  • 78
2
votes
1 answer

Is there any way to avoid the top rows with NULL values that has one column value (One of the table Business Key) in Cognos report prompt values

Is there any way to avoid the top rows with NULL values that has one column value (One of the table Business Key) in Cognos report prompt values When the user does not select any value in the value prompt (Cognos Report Portal) and clicks FINISH…
BongReyes
  • 195
  • 1
  • 4
  • 15
2
votes
2 answers

Auto update reports generated in report studio, when new rows are added in database

I am using Cognos 10. I have created a model in FM using some tables in DB2. Then I have created a package and published it. I have also generated reports on this in report studio. Everything went well and the report looks fine. Now the actual…
MChirukuri
  • 592
  • 5
  • 28
2
votes
1 answer

Cognos Calculate Variance Crosstab (Dimensional)

This is very similar to Cognos Calculate Variance Crosstab (Relational), but my data source is dimensional. I have a simple crosstab such as this: | 04-13-2013 | 04-13-2014 --------------------------------------- Sold | 75 …
Abraham
  • 460
  • 4
  • 22
1
2 3
…
24 25