Turn on Cognos Auditing

Follw the next steps to turn on Auditing in Cognos Administration.

Cognos Configuration

1. Open Cognos Configuration

2. Right-click on Logging and from the popup menu select New Resource->Destination.

3. Name the new resource Audit, and leave the type as Database, then click OK.

4. Right-click on the resource Audit, and from the popup menu select  New Resource->Database.

5. Name the database resource, and change the type to, then click OK.

6. Select the database above, and enter the database details

7. Right-click on Audit, and from the popup menu select Test.

8. If the Audit database test is successful then click Close, else click Details and investigate the problem.

9. Now restart your cognos server.

Cognos Administration

1. Login to the Cognos Server with an Administrator Account

2. Select Administer Cognos Content

3. From the small menu on the left select System

4. From the Lower Right panel select Set Properties

cognos_audit_1

5. Select the Category Logging, change all values to Basic, and select the boxes Audit the native query for batch report service and Audit the native query for report service

cognos_audit_2

Steps found in an article on Toolbox.com, posted by Terry Curran

Also find more on the IBM website here

In the same article someone noted that there have been no changes in Cognos 10 regarding Auditing.

Email this to someoneShare on FacebookShare on LinkedInTweet about this on TwitterShare on Google+Pin on Pinterest

Ungroup repeating cells in Excel

One of the anoying things in Cognos 8.x was, when you export a report to Excel, that some grouped cells kept being grouped in Excel. So when a user wants to analyse data in Excel some data is missing (after ungrouping).

In Cognos 10 there is a property to solve this. Go to the report properties and deselect the option “Group repeating cells when exporting to Excel”

group_repeating_cells_cognos_10

 

Email this to someoneShare on FacebookShare on LinkedInTweet about this on TwitterShare on Google+Pin on Pinterest

Open MHT files in Firefox

When you start working with Cognos Active Reports you can save a report as a MHT file. To view these MHT files you can use Internet Explorer.

When you don’t want to use IE the alternative is Firefox. To open the MHT file you can use the plugin called UnMHT

UnMHT_Firefox_Plugin

You can find the plugin on this page: https://addons.mozilla.org/nl/firefox/addon/unmht/

After clicking on “Add to Firefox” you’ll get a warning

UnMHT_Firefox_Plugin_2

Click “Install” to finish the installation

After that drag a .mht file into the Firefox address bar and see the mht file gets opened properly

UnMHT_Firefox_Plugin_3

I must note that the functionality in Firefox is not the same as in Internet Explorer. The report is not really active.

Email this to someoneShare on FacebookShare on LinkedInTweet about this on TwitterShare on Google+Pin on Pinterest

Remove Deselect at the bottom Prompt

How to remove ‘Deselect’ at the bottom of the Radio Button Prompt in Report Studio.

In a report I created a custom prompt with two values. I changed the interface to radiobutton. With some javascript the first two lines were hidden, so you only see the two selectable values. Still there is “Deselect” visible and there is no need to see that. So I want to hide it, but how? Continue reading

Email this to someoneShare on FacebookShare on LinkedInTweet about this on TwitterShare on Google+Pin on Pinterest