RESOLVED: Cognos for EXcel 10.1.1 - Auto Refresh Report

[locus]

Hi,

Does anyone know how to auto refresh a list report open in Excel 10 through Cognos Gateway?

This is for the 'Refresh the data only' option.

Perhaps there is a way to write a macro for the 'Refresh All Data' button?

Cheers,
Locus

[AussiePete2011]

Hi Locus,

I gather you're not using Cognos GoOffice or what ever it's called now
You have created a list report and you export to excel so this becomes a static report.

The choice you have is to schedule this report
or
Write a store procedure to export into a summary table and point excel at the summary table.

Alternatively, you might want to look at Active Reports rather than the above.

This all depends on your budget, time available and resources for development

Hope this helps
Cheers
AussiePete

[locus]

Hi Pete,

Apologies for not being more clear.
I am using the Cognos for Excel 10.1.1 plugin, and am connecting to the gateway through Excel.
I am not importing/exporting anything.

Attached is a screenshot of what I am looking at.

So no, I am not looking at a static report. It is a live report through the gateway.
I am wondering if there is a way to automate the refresh rather than click the refresh button in Excel.

The reason I am asking this, is the report will be displayed on a screen and will not be monitored.

Cheers,
Locus

[blom0344]

VBA ?

[locus]

Thanks Blom for the nudge.


Here is the solution in detail:


http://pic.dhe.ibm.com/infocenter/cbi/v10r2m0/index.jsp?topic=%2Fcom.ibm.swg.ba.cognos.ug_cxc.10.1.1.doc%2Ft_automatingcoc.html



Works Great!