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)

• [...]

Download details: Excel 2007 Document: Designing SQL Server 2005 Analysis Services Cubes for Excel 2007 PivotTables

Download details: Excel 2007 Document: Designing SQL Server 2005 Analysis Services Cubes for Excel 2007 PivotTables: “Excel 2007 Document: Designing SQL Server 2005 Analysis Services Cubes for Excel 2007 PivotTablesBrief DescriptionThis document outlines how to improve the end-user experience by optimizing the cube design for Microsoft Office Excel 2007 PivotTable dynamic views.”

WinSQL

Here's the tool I use to query and update the AS400 database.  It's called WinSQL – Download the latest greatest version of the lite version and open it up.  It will ask you to register, do that – they will send you an email to activate it.  Then all you need to do is set [...]

The First Post

Here we go…this could be something that I use to advance my career….