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: “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.”
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 [...]
Here we go…this could be something that I use to advance my career….