Clear Parameter Values

When you are developing a report and run it to test, value are stored from filters or the source connection. This is done so you won’t have to fill them in every time you test.

Sometimes you want to select a different source. For example first you test on DEV connection and now you want to test with QA connection.

To achieve this you want to clear the reports cached values. This can be done in Report Studio by selecting File > Clear Parameter Values

 

 

 

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

PRS-TRS-0906 after copy paste text

Issue PRS-TRS-0906

I was creating a report schedule for the user. The user provided text to add to the email body of the scheduled report. After pasting the text and clicking OK, it resulted in Error PRS-TRS-0906 The “VALIDATE” transform instruction could not validate the given XML content”

Cause

The issue was caused by copy/paste of text from the users email. This text was copied from the users email and seems to contain attributes that cognos can’t handle.

Solution

Paste the users text to notepad and copied from notepad to the body of the email. Then switched the setting to “Change to HTML format”.

The requested styling could be provided now such as bold and underlined.

Similar solution was descibed on Cognoise.com:

http://www.cognoise.com/index.php?topic=4329.0

 

 

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

CNC-SDS-0413

Got some schedules in my Cognos environment who failed with the message:

CNC-SDS-0413 There was a problem in executing the task. The user authentication failed. It may not be possible to rerun the task.

To solve this I followed the next steps:

1. Renew the credentials (see how on this article)

2. Go to System Administration

3. Click on Schedules

4. Find the schedule with the error in the list

5. Click on the small blue triangle

6. Choose modify the schedule

7. Change nothing

8. Click OK to save the schedule

After that you can check the schedule on the next upcomming event.

 

 

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

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