Trying to Automate Cognos Report in Excel 2007 Totals

[Cognos_Jan2017]

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

[Cognos_Jan2017]

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

[linbai]

use "IBM Cognos Analysis for Excel"