This post started from a question of my colleague Sudhir, “How to run a VB script in Workspace?”
I know the answer for “How to run MaxL in Workspace” because I was following the thread in network54 (you can follow the discussion here)
But this was different and I’m not that familiar with jsp pages 😉 (Robb created a jsp page to run MaxLs in Workspace)
Since this is the season of reboots (Total Rekall, Amazing Spiderman, GI Joe….) I thought of rebooting Robb’s MaxLRunner (I’m just going with the trend ;), not sure how many (more?) times we’ll have to watch Peter Parker getting bitten by that spider.)
Before beginning the action I would like to thank couple of people (it’s more than couple) who inspired me to come up with this.
Sudhir, for asking How can I run a VB Script in Workspace.
Jomish, for inspiring to get it done.
Cameron Lackpour, for providing the hint.
Robb, for his nice jsp page (I really liked it, it allows you to view the contents and can use Smart cuts)
I’m someone who likes Essbase a lot and I told myself “First figure out how to run a MaxL script in Workspace, running VB script will be solved automatically”.
I figured out that MaxL can be imported as jobs from Cameron’s post, and later found that all jobs require a job application.
Jomish helped me understand the Job service and here we are.
Follow the steps given below, and you can run MaxL scripts in Workspace.
Step 1: Create a Job Application
Create a generic job application as shown below. (Navigate -> Administer -> Reporting and Analysis -> Generic Job Applications)
- Provide a Product Name (this is the name that shows up (Job Factory Application) when importing a job.
- Select Product Host. (This is the Workspace server)
- Type $CMD $PROGRAM, you can also click the buttons to insert Command Template.
- Provide the full path of essmsh.exe as the Executable. Essbase client should be installed on Workspace Server.
Step 2: Import a MaxL script
- Select the newly created Job Application and click Finish.
Step 3: Run the job
You can now execute the MaxL script by double clicking on it or right click -> Run as Job
Provide a path for output and click “Run”
The MaxL script will be executed on Workspace server. If you are spooling (spool command) in MaxL, then make sure that Workspace server has that folder.
I think this went way too detailed and I never talked about running VB scripts, so that calls for a sequel 🙂
(Coming soon “How to run a bat/cmd file in Workspace?”, “How to run VB script in Workspace?”)