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.

324 questions
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
  • 603
  • 11
  • 20
  • 48
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
  • 939
  • 5
  • 14
  • 35
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
  • 197
  • 1
  • 8
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
  • 603
  • 11
  • 20
  • 48
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 Akram
  • 3,134
  • 11
  • 47
  • 65
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
  • 603
  • 11
  • 20
  • 48
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
  • 603
  • 11
  • 20
  • 48
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
  • 603
  • 11
  • 20
  • 48
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
  • 1
  • 5
0
votes
1 answer

Cognos 8 Reports- Specify decimal separator for different locales

I have a Cognos-8 based report which has several number columns. I have set the decimal separator for these columns explicilty as Number Decimal Places: 2 Decimal Separator: period (.) Negative number symbol: () When I run the report in the…
uno
  • 99
  • 1
  • 2
  • 11
0
votes
1 answer

Issue in Conditional hiding in cognos report ver 10

I already have a conditional block which controls 10 charts like chart 1 .....chart 10 based on block variable called 'Chart' now I have to conditionally hide chart 3 , bcoz the design of chart 3 differs based on prompt value = complex. So I tried…
Raj
  • 21
  • 1
  • 5
0
votes
1 answer

Limit data to be generated in cognos cube generation by year

Ive been working with cognos from a year now but I stumble into another problem that needs urgent workaround resolution. I have this model that automatically generates cube (using a batch file) every day. the generation is successful although the…
jrdb0916
  • 1
  • 1
0
votes
1 answer

How can I fix excel appearance in cognos ?

I make a report as pdf.It s fine. But when I export it to excel ,there are many sheets on excel . I do not wan to it.I want to 1 sheet.How can I fix this? Thanks.
Ersin Gülbahar
  • 6,344
  • 14
  • 54
  • 105
1 2 3
…
21
22