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
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
  • 479
  • 7
  • 23
2
votes
2 answers

How to invoke second page only when List data moves to it

I am creating client invoice statements. Clients sometimes have a large number of invoices. The report has two sections. The first is the header, with company and client address info, etc. The second part is a list containing the invoices. If a…
jabs
  • 1,694
  • 4
  • 19
  • 36
2
votes
1 answer

Dynamically adding pages in cognos reports

I have a requirement to fulfill where i have to fetch data from the data source.. In that the number of pages in a report might vary due to the number of times the customer has purchased. Basically Customer Number is the primary Key and based on the…
Raghu
  • 817
  • 1
  • 7
  • 21
2
votes
1 answer

Cognos 10.2 Using row values in prompt to filter another prompt

I am new to Cognos and wondering how or if possible to achieve the following. Firstly, I have a table: Period Id Name Start_Date End_Date 1 a 01/04/2011 06/08/2013 I can create a prompt to select the Period Id from the…
Darklantern
  • 81
  • 4
  • 10
2
votes
1 answer

How to prevent label truncation in a Cognos BI Pie Chart

I'm trying to create a pie chart in Cognos BI that shows complete labels. I can't figure out how to do this. I have included an image that shows how the current report truncates the labels and places three dots (...) at the end of each label. I have…
2
votes
2 answers

Dynamic SQL versus using the model

We started using COGNOS about 3 years ago. We have used COGNOS 8 and are now on COGNOS 10. We are constantly being told that using dynamic SQL queries instead of using the COGNOS model is extremely bad in that it causes performance issues and that…
Mark
  • 135
  • 2
  • 14
2
votes
2 answers

Getting logon error in Cognos bi 10.2 while running it

Hi I am new to cognos and using the trial version of cognos(bi_dev_trial_ed_10.2.1_win_en) and getting this error while running it Error: QE-DEF-0325 The logon failed for the following reason:RQP-DEF-0068 Unable to connect to at least one database…
Raghu
  • 817
  • 1
  • 7
  • 21
2
votes
0 answers

I have an iframe that expands and when opened, i want it to resize based on the content. Here is my iframe logic. Any suggestions please?

I have an iframe that expands and when opened, i want it to resize based on the content. Here is my iframe logic. Any suggestions please? Here is my iframe script: