Hi,
You all would be using Encryption - Decryption of MaxL script containing userID and password for Essbase server. But I just thought of posting it in my blog so that if some of you want a quick reference without going to Technical Reference guide.
Follow the below easy steps to encrypt and decrypt the MaxL script:
Step 1: Create a simple MaxL script (Loginscript.mxl) to login into Essbase server using MaxL commands login on ;
logout;
Step 2: Run essmsh -gk command to generate Encryption and Decryption code
D:\oracle\Middleware\EPMSystem11R1\common\EssbaseRTC\11.1.2.0\bin>essmsh -gk
Essbase MaxL Shell - Release 11.1.2 (ESB11.1.2.1.0B347)
Copyright (c) 2000, 2011, Oracle
and/or its affiliates.
All rights reserved.
Public Key for Encryption: 13005,692804953
Private Key for Decryption: 565324885,692804953
MaxL Shell completed
Step 3: Encrypt Loginscript.mxl by issuing the below command along with Encryption Code generated above. This would create an encrypted MaxL script with extension Loginscript.mxls
D:\oracle\Middleware\EPMSystem11R1\common\EssbaseRTC\11.1.2.0\bin>essmsh -Em D:\
Scripts\Loginscript.mxl 13005,692804953
Essbase MaxL Shell - Release 11.1.2 (ESB11.1.2.1.0B347)
Copyright (c) 2000, 2011, Oracle
and/or its affiliates.
All rights reserved.
Step 4: Open the file Loginscript.mxls to check whether the userID and Password got encrypted or not.
login $key 225460064724436062164017310 $key 137249360634406684332940616180146296;
logout;
Step 5: If you want to execute encrypted file, run the below command with decryption code
D:\oracle\Middleware\EPMSystem11R1\common\EssbaseRTC\11.1.2.0\bin>essmsh -D D:\S
cripts\Loginscript.msh.txts 565324885,692804953
Essbase MaxL Shell - Release 11.1.2 (ESB11.1.2.1.0B347)
Copyright (c) 2000, 2011, Oracle
and/or its affiliates.
All rights reserved.
MAXL> login $key 225460064724436062164017310 $key 37249360634406684332940616180
146296;
OK/INFO - 1051034 - Logging in user [admin@Native Directory].
OK/INFO - 1241001 - Logged in to Essbase.
MAXL> logout;
User admin is logged out
MaxL Shell completed
Hope these simple steps would help you all while encryting and executing an encrypted MaxL script
Keep Sharing
Follow the below easy steps to encrypt and decrypt the MaxL script:
Step 1: Create a simple MaxL script (Loginscript.mxl) to login into Essbase server using MaxL commands login
Hope these simple steps would help you all while encryting and executing an encrypted MaxL script
Keep Sharing
