 | |
Extracting Cube Meta Data w/VBA
microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
Extracting Cube Meta Data w/VBA -
11-23-2004
, 12:55 PM
#2
| |||
| |||
|
|
Does anyone know if cube meta data can be extracted using Excel VBA? My goal is to paste a date-time stamp (of when the cube was last processed) above a pivot table w/data from the cube. Thanks. |
#3
| |||
| |||
|
|
Sure. Look at the OLAP Scribe utility. It shows you how to do it in MS Word. If you can do it in Word, you should be able to use the same technique in MS Excel. http://www.microsoft.com/downloads/d...DisplayLang=en -- Dave Wickert [MSFT] dwickert (AT) online (DOT) microsoft.com Program Manager BI SystemsTeam SQL BI Product Unit (Analysis Services) -- This posting is provided "AS IS" with no warranties, and confers no rights. "asg" <asg (AT) discussions (DOT) microsoft.com> wrote in message news:978E86B0-4934-4455-809C-62E50CB504DB (AT) microsoft (DOT) com... Does anyone know if cube meta data can be extracted using Excel VBA? My goal is to paste a date-time stamp (of when the cube was last processed) above a pivot table w/data from the cube. Thanks. |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.