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...
Changing a value prompt to a multi-select value prompt in Report studio, provide single select functionality. How can i get multi-select functionality? ...
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...
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? ...
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 ...
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...
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 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...
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? ...
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 ...
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? ...
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...
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 ...
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 .... ...
What are my options? I'm researching a 3rd party called QueryVision, but would like to explore other alternatives. ...
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...
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...
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...
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 ...
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? ...