cognos

Can we have customized "Date Prompt" in cognos8?

Hi, I am working with Cognos8 Report Studio. In my report there are two date prompts, (1) START date, (2) END date. Users can select two different dates or two same dates. But the report has valid data only for last business date of each month. For example, if Jan 31 is Sunday, valid data is available only for Jan 29 which is Friday(las...

Multi-select in the prompt is not working properly in Cognos 8.1

Changing a value prompt to a multi-select value prompt in Report studio, provide single select functionality. How can i get multi-select functionality? ...

Cognos 8 Javascript to select values in a multi select list box prompt

Hi, I have a multi select list box value prompt in Cognos 8.3. It contains values: Adelaide North Adelaide South Adelaide East Adelaide East Sydney North Sydney South Sydney East Sydney West etc. I want to able to add a button onto my prompt page that when clicked, selects predetermined options, such as Adelaide North, South Ea...

How do I change the top value name in a text box on a Cognos Report?

The default value for the first item in a drop down list is the name of the database field. I need to change it to a more user friendly name. How do I change the value? ...

Drop down list box with dynamic month and year in Date Prompt in Cognos

Hi all, I wanna add the current month and the last 2 months for user to select in prompt, e.g. if this month is 2008 Nov, then I wil see foowing in ddlbox 112008 102008 092008 may I know how to do it? no hard-code ...

What were the main disadvantages of CGI-BIN based web development?

I was fortunate enough to not do any cgi-bin .cgi based web development. But generally those who have do not seem to 'miss' those days. A project I recently joined has a performance issue when dealing with the pages that need to communicate to a legacy system that has a CGI-BIN based API. That system is COGNOS 7. The feedback I re...

Crosstab in Cognos

I have a set of data that needs to be displayed as a crosstab in Cognos. Example data includes ID, Month, Year, State 1, 10, 2008, 25 2, 10, 2008, 26 The problem is that in the crosstab, the month column is duplicated for each row instead of using the same column for the month. Example: ID 2008 2008 10 1...

Cognos 8.3 Framework manager forcing all date fields to date time fields

Cognos 8.3 BI Framework Manager is suddenly forcing all of our date fields to be date time fields. This is breaking solutions that have been working fine for over a year. Framework Manager is not allowing me to change the data type and the format property isn't having any effect at all no matter what settings I change. We're using Cog...

Cognos Javascript - How To Limit The # of Values Chosen in a Select & Search Prompt

Does anyone know how to limit the number of values that can be chosen in a multi-select Select And Search Prompt in Cognos 8? Currently the options are one or unlimited, and I want to write a little Javascript that limits a certain prompt to 5 or 10 values? Does anyone know how to accomplish this? ...

Statistics based marketing campaign measurement tools

Currently using SAS as measurement engine and Business Objects as display layer. Looking to develop a new, faster, slicker solution. Has anyone developed or purchased a campaign measurement reporting system? This solution should measure everything from email stats, web stats, customer activity, lift, ROI, etc. Ok.. I'm researching and ...

Can you export packaging information (ERD or other data model) from Cognos 8.3?

Hey, I was wondering if there's a way to export package information from Cognos 8 from a regular user level or from the framework level. For instance, I want the field names that cognos is pointing to on the database, i want the datatype, the description cognos uses when you right click a data element, etc.. Any suggestions? ...

How to access Cognos PowerPlay Cubes with other applications?

There are Cognos PowerPlay Cubes (Cognos v7.3) which are distributed via Email and then stored on local clients. At the moment, users use MS Access as an interface to access the data and reports in the Cubes. Is there any other tool, application or programming language which allows to access the PowerPlay Cubes and the tables/graphs wit...

Want help in setting up Cognos BI in J2EE conpliant server.

Hi, I am setting up IBM cognos BI in J2EE compliant server. If anyone knows how to do it please help me. Thanks & Regards, Kshitij Gupta ...

Default selection of checkbox group

I wanted to put checkbox in my cognos 8 report based on some condition i.e if condition is true checkbox will appear with click mark and if it is not then without click mark. could you please help me .... ...

Publish Cognos Content in Sharepoint 2003

What are my options? I'm researching a 3rd party called QueryVision, but would like to explore other alternatives. ...

Cognos 8 Introduction

Being a programmer who likes all things terminal (like Vim and the GNU tools), I've finally met my match. The company I work for has decided to move from an in-house developed report generator to the Cognos suite. We have had some informal meetings/workshops regarding the process of creating reports in Cognos, but I can't really make it...

Cognos 8.3 No Data Content issues

Upgrading from 8.2 to 8.3 and testing out the new No Data Content functionality. Report looks in order if results are returned. The No Data message does not appear. However if we test the report (pass in parameters expecting no results), we are returned a blank page (pdf, html, excel output). Not even the header or footer appear on t...

Cognos reports showing no data from url

I can run all my reports from report studio just fine. So its not a question of query or data or even report specs. When i call them from URL i am getting no data in the report. There obviously should be data. We had just upgraded from 8.2 to 8.3 and it is not all the reports... only a select few. This is serious problem since our u...

How to merge Cognos Reports

We currently have a manual process when we update reports on live.. from our test environment.... to manually merge changes into our new development environment. This is tedious. Is there a way to automatically merge two version of the same report so both changes take? Is it possible to merge the xml report specs of the two? without ...

Is there a tool to determine which Cognos 8.x models are being used?

We have a Cognos 8.x installation with hundreds of reports and dozens of models. We believe that many of the models are not currently in use on any reports and want to remove those models. Are there any tools that can be run against Cognos to list which reports are using which model? ...