How do I update the password for a Cognos Data Source?
The db password expired and it needs to be updated, how do I update the password for a Cognos Data Source? ...
cognos
cognos API and examples
Can anyone point me to a cognos API document and some example code? The best for me is that the API can be access thru python. But examples in other languages are good also. ...
Cognos : Persisting Checkbox state across Multiple Pages
Hi, On the Cognos Report Results Page, we need to have a checkbox for each row. The checkbox is designed using HTMLITEM tag. However, the problem we face is that the state of the checkbox (checked or unchecked) is not persisted when we go to the next page/previous page. I am very new to Cognos and I need to know if there is a way to d...
COGNOS 8 Bi value prompt
Currently I have a value prompt added to my report (with UI selected as List-Box) and the date item used is name 'YEAR'. Now when I run the report the values in the value prompt are seen as below: YEAR 2004 2005 2006 What I want to do is get rid of the year tag that is present in the output of the value prompt box, more clearly the ...
Multiselection in prompt using contains operator
We have a column in cognos which has the comma delimited values like (AIX1, AIX2,AIX3) in each rows. We want to multiselect the results where say AIX2,AIX3 contained. How do I do it in cognos. ...
Using a form HTML form in Cognos 8.4
Hi, Iam using a HTML form in my Cognos 8.4 report the code for which is seen below:- <form name="floodzone"><p> <input type="text" size="60" name="address" value="1600 Amphitheatre Pky, Mountain View, CA" /> <input type="button" value="Go!" onclick="showAddress();" /> </p> <div id="map_canvas" style="width: 1000px; height: 3...
Best method for pulling data out of SharePoint to use with a Business Intelligence application
Asked this first on serverfault, and someone recommended that I ask here. I'm looking for advice from anyone out there who has experience integrating SharePoint with a business intelligence application like Cognos. Our BI team wants to be able to report on data stored in SharePoint. Their tool of choice is Cognos. What's the best way t...
Cognos 8.3: Can I use parameters in conditional style expressions?
Hi, I have Start Date and End date parameters that work fine as filters on a query, as follows: [EMR Reporting].[Appointments].[Appointment Date] between ?Start Date? and ?End Date? But when I attempt to apply conditional styles to a field based on ?Start Date?, the report blows up. Should I be able to use parameter values in conditi...
QA Testing Strategies for Analytical Dashboards
My team is building an analytical dashboard for a SaaS/multi-tenant application using Cognos. The problem I am encountering is the right strategy for testing. Right now, testing one report with start and end date filters (in month/year format), one dimensional filter and two controls for selecting the measure (there are 7 measures, whic...
javascript for enabling/disabling 2 date range/date in Cognos
I am looking for javascript for enabling/disabling two date range/date prompts in Cognos. Does anyone have any javascript for disabling/enabling two date range prompts? If I select the Date1 prompt, then the Date2 prompt has to be greyed out and vice versa. I am using Cognos 8.3 SP2. ...
Cognos LAE Backup Automation (Batch File?)
Within Cognos 7.4 security.. one would create an LAE file to export all their users... directions here... http://www.cognos-install.co.uk/articles/backups/access%5Fmanager%5Fexport%5Fto%5Flae.asp Now you'll notice at the bottom "Finally, it is possible to build an automated process for this task, however this is outside of the scope o...
Cognos Schedule By Trigger - Unix
What would be the equivalent of trigger.bat in a UNIX Cognos installation? In a Windows installation, trigger based scheduling could be achieved managing the trigger.bat file. At least in the UNIX box I'm working on, there's no file named like that. ...
Cognos 8 SDK: How to get Subgroups of a Group ?
Hi, I try to get the Subgroup of a Group in the standard Cognos Namespace. Quering the Contentstore to get ALL groups works fine. The standard methodes to get "members" of objects return the users or only the "root" group (the group I want the subgroups of). Nothing else.... Am I doing something wrong or is it just "not to be done" ? ...
Cognos copying between servers
Is it possible to copy objects (cubes, reports, setup) from one cognos 8 installation to another? For instance if a software consultancy company were to develop a cognos solution for a client then would the consultancy need to do everything on the client's servers directly, or can they develop it on their own server and send everything t...
Cognos 8.3 - date prompt macro problem
In Report Studio 8.3, I've got this raw SQL query running against a MySQL 5.1 data source: SELECT enc.encounterID, enc.date FROM enc WHERE enc.date between #prompt('textPromptStartDate')# AND #prompt('textPromptEndDate', 'date')# This produces text prompts for the user. If the user enters dates into these prompts in the format of 'YYY...
Cognos 8 API Integration with asp.net
Guys, I wanted to integrate cognos 8 and fetch the reports in excel/xml/csv format from cognos server. I don't have much knowledge about cognos, so can you provide me some pointers to start this process. Right now, i'm accessing the Cognos 8 server using IBM's sandbox server, is it possible to use this server as a testing interface? can...
Cognos: Using DataItem value in conditional variable expression
Hi all, I've a list which has a column 'YEAR'. I want to make the recent year(2010) appear bold in that 'YEAR' column. I tried this expression IF ( [myQuery].[YEAR] = [myQuery].[RECENT_YEAR]) THEN ( "RecentYearBold" ) where [RECENT_YEAR] is a DataItem with the expression maximum([YEAR]) This throws me an error and it doesn't all...
What are some good Cognos tutorials?
i am a data analyst and programmer and i want to learn cognos. i suppose the only way to do it is to either pay 10k for classes or get an internship where i shadow someone who already uses it. does anyone know how i can get a tutorial for cognos and put on my resume that i reasonable understand how to use it? ...
What are the other good blogs on Cognos apart from Cognos-tutorials.blogspot
What are the other good blogs on Cognos apart from Cognos-tutorials.blogspot ...
Please explain about AbInitio recovery file(.rec)?When should we roll back the file?
Hi All, Please tell the concept of AbInitio recovery file. When the Abinitio graph fails in execution which cases should we rollback the recovery file and in which cases we shouldnt rollback the recovery file. Please provide links for any AbInitio materials. Thanks. ...