• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 417
  • Last Modified:

Cognos / IBM extract - call to excel

Hi,


I use a web based data tool called Cognos, its in the IBM family i believe.

I run reports off it, i download the extracts to  excel format and then do my work.

Is it possible using vba or linking, to call those reports directly to excel so i dont need the download

Many thanks
0
Seamus2626
Asked:
Seamus2626
1 Solution
 
James ElliottManaging DirectorCommented:
You should be able to get the SQL that sits behind the reports in COGNOS and then open a connection yourself to the underlying data from Excel, adding the required SQL in the connection properties.
0

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now