Unix Technical Forum

Excel and MDX

This is a discussion on Excel and MDX within the SQL Server Data Warehousing forums, part of the Microsoft SQL Server category; --> I have a spreadsheet with forecasting models and we would like to populate the spreadsheet with data from one ...


Go Back   Unix Technical Forum > Database Server Software > Microsoft SQL Server > SQL Server Data Warehousing

Register FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 02-27-2008, 06:38 PM
Matt Childs
 
Posts: n/a
Default Excel and MDX

I have a spreadsheet with forecasting models and we would like to
populate the spreadsheet with data from one of our cubes. Can I use
ADOMD to send in MDX queries to return these values (always a single
cell) or would it be better to hide a pivot table on another tab and
manipulate that to pull in my values and shoot them out into the spots
the current models expect?

Thanks,

Matt Childs
GCI
Anchorage, AK.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 05:10 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com