MS SQL Data Warehousing - Excel and MDX

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Excel and MDX

Matt Childs

2005-10-17, 1:24 pm

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.

Sponsored Links