This Essbase discussion board is provided as a free service and dedicated to all the Essbase professionals out there!
  << Previous Topic | Next Topic >>Return to Index  

Can someone help me out how to write vbscript to automate Essbase Cube

June 9 2011 at 9:26 AM
No score for this post
 
from IP address 171.161.48.16

Hi All,
Cam someone help me out how to write a vbscript so that we can automate the Essbase cubes in SSIS package.
Thanks,
SatyaB

 
Scoring disabled. You must be logged in to score posts.Respond to this message   
AuthorReply



12.40.5.69

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.Respond to this message   
Current Topic - Can someone help me out how to write vbscript to automate Essbase Cube
  << Previous Topic | Next Topic >>Return to Index  

RSS feed for this forum - http://www.network54.com/Forum/58296?xml=rss. Please email hypess (at) gmail.com, if you have any questions/feedback/issues.