Hi Guys,
When you write any Maxl script you can generally you use the username an password to login into essbase,
for example
login 'admin@Native Directory' identified by 'password' on localhost
execute calculation 'Sample'.'Basic'.'example';
logout
But if you want to encrypt your username and password do the following steps:
1. Save Maxl Script in any location (For example on Linux server /hyperian/MaxlFiles )
2. Save File with .mxl extension.
3. After that go to the path MIDDLEWARE_HOME/user_projects/epmsystem/EssbaseServer/essbaseserver1/bin
4. run this command ./startMaxl.sh -gk
output shows like this:
bash $ ./startMaxl.sh -gk
Essbase MaxL Shell 64-bit - Release 11.1.2 (ESB11.1.2.0.0B444)
Copyright (c) 2000, 2009, Oracle and/or its affiliates.
All rights reserved.
Public Key for Encryption: 41891,6672490841
Private Key for Decryption: 6436070411,6672490841
MaxL Shell completed
5. Now after that goto same path again MIDDLEWARE_HOME/user_projects/epmsystem/EssbaseServer/essbaseserver1/bin
and write below command
6. after that .mxls file is generated in the same path and when you open the file you will see
login $key 94025384003358228082377279752350662616441303706035938386009423593343331956845162618240004453797831116987451454 $key 00469930626460617461856984978405990459243518983983 on 'localhost';
execute calculation 'Sample'.'Basic'.'example';
logout
that is you Maxl file is encrypted in form of.mxls file and now onward you have to run your encrypted mxls file.
7. for decryption/Running encrypted file ,
Now after that goto same path again MIDDLEWARE_HOME/user_projects/epmsystem/EssbaseServer/essbaseserver1/bin
and write below command
When you write any Maxl script you can generally you use the username an password to login into essbase,
for example
login 'admin@Native Directory' identified by 'password' on localhost
execute calculation 'Sample'.'Basic'.'example';
logout
But if you want to encrypt your username and password do the following steps:
1. Save Maxl Script in any location (For example on Linux server /hyperian/MaxlFiles )
2. Save File with .mxl extension.
3. After that go to the path MIDDLEWARE_HOME/user_projects/epmsystem/EssbaseServer/essbaseserver1/bin
4. run this command ./startMaxl.sh -gk
output shows like this:
bash $ ./startMaxl.sh -gk
Essbase MaxL Shell 64-bit - Release 11.1.2 (ESB11.1.2.0.0B444)
Copyright (c) 2000, 2009, Oracle and/or its affiliates.
All rights reserved.
Public Key for Encryption: 41891,6672490841
Private Key for Decryption: 6436070411,6672490841
MaxL Shell completed
5. Now after that goto same path again MIDDLEWARE_HOME/user_projects/epmsystem/EssbaseServer/essbaseserver1/bin
and write below command
./startMaxl.sh -E /hyperian/MaxlFiles/sample.mxl 41891,6672490841
6. after that .mxls file is generated in the same path and when you open the file you will see
login $key 94025384003358228082377279752350662616441303706035938386009423593343331956845162618240004453797831116987451454 $key 00469930626460617461856984978405990459243518983983 on 'localhost';
execute calculation 'Sample'.'Basic'.'example';
logout
that is you Maxl file is encrypted in form of.mxls file and now onward you have to run your encrypted mxls file.
7. for decryption/Running encrypted file ,
Now after that goto same path again MIDDLEWARE_HOME/user_projects/epmsystem/EssbaseServer/essbaseserver1/bin
and write below command
./startMaxl.sh -D /hyperian/MaxlFiles/sample.mxls 6436070411,6672490841
you'll be able to run the decrypted file
Thanks,
Thanks Avneet ,
ReplyDeleteIt was very Helpfull :)