#textpad

Textpad هو برنامج يسمح لك بتحرير النصوص بجميع أنواعها ، وهو برنامج مفيد للغاية لتحرير صفحات HTML و PHP و JavaScript ولغات البرمجة الأخرى. البرنامج سهل الاستخدام ويحتوي على العديد من الأوامر التي تحتاجها لتعديل وتعديل النصوص الخاصة بك ، فهو بالفعل برنامج رائع لتحرير النصوص ومفيد لأصحاب المواقع لتعديل برامجهم في صفحات الويب ، مثل تحرير قوالب HTML وتعديل CSS رموز التصميم. يحتوي البرنامج أيضًا على…

If you have been using Essbase for any amount of time then you surely have found yourself writing a number of MaxL scripts.  Often times these scripts can become as complex as writing code using an API but the scripts have no real development environment and quickly get out of control.  I am going to discuss one technique I use to organize MaxL scripts.

If you have never used MaxL or you use Notepad to write MaxL scripts then you may want to read my post on working with Essbase Files before continuing with this post.

The key for script organization is to break the scripts down in to 'mini' scripts in separate files and then have a calling script to run all the functional mini scripts.  For example I always have a connect script, a disconnect script and a properties script.  The properties script is just a list of all my set commands (variables).

set ApplicationName = 'Sample'; set DatabaseName = 'Basic'; set SpoolFile = '../logs/MAXL_Build_Process.log'; set ServerName = 'SomeServerName'; set UserName = 'SomeEssbaseUser'; set Password = 'Password';

You will want to include anything in here that might vary, including username and password.  Be careful about saving user information in clear text!!

The connect script is simply the login command that accepts the variables from the

properties script.

LOGIN $UserName $Password ON $ServerName;

The disconnect script is even easier as it is just the logout and exit commands.

LOGOUT; EXIT;

Now that you have 3 script files you can pull them together and call them from one file and run the entire script.

msh Properties.msh; msh Connect.msh; msh Disconnect.msh;

This file simply calls the other files in the specified order.  This allows you to be flexible and easily edit what parts of the script are run.  Also over time you can accumulate a library of mini scripts that can be used to create multiple scripts to automate almost any process.

Working on a project I found myself writing a bunch of MaxL scripts.  So for this I started using Administrative Service and as the scripts got bigger I realized I needed to start using my favorite text editor, TextPad.   If you don’t have it already it is really a fine text editor and I have been using it for years, but working with MaxL I was missing the syntax highlighting and function lists that I had in Administrative Services.  I remembered that TextPad has features that allow you to define things like highlighting and function lists, you just need to build the definition files for this stuff.  Here are the steps I took to get my MaxL files working the way I wanted.

Set up TextPad to run MaxL scripts and capture the output.

Open TextPad.

Select Configure | Preferences.

Select the ‘Tools’ item.

On the screen click the ‘Add’ button and choose ‘Program’.

Browse to the location of the MaxL executable and select it.  (useally - %HYPERION_HOME%\products\Essbase\EssbaseClient\bin\essmsh.exe).

Once in the tools list you can select it and make edits if needed.

Now you can run MaxL scripts in TextPad.  Select Tools | External Tools and select the item you want to run.

Repeat for things like Esscmd and anything else you might want to run from TextPad.

Set up Syntax Highlighting

Open TextPad.

Select Configure | New Document Class.

Type the name you want for the new document type (MaxL or Essbase MaxL).

Select the class members or file extensions that will identify the file (*.msh, *.mxl).

Enable syntax highlighting and select the file to be used.  The files need to be located in the TextPad ‘samples’ directory. (C:\Program Files\TextPad 5\Samples)  Files are posted below.

Click ‘Next’ and then ‘Finish’.

You now have a new document class that understands syntax highlighting; repeat this for other file types like MDX, Essbase Calculation Scripts, Etc.

Set up clip Libraries.

Make sure the clip library files are located in the TextPad ‘samples’ directory. (C:\Program Files\TextPad 5\Samples) Files are posted below.

Open TextPad.

Select View | Clip Library.

Select the clip library you want.

Now TextPad it set up to handle all the Essbase Script development you would ever want.  You can also set up things like ‘File Name Filters’ and ‘Associated Files’ to make things even easier.

This time of year has always scared me. Perhaps this lost poem is a sign—of what? that I can say what's on my mind without poetry. What need have we for flowery words? They are but empty vessels—I am wary of pouring too much meaning into them— they shatter far too easily.

* * *