Arul's.TEG Blog

To prevent users from sending reports as email attachments, modify the system file system.xml. This change hides the Include the report check box under Attachments in the Set the email options dialog box. This restriction applies to all IBM® Cognos® Business Intelligence users. Steps 1.Stop the IBM Cognos service. 2.Open the c10_location/templates/ps/portal/system.xml file in an XML or text editor. For pages and dashboards, open the c10_location/templates/ps/system.xml file. 3.Add the following XML code to the <system> element: <param name="ui_hide">   <CC_RUN_OPTIONS_email_attachment/> </param>If you hide other user interface elements by modifying the system.xml file , the <param name="ui_hide"> element already exists. In this case, add the following to the element: <CC_RUN_OPTIONS_email_attachment/> 2.Save the file. 3.Start the IBM Cognos service.

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 settings but can change them later.

When you burst/save HTML outputs, you must have noticed that Cognos by default paginates the outputs with the default value being 20 rows per page. In saved outputs, this causes sections of the report to repeat down the length of the single HTML page. This can be avoided by setting the rows per page property for report objects. However, you can also set "Paginate saved HTML output" available under File Menu > Report Properties to achieve the same. This property saves users from having to set a very high value for the Rows Per Page property against each report object.