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
2 answers

IBM Cognos IF/casewhen + _days_between

I have a liste of value and when a value = something i want it to calcultate a number of day between 2 dates. Error: "QE-DEF-0459 CCLException Incompatible data types in CASE statements" Exemple: CASE WHEN ([Statut dossier] = 'Att 1 sv') THEN…
sophie morin
  • 13
  • 2
1
vote
1 answer

How to generate Authentication Token in Cognos Analytics 11.x

I am very much new to IBM Cognos. I want to fetch the metadata from Cognos env.(cloud/on-prem) to my java application. Metadata like reports, dashboards, data sources, namespaces and etc. I am ready to use Java SDK or REST Services. So I want to…
Kranthi.Gogikar
  • 31
  • 5
1
vote
0 answers

Need a help to Run reports without html pagination

Currently, I am using Cognos BI 10.1.1. Now I want to write a program to execute a report in HTML format using Cognos SDK. But I am getting partial data instead of entire data but in PDF all data is displaying. My suspect is on Pagination. Can…
Vigneshwaran B
  • 13
  • 3
1
vote
0 answers

Cognos Analytics Rest Api/Api-docs 404 not found issue

I was using Cognos SDK for development purpose, now I am planning to shift to Cognos analytics server rest API. Following documentation, I tried to frame the URL as http:///api/api-docs, but I ended in 404 not…
Salman Khan
  • 11
  • 1
1
vote
1 answer

Cognos 10 Framework manager crashes with 'BMTUI2' error. 'An error is at the origin of this program malfunction. Close the program'

After adding new data source from Cognos production (content manager administration) and testing succeeded, I added the new data source in framework manager as mentioned in your doc and as my other datasources that are available. Upon testing the…
Georges Diab
  • 11
  • 1
1
vote
0 answers

Javascript change from cognos 10 to cognos 11.1.7

We recently switched over from Cognos 10 to Cognos 11.1.7, this code works fine in Cognos 10 and as we moved to Cognos 11 it broke some of the functionality. I was able to narrow down to this piece of code and I can't seem to figure out what is…
asim siddiqui
  • 11
  • 1
1
vote
0 answers

compute a division using list summary field in cognos report studio

I have a Cognos Report created by a List. I used the Total function the report has to create a row of Totals, i.e. Total [TodayOrderCount] and Total [#ShipmentDaysOrder]. I then need to compute a division: Total [#ShipmentDaysOrder]/Total…
Liliana
  • 11
  • 1
1
vote
1 answer

cognos navigation to next + 1 page javascript

I would like to create 3 navigations in Cognos 11 Report from prompt page, to be able to quick navigate to page2, page3 and page4. Below is script I found in internet, it uses JS and HTML item functionality. I used it in prompt page but Im able to…
johnt
  • 79
  • 6
1
vote
2 answers

Cognos Static prompt values to be passed to SQL

I have a static prompt which is a single select. In that I have two values lets call it A and B. So when I select option 'A' my report pulls all data from the DB which is expected. So when user Select option 'B' the report should pull only the…
Girish
  • 49
  • 8
1
vote
3 answers

Convert IBM Cognos SQL which contains a filter to Microsoft SQL Server Query

I'm trying to convert IBM Cognos SQL which contains a filter to Microsoft SQL Server Query. I tried to apply the filter in the Microsoft SQL Server Query, but it didn't work. Here the IBM Cognos Query: IBM Cognos SQL select rank() over ( at…
Newbie SQL
  • 122
  • 13
1
vote
1 answer

TM1 : Error :Incorrect syntax Near '|' (inserting numeric value into sql query)

I am trying to insert a numeric variable 'Value ' into a decimal database column. I used this query syntax : SQL= 'INSERT INTO DB_Archive VALUES ( '''| dim1|''' , '''| dim2|''', '|Value|') '; But it seems it's not correct way to declare a numeric…
newbie
  • 63
  • 1
  • 8
1
vote
1 answer

Adding parameters to SQL select and using them in Cognos Report Studio Version 10.2.1

I'm trying to put into my select a date parameter. I'm not sure how really to do this. Right now I have fixed date value in it and now I want to have a parameter like: StartDate and EndDate. I'll be really grateful for any help. My select: select…
George
  • 124
  • 1
  • 12
1
vote
1 answer

Filter query results where original fee and reversals wash to zero

In Cognos 10 query, What method is best to remove items from list below where the Fee charged and the fee assessed Tran Amounts are a wash, ie, sum to zero?
ORLANDO VAZQUEZ
  • 79
  • 8
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
  • 12
1
vote
1 answer

Retrieving Job Distribution List From Content Store

Using Cognos 10.2, I am trying to get a list of all my reports that are currently scheduled, and the distribution list that the scheduled reports will be sent to. I can get a list of all standalone reports that are scheduled on their own, and their…
MikeLanglois
  • 25
  • 7
1 2
3
…
25 26