You are creating a MaxL script to log into the database, update a dimension, load data, and run a calculation. Identify the two true statements about creating this MaxL script.

Question

Options

• AA separate MaxL script is required for each step
• BThe password must be hardcoded into the script when logging in.
• CIFERROR can be used in MaxL to handle errors after each statement, when triggered will skip to a
• DVariables for objects like server names, application names and database names can be used in a

• A
  8% (2)
• B
  12% (3)
• C
  81% (21)

Explanation

C: iferror instructs the MaxL Shell to respond to an error in the previous statement by skipping subsequent statements, up to a certain location in the script that is defined by a label name. Goto forces the MaxL Shell to branch to a certain location in the script defined by a label name; goto is not dependent on the occurence of an error. Syntaxiferror LABELNAMEgoto LABELNAMEdefine label LABELNAME D: In the MaxL Shell, you can use variables as placeholders for any data that is subject to change or that you refer to often; for example, the name of a computer, user names, and passwords. You can use variables in MaxL scripts as well as during interactive use of the shell. Using variables in MaxL scripts eliminates the need to create many customized scripts for each user, database, or Variables can be environment variables (for example, $ARBORPATH, which references the directory Essbase is installed to), positional parameters (for example, $1, $2, etc.), or locally defined shell variables. All variables must begin with a $ (dollar sign). Locally defined shell variables should be set without the dollar sign, but should be referenced with the dollar sign. Example: Incorrect answer: A MaxL cannot contain several steps. import database sample.basic dimensions from data_file 'C:\data\dimensions.txt' using rules_file 'C:\\data\rulesfile.rul' on error append to 'C:\\logs\dimbuild.log'; iferror 'dimbuildFailed'; import database sample.basic data from data_file "$ARBORPATH\app\sample\basic\calcdat.txt" define label 'dimbuildFailed'; B: It is recommend that you encrypt the MaxL scripts that includes user names and password, but it is not required. MAXL is an script language that we could use to manipulate essbase, we could use it to * create or modify essbase applications or database or even outline * create or modify dimension (e.g. add new member to the dimension) * importing data into database * execute calculation scripts. * ...many more , actually most of the functionality that we use the graphic admin console to do could be done using maxl scripts. MAXL script is only simple text that we could edit or write using the simple notepad . although admin console do provide an more easy editor for editing MAXL scripts.

No community discussion yet for this question.