Arul's.TEG Blog

Watch Rules in Saved Reports Create a watch rule for a report Use watch rules to monitor user-defined events in saved HTML reports. When the report is saved and the watch rule is satisfied, you are alerted by email or news item. Enable Watch Rules for a Report To allow watch rules for a report, you must have write permission for the report. Steps 1. In IBM Cognos Connection, click the set properties button next to the report. 2. On the Report tab for Report Studio reports, the Query tab for Query Studio reports, or the Analysis tab for Analysis Studio reports, under Advanced options, select the Enable selection-based interactivity in HTML reports and Enable enhanced user features in saved output versions check boxes. Selecting these options specifies that additional context information is saved with the report output. 3. Click OK. After selecting the advanced options, you must run the report and save the report output in HTML format before users can create watch rules. Cre

Try IBM Cognos 8 Business Intelligence V8.4.1 online for 4 hours without installing it on your own system (multiple trials allowed). IBM Cognos 8 Business Intelligence provides complete BI capabilities on a single, service-oriented architecture. Evaluate Cognos 8 Business Intelligence V8.4 online, without installing or configuring it on your own system. Note: When you start your online trial, you will have four hours to explore the product. If you need additional time, you can sign in again. Refer : http://www.ibm.com/developerworks/downloads/im/cognosbi/tryonline.html#onlinetrialprereq

1. Add a List page header 2. Add a list row cell above list page header so you have 2 rows in your header (done form the Structure menu) 3. Unlock your report 4. Split your header row 5. Drag your column titles into the bottom row 6. Join your top columns based on your criteria. 7. Do your formatting (if using Cognos default change the class to list column title cell) 8. Go to your list properties and Change Column Titles to 'Hide' 9. Run your report. Your Column titles should appear at the start of each page.

Use below code in filter: ((#sq(prompt('P_PARAMETER', 'token', 'testValue'))# <> 'testValue') and FM.QUERY_SUBJECT.QUERY_ITEM in (#csv( split(',', substitute(' ','', prompt('P_PARAMETER', 'token')) ) )#) ) or ((#sq(prompt('P_PARAMETER', 'token', 'testValue'))# = 'testValue'))

Scheduled Report is getting failed and not delivered to the specified email id in Cognos 8.4 Reason for getting failed : RSV-DST-0004 You must save the report output before you can mail a report link. When you selected to send the report, You haven't set to save to report, but you have selected to send the report output link along with the report output. This case it will fail b'coz there is no report saved to send the output link in the mail so please uncheck the same and try again. Bug reported to Cognos and its been fixed in Cognos 8.4.1 version

What does it mean to run in 64 bit? The most common understanding is that running on a 64-bit platform will allow your applications to access far more physical memory than what was previously available within the constraints of a 32-bit architecture. In addition, many applications can take advantage of the 64-bit registers to allow for faster and more efficient execution. Of course for an existing 32-bit application to work with these new capabilities it must often be completely rewritten and compiled to utilize these advantages. This can be a very expensive proposition for many software companies and in many cases they will simply rewrite or recompile those components of their code that can be easily ported, at a minimal cost, to true 64-bit architecture. For example, java applications are architecture agnostic meaning that a complied Java program can run in either a 64-bit or 32-bit Java virtual machine (JVM). 64-bit BI SDK - Yes BI Samples - Yes BI Modeling - No BI Se