Re: Can someone help me out how to write vbscript to automate Essbase Cube
No score for this post
June 9 2011, 10:14 AM
Easy route:
Write MaxL scripts with error handling, and shell those from the SSIS package.
More sophisticated (and more powerful) route:
I automated administrative functions from DTS packages back in the day by calling wrapper functions in a VB6 ActiveX dll that executed the proper series of Essbase VB API functions, but that's old school tech now.. Java would be the modern day replacement.
Scoring disabled. You must be logged in to score posts.