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 ...
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| 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. |