Search icon CANCEL
Subscription
0
Cart icon
Your Cart (0 item)
Close icon
You have no products in your basket yet
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Free Learning
Arrow right icon
Arrow up icon
GO TO TOP
Oracle Essbase 11 Development Cookbook

You're reading from   Oracle Essbase 11 Development Cookbook Over 90 advanced development recipes to build and take your Oracle Essbase Applications further with this book and ebook

Arrow left icon
Product type Paperback
Published in Jan 2012
Publisher Packt
ISBN-13 9781849683265
Length 400 pages
Edition 1st Edition
Arrow right icon
Author (1):
Arrow left icon
Jose R Ruiz Jose R Ruiz
Author Profile Icon Jose R Ruiz
Jose R Ruiz
Arrow right icon
View More author details
Toc

Table of Contents (17) Chapters Close

Oracle Essbase 11 Development Cookbook
Credits
About the Author
About the Reviewer
www.PacktPub.com
Preface
1. Understanding and Modifying Data Sources 2. Using Essbase Studio FREE CHAPTER 3. Building the BSO Cube 4. Building the ASO Cube 5. Using EAS for Development 6. Creating Calculation Scripts 7. Using MaxL to Automate Process 8. Data Integration 9. Provisioning Security Using MaxL Editor or Shared Services 10. Developing Dynamic Reports Index

Using encryption in MaxL scripts


In this recipe, we will retrieve a public key and private key using MaxL commands. Then we will encrypt a MaxL script and modify the command line to successfully run the MaxL command.

Getting ready

To get started, click on Start, select Run, type cmd, and press Enter.

How to do it...

  1. Type in essmsh –gk into the command screen and press Enter. The following text will appear. Keep a note of the Public Key and Private Key as they appear on this screen.

  2. In EAS, click on File, click on Editors, click on MaxL Script Editor, type the following MaxL script, click on File, then on Save script as, browse to the C drive, type SubVarD in the File Name, and click on OK.

    /*Login to database */
    login Admin password on localhost;
    
    /*Create log*/
        spool on to 'C:\Display.txt'
        
    /*Display Substitution Variables Before*/
    Display variable on database Sample.Basic;
    
    logout;
    spool off;
    exit;
  3. Return to your command line and type in essmsh -E scriptname.mxl PUBLIC-KEY or based on...

lock icon The rest of the chapter is locked
Register for a free Packt account to unlock a world of extra content!
A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.
Unlock this book and the full library FREE for 7 days
Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of
Renews at $19.99/month. Cancel anytime
Banner background image