Logging Database and Reports Currently Running

While researching an issue we were having, I really started studying the COGIPF_RUNREPORT table and found the COGIPF_LOCALTIMESTAMP column has the start time of the report while the report is running and the end time once the report completes. Note the COGIPF_RUNTIME will be 0 while the report is running. Thus I’ve [...]

LAE Import Failed – Locked out of Access Manager

I received an error while importing an LAE file to access manager and I was completely locked out. I had created a LAE file from production and was moving it to development. Before I imported anything into development, I did export the [...]

Cognos Model Issues

We’ve had a few problems with our scheduled cube builds. The process will begin to create the cubes and will hang until I manually go in and stop the scheduled task. Then I have to end the transformer.exe process in task manager. The funny thing is that when I go [...]

Time with a Cognos Performance Specialist Coming up

I got this in my email today – kind of good to get another person's perspective on Cognos performance.  I'll write up my notes and publish what I learn.

I would like to bring ******* in to take a look at the Cognos environment and get his thoughts how to improve performance. He will be [...]

Error Opening Cognos 8 Framework Manager

When accessing Framework Manager today, in our development environment, we were getting an error when trying to open an existing project or create a new one:

BME-EX-0047 Unable to read preferences for the requested interface..: “BME-EX-0047 Unable to read preferences for the requested interface. Please use another repository and/or ProjectAccess Interface.”

I found the knowledge base article [...]

Issue with Cube Builds

My cube builds tonight hit an error and wouldn’t failed when trying to be built. I opened up the model in transformer and went to manually build the cubes. About 30 seconds into it, I got an error about 2nd item number is supposed to be unique and an item number already existed.

The [...]

Model Versioning

I had an issue yesterday where a report ran fine. A new package wasthen published and the report stopped working. When I published thepackage, the model versioning option was set to save two copies of themodel. Since the model broke the reports, I then rolled back thechanges. When the user ran [...]

Creating a RSS Channel to Inform Users When Cubes are Refreshed: Supportlink

Creating a RSS Channel to Inform Users When Cubes are Refreshed: Supportlink: “Creating a RSS Channel to Inform Users When Cubes are Refreshed”

What I’ve learned for Cognos 8 and cube publication

I had to publish cubes this weekend, for the first time in our Cognos 8 environment. Here’s what I had to learn on the fly.

The path of a published cube is per server, not based on the dispatcher.
Data sources for cubes are referenced in the IQD files (which stands for Impromptu Query Definition), and [...]

Cognos 8 Performance Tuning

Cognos 8 Services Level:

Adjusting for peak vs. off-peak usage may benefit from changing the properties for:

• ReportService – used for interactive usage (user driven, on-demand)

• [...]