CAFE

IBM's Cognos Analysis For Excel (CAFE) tool is quickly becoming popular among business and financial analysts. This Excel add-in is separately sold by IBM (doesn't ship with BI installation) and needs to be installed on the users' machines. It enables the users to directly perform analysis in Excel with Cognos sitting as a layer between data source and Excel.

Cognos Framework Model works as the modeling and security layer here. It allows multiple data sources to be pulled together in one business layer which is exposed in Excel using CAFÉ. Users can directly perform drag-n-drop, slice-n-dice operations to analyze the data.

They can put Excel calculations like forecast on top of the figures and also create Excel charts etc. This brings the benefits ...

Get IBM Cognos 8 Report Studio Cookbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.