Stack Overflow
Stack Overflow

Questions tagged [cognos-bi]

IBM Cognos Business Intelligence is a web-based, integrated business intelligence suite by IBM.

It provides a toolset for reporting, analysis, scorecarding, and monitoring of events and metrics. The software consists of several components to meet the different information requirements in a company.

358 questions
0
votes
2 answers

IBM Cognos Report Studio: Combining multiple tuples in order to create one intersection

I am consuming dimensional data (TM1 cubes) with Report Studio. I want to combine the slice given by two (or more) tuple calls. This is because I want to include two elements from the same dimension that is not logically structured in a dimensional…
Skovly
  • 234
  • 1
  • 8
  • 22
0
votes
2 answers

Cognos Report Studio Date slicers

I using a Report Studio with Cognos 10.1. I have a report in which I should implement a prompt like Last month and Last week. The problem is that I should implement the prompt without using a Detailed filters (for example with slicers or any other…
Petko Yanakiev
  • 159
  • 2
  • 8
0
votes
0 answers

Calling export reports as Pdf for entire dashboard widgets programmatically Cognos

Cognos provides option to export each widget in dashboard but not entire dashboard. My question is that is it possible to export all dashboard widgets as Pdf using cognos sdk for java. If not, is there a way to get each widget reports as pdf and…
Sva
  • 115
  • 1
  • 12
0
votes
1 answer

Automating Cognos Build in Transformer

All of a sudden, scheduled tasks that update the Cognos Cubes are getting failed. When I try to run it manually from the CMD it is getting executed successfully. But, when I try to create a bat file and run the below script nothing is happening.…
user2063055
0
votes
1 answer

Cognos drill-through

How to strip off the first word from a measure being selected in a chart in a source report and pass it to a target report so that it is consumed by a crosstab in that 2nd (target) report? So, for example, my Source report has a measure called [High…
David Rock
  • 1
0
votes
1 answer

How to use a calculated data item in a chart in cognos?

Currently I'm working in Cognos 10.1 and I'm facing this problem. I've a data item (date) and using that I've calculated the day of the date (i.e sunday, monday...etc). I want to use it in the chart X-axis, to find the total sales on each day.…
arunpandiyarajhen
  • 643
  • 12
  • 20
  • 51
0
votes
1 answer

How can I setup Data Sources in Cognos 10

When I attempt to create a new package a new window opens in order to select the desired data source from the list. The list is empty although I have succesfully defined and tested a datasource through Cognos Administration > Configuration > Data…
jayt.dev
  • 975
  • 6
  • 14
  • 36
0
votes
1 answer

What is the purpose of the Cognos SQL function/expression "ascii"?

I must translate a Cognos Impromptu 7 query to TSQL. Part of the query includes the following: nconvert((SUBSTRING((ascii(t1.TargetDate)) from 1 for 4))) /* where: t1 is a table alias TargetDate is a BIGINT contains the value…
EngineeringSQL
  • 207
  • 2
  • 10
0
votes
1 answer

What does "QE-DEF-0469 QE Message" mean?

I'm working on Cognos 10.1. For a report, I've updated the package. When I open the report in report studio, it is showing an error like QE-DEF-0469 QE Message. What does it mean? Earlier responses would be appreciated. Thanks.
arunpandiyarajhen
  • 643
  • 12
  • 20
  • 51
0
votes
1 answer

How to configure DB2 CLI driver on Windows 7 64bit for Cognos BI Framework Manager?

I am using Framework Manager (the data modeling tool) for Cognos Business Intelligence (v10.1). I have a successful setup of DB2 (v9.7) and Cognos BI on AIX machine. On my Windows machine I want to do some changes in my model that connects with DB2…
Tahir
  • 3,344
  • 14
  • 51
  • 69
0
votes
1 answer

How to control the report output in Cognos 10.1?

Currently I'm working Cognos 10.1 report studio. The requirement is that the output should be in such a way that the crosstab should appear in a default size in all the pages eventhough the outputs differ. The crosstab size should be same in all…
arunpandiyarajhen
  • 643
  • 12
  • 20
  • 51
0
votes
1 answer

How to pass two values when a bookmark is clicked in crosstab?

I'm working with a crosstab in cognos now. Page 1 contains crosstab Page 2 contains list Fact - Revenue Dimension - Product line, Year If I click on the revenue (cell value) it should goto the particular record in another list which is located in a…
arunpandiyarajhen
  • 643
  • 12
  • 20
  • 51
0
votes
2 answers

What is the error in this case...when statement?

Could anyone say what is the wrong with the below statement. Currently I'm working in cognos 10.1.1 case when extract(month,_last_of_month (current_date))=1 then ('January') when extract(month,_last_of_month (current_date))=2 then…
arunpandiyarajhen
  • 643
  • 12
  • 20
  • 51
0
votes
1 answer

How do I extract report data from MSAS and TM1 to Cognos?

How do I extract report data from MSAS and TM1 to Cognos? (Cognos 10, but even Cognos 8) I need to consolidate the data from two separate cubes: one from MSAS and another from TM1. I then need to extract it into a cognos report. Can anyone help me?…
Maria Adrianna
  • 1
0
votes
1 answer

Capture Value In Table Upper Case Or Lower case

I want to SELECT * FROM table1 WHERE name=petter Now if there is many type of petter in table like PETTER , Petter And petter. Want all this three (PETTER, Petter, petter) to be considered which command is for this in cognos report studio? Or in…
Raj
  • 21
  • 2
  • 5
1 2 3
…
23
24