Arul's.TEG Blog

By default, Cognos 10 allows external data files with up to 20,000 rows and a total file size of up to 2.5M, but some packages will not allow external data files with more than 1000 rows. Cause The ability to add external data is new in Cognos 10, and the limits on the rows and file size are controlled by two new governors in Framework Manager, Maximum external data row count and Maximum external data file size (KB). If a package has been imported from Cognos 8, it was published without these governors and will limit external data to only 1000 rows. Likewise, if the governor settings have been changed and the package republished, the limits will not be the default. Resolving the problem The issue can be corrected by opening the affected package in Framework Manager and updating the governor settings. Step: - Open the model for the package in Cognos 10 Framework Manager - Update/confirm the governor settings are as desired, - Re-publish the package.

Why does the audit reports have entries under the username that show as "not available"? The reason why there are entries as "not available" are that these are associated to bad logins into the C10 environment. If a user tried to login with invalid user credentials or no credentials, the audit database will capture these as entries with the username "not available". This however can be filtered from the report if it is not desired to see data associated to bad logins. Example: [Audit].[User Logins].[User name] not in ('not available')

How to skip the Welcome Page for all new user Edit the Default User Profile : The default user profile is defined in the Cognos namespace. It contains settings that apply to all new users. You can edit the default user profile for your users to minimize the number of changes you need to make to individual user profiles. After you change the default user profile, it applies only to users who log on to IBM® Cognos® software for the first time. The existing user profiles of other users are not affected. Steps:     In IBM Cognos Connection, in the upper-right corner, click Launch, IBM Cognos Administration.     On the Security tab, click Users, Groups, and Roles.     Click the Cognos namespace.     On the toolbar, click the edit default user profile button .     Set the default user profile and click OK. Each user who logs on to IBM Cognos software for the first time will automatically inherit these s...

This article describes techniques and options to consider when designing Framework Manager packages, beyond the documented durable model best practices, for maximum usability and user adoption. Key to these techniques is to know the end users: how they approach getting the data and how they will use the data. Dashboards should provide quick access to the relevant information that a User needs. We need to determine how to communicate the quantitative business data effectively in the form of graphs, consolidated and arranged on a single screen so that it can be monitored at a glance. High level durable model best practice refresh – 3 Layer example: 1. Architecting the Data Layer (also called the Physical or Database Layer) is mostly determined by the underlying data warehouse structure, with occasional role playing dimensions. 2.    The Model Layer (also called Working or Business Layer) is mostly determined by the general business relationships between data warehouse tables. A...

1. Is there anything special that a network printer needs to have done to it so that you can print to it? - as long as you can print to the printer outside of Cognos environment, then you can also set it up in Cognos Connection to print. Cognos just sends the request to the printer driver on your OS and it is the printer driver that actually communicates with the printer. One thing to remember is that the account which you use to run Cognos 8 service should also have permission to print to the printer. Reference: Installation and Configuration Guide (p.85) The account under which Cognos 8 runs must have access to all required resources, such as printers and Web servers. For example, on Windows, to print reports using a network printer, the account must already have access to the network printer, or you must assign a logon account to the Cognos 8 service. You can configure the Cognos 8 service to use a special user account by selecting the Cognos 8 service from the...

Reports with Master/Detail relationships failed after the Teradata was upgraded from version 12 to version 13. The reports fail with the following error.   Symptom "An error occurred while performing operation 'sqlPrepareWithOptions' status='-239'. UDA-SQL-0460 A general exception has occurred during local processing.UDA-EE-0036 The operator must be an expression, not "".   Resolving the problem Backup and edit the original cognos/c8/bin/cogdmod_td.ini file and insert the following line at the bottom: [DRIVER:TDATA32.DLL VERSION:13.00] SQL_API_SQLDESCRIBEPARAM="FALSE" Save and restart the cognos service(s) If multi-server install, then add the above line to all Dispatcher Machines as well and restart. Note: This is also true of Teradata 13.10. The Driver version number mus...