Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: Cognos_Jan2017 on 11 Jan 2017 07:28:04 PM

Title: Trying to Automate Cognos Report in Excel 2007 Totals
Post by: Cognos_Jan2017 on 11 Jan 2017 07:28:04 PM
Very new to Cognos.  Lots of Microsoft Access-to-Excel automation experience.

I'm able to run Cognos Lists to get Group totals, and run as Excel 2007.  With those totals, would like to automate aggregate values to an Excel template appropriate cells.  Could always have user take data from the Cognos Excel 2007 aggregate, and manually enter into their template ... but don't want that.

Am aware non-Excel dashboards might accomplish this by dragging in the Cognos Excel 2007 data.

Any suggestions welcomed.

TIA - Bob
Title: Re: Trying to Automate Cognos Report in Excel 2007 Totals
Post by: Cognos_Jan2017 on 12 Jan 2017 07:36:25 PM
I understand, if doable, control has to originate within Excel.  Anyone know how to Slice and Dice a Cognos OLAP Cube w/ functions like CubeValue, COGNAME, and COGVAL in Excel cells?

TIA, Bob
Title: Re: Trying to Automate Cognos Report in Excel 2007 Totals
Post by: linbai on 17 Jan 2017 02:38:10 AM
use "IBM Cognos Analysis for Excel"
Text only | Text with Images