If you are unable to create a new account, please email bspsoftware@techdata.com

« previous next »
Pages: [1]

Author Topic: Getting data out of Analysis Studio  (Read 7129 times)

wentriken

  • Guest
Getting data out of Analysis Studio
« on: 15 Nov 2011 12:03:09 pm »
There is lots of great data in our cubes. I create adhoc reports and export to Excel when I need them. Is there any way to use an XML data link or other method to get data so that I can use the update functionality in Excel to refresh data? Or is there some type of way to query the server without directly using the website?
Logged

Offline pricter

  • Statesman
  • ******
  • Join Date: Feb 2006
  • Posts: 264
  • Forum Citizenship: +26/-0
Re: Getting data out of Analysis Studio
« Reply #1 on: 15 Nov 2011 12:25:46 pm »
There are two tools that you insert Cognos Data in excel.

Cognos Go office (which as far as I know its free as part of Cognos lincence) and
BI Analysis for Excel which you can do your analysis in excel. It looks like you have analysis studio in excel.

Logged

wentriken

  • Guest
Re: Getting data out of Analysis Studio
« Reply #2 on: 15 Nov 2011 01:58:56 pm »
Thank you I will try that
Logged
Pages: [1]
« previous next »
 

BSP Software Articles
Populating Framework Manager Descriptions from SQL Server Extended Properties
Performance Monitoring in MetaManager™

BSP Software Resources About Us
MetaManager BSP Software Training BSP Software
Integrated Control Suite YouTube Channel TD SYNNEX
Security Migration Twitter - TD SYNNEX IBM Cognos
Integrated Management Suite ExitCertified - Cognos Training