Hyperion Info - Essbase & Planning

Password encryption in MAXL script An objective of this blog is to provide information about how to encrypt the Username and Password in Maxl script. To login into Essbase Server, in traditional method we manually enter the User credentials and do the process. We also have another process to login into Essbase server and do the process i.e. through Maxl scripts in which we can automate Maxl scripts through batch by scheduling and also through command prompt we can run the process by calling the Maxl. Through manually login User credentials are remembered by the user whereas through Maxl script we give the User credentials in text file. So, there might be a chance of stealing the User credentials. To provide the more security we do User credential encryption. There will be two basic keys are used Encrypt: Public key Decrypt: Private key The Public and Private Key pair comprises of two uniquely related Cryptographic keys (It is a string of data used to lock and unlock cry

We all know, how to create a data form using rows, columns, page and POV. In this I want to explain how to add Formula rows/columns in Hyperion Web form. Here in this blog I have used application called VIZAGPLN. All the screenshots show this application only. Step-1: Go to Planning Application > Navigate > Applications > Planning > VIGAZPLN as shown below. Step-2: Go to Administration >  Manage >  Forms and Ad Hoc Grids to open the forms shown as below. Step-3: Select the form and click on edit, shown as below. Step-4: Go to Layout and click on edit select member selector icon to insert require Member/members in rows and columns as shown below. I will explore further how to add formula row/column with below three requirements for better understanding.             Req1) Displaying Half year sales using Sum function:                       Sum function returns the sum of rows, columns or cell.                       Example: