Arul's.TEG Blog

Unable to install Cognos Consolidation on a server or workstation. When you start the installation it is aborted and gives you the following error message. Error Message - Setup cannot continue because of an outstanding reboot. Resolving the problem Delete the gsuninstall.flg file located in the user's temp directory. Steps - 1. Find the user's environment variables for TEMP and TMP. 2. Using Windows Explorer, navigate to the Temp directory. 3. Find the gsuninstall.flg file and delete the file. You can now install without rebooting.

Limited testing shows the following administrative pages can be called independently: http://localhost/cognos8X/cgi-bin/cognos.cgi/cogadmin/myactivities http://localhost/cognos8X/cgi-bin/cognos.cgi/cogadmin/cogadminFragments/capabilities http://localhost/cognos8X/cgi-bin/cognos.cgi/cogadmin/cogadminFragments/printers http://localhost/cognos8X/cgi-bin/cognos.cgi/cogadmin/cogadminFragments/styles http://localhost/cognos8X/cgi-bin/cognos.cgi/cogadmin/cogadminFragments/system http://localhost/cognos8X/cgi-bin/cognos.cgi/cogadmin/cogadminFragments/relationships http://localhost/cognos8X/cgi-bin/cognos.cgi/cogadmin/cogadminFragments/metrics http://localhost/cognos8X/cgi-bin/cognos.cgi/cogadmin/cogadminFragments/settings http://localhost/cognos8X/cgi-bin/cognos.cgi/cogadmin/cogadminFragments/powerplay8

Error : RSV-BBP-0021 when users save big report in CSV format Users are unable to generate Delimited text (CSV) files for large report (500+ MG in size for CSV format). Receive the following error: Failure RSV-BBP-0021 The operation 'getOutput' is not allowed at this time. Symptom Cognos system administrator is able to successfully run and create the report outputs in CSV format. Users can run small reports in CSV formats successfully. Running the large report in HTML format is fine. Running report in PDF format generates different error: .RSV-SRV-0040 Cause This problem is caused by the size of data Environment Windows Resolving the problem Set a big value to CM parameter CM.MULTIPARTREQUESTMAXLENGTH - Go to Cognos Administration - Click System, expand the services ...

Problem : Received error message below when attempted to save to Excel 2007 ppdsweb/source/XtabOutput.cpp(327): CPPWebException: CCL_THROW: XtabOutput::doOutputppdsweb/source/XtabOutputXLSX.cpp(932): CPPWebException: CCL_THROW: XtabOutputXLSX::render() Solution:  Copy the ppwb folder from     <GATEWAY_INSTALL>\webcontent\ppwb to                                   <APPLICATION_TIER_INSTALL>\webcontent\ppwb

Database server administrators can log and analyze the dynamic SQL workload generated by IBM Cognos 8. As an IBM Cognos 8 administrator, you can define a custom string that includes application context that is added as a comment marker within SQL generated by the application. You can use literals, macros, and session variables, such as a user name, server name, qualified report path, and so on, to customize the comment generated by Cognos 8. By using the applicable session variables, you can configure the format of the string for specific tools and products that can extract comments from dynamic SQL. IBM Cognos 8 includes the comments within any dynamic SQL it generates to a Relational Database Management System (RDBMS) if the vendor supports this functionality. Use the CQEConfig.xml.sample file included with the product to customize the string specifications. The macro in this file shows the default entries that IBM Cognos 8 uses for generating the comments. However, you can add oth...

In order to create a user experience that takes advantage of standard touch interface interactions, the swiping gesture can be implemented on Decks or Data Decks. This functionality is complemented by the Iterator control, which can be configured to appear as page dots to indicate the current selection. The following high-level procedure can be followed to enable swiping and obtain the corresponding page indicator dot look and feel for the Iterator control: •    Ensure that the Iterator and the Deck are driven by the same values •    Create a variable to be used to control the selection •    Configure the Interactive Behaviour of both the Iterator and the Deck so that each control sets (Set Variable Values) and is selected by (Container Select) the same variable •    Enable the desired Slide Animation Direction effect on the Deck •    For the Iterator control, ensure that the Iterator First, Iterator Previous, ...

What are the required database account permissions for Cognos content store? SQL Server - Grant create and drop table privileges for the database to the user account. - Ensure that the user account is a member of the db_ddladmin, db_datareader, and db_datawriter roles. - Ensure that the user is the owner of their default schema. Oracle - connect to the database. - create, alter, and drop tables, triggers, views, procedures, and sequences (all permissions must be granted directly to the user account rather than to a role). - insert, update, and delete data in the database tables Sybase - Grant create and drop table privileges on the database to the user account. - Ensure that the user account has the following privileges for the database: create default, create procedure, create rule, create table, and create view. DB2 - Grant create and drop table privileges on the database to the user account. - Ensure that the user account has CREATETAB, CONNECT and IMPLICITSCHEMA p...

http://public.dhe.ibm.com/software/dw/dm/cognos/infrastructure/web_servers/ibm_cognos8_bi_and_ep_with_iis7.pdf

What is a RTModel and can they be deleted? Solution RTModels (Run Time Models) are a compiled representation of the models pulled from the Content Store database. When the package is updated or if there is no RTModel file available in the data directory, one is recompiled when the package is accessed. The previous version of the RTmodel file are not deleted These files in this directory c8/data/cqe/ are local copies of the Run Time Model. In the configuration manager you can change this location under environment -> 'Data Files Location'. Restart Cognos 8 service and the RTModels will be created there. RTModel files are created when the first user has accessed the published package. These files can be deleted, but will be recreated again once the package is accessed again.

http://public.dhe.ibm.com/software/data/sw-library/cognos/demos/od_whats_new_with_ibm_cognos_business_intelligence_v101/demo.html

Set the Report Size Limit for the Report Data Service To limit the resources, such as memory, that are used by Report data service, IBM® Cognos® software restricts the size of the report data that can be sent out. If you receive errors in IBM Cognos for Microsoft® Office that a report result is too large, you can increase the size limit for report data by changing the Governor limit setting. The maximum execution time setting has priority over this setting. Steps 1.Start IBM Cognos Connection. 2.In the upper-right corner, click Launch, IBM Cognos Administration. 3.On the Status tab, click System. 4.In the upper-left corner of the Scorecard pane, click the arrow to view the Change view menu. Click Services, and then click Report Data. 5.Click the arrow next to ReportDataService to view the Actions menu, and then click Set properties. 6.Click the Settings tab. 7.In the Value column, change the number for Governor limit (MB). 8.Click OK.

Setting E-mail Attachment Maximum Size Configuration Parameters In IBM® Cognos® BI, you can choose to limit the size of e-mail attachments to avoid potential problems with abnormally large items. The allowable range is from 0-2047 MB. If you do not specify a value, then Cognos Connection applies no restrictions to the size of the e-mail attachment. Before setting the e-mail size limit in Cognos Connection, you must know the e-mail size limit set in the e-mail server. The limit typically set by an e-mail server administrator is from 10 to 25 MB. If you need to deliver reports with a larger file size, consider using a different file transfer method, like FTP or secure copy. If the limit set in Cognos Connection is lower than in the e-mail server, then the Cognos Connection setting overrides the e-mail server setting. For example, if the Cognos limit is 10 MB and the e-mail server limit is 20 MB, then a 15 MB attachment will be replaced with a plain text file containing a warning mes...

The IBM Redguide IBM Cognos Business Intelligence V10.1: Intelligence Unleashed highlights features of IBM Cognos BI V10.1 from a business perspective. Use this Redguide to realize the full potential of IBM Cognos BI. The IBM Redbook IBM Cognos Business Intelligence V10.1 Handbook provides in-depth hands-on coverage of IBM Cognos BI V10.1. The book is primarily focused on the roles of Advanced Business User, Professional Report Author, Modeler, Administrator, and IT Architect.