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:

We all have the confusion that, how block creation happens in Essbase. Even I used to have that confusion. So, I wanted to clear that confusion by clearly explaining how block creation happens using data storage members. In Block storage, I am going to tell about, 1.      Block size. 2.      The potential number of blocks. 3.      The number of existing blocks. 1.    Block size: The size of each cell is 8kb. So the size of a block will be 8* no. of. Cells (Dense * Dense) bytes. Fig: 1.1 In the above picture, if you see we have two dense members i.e. Product and Year. For block size, we need to take members which are stored only. So no of cells= 9*1bytes. So Block size= 8*(9*1) = 72bytes. Below Fig shows the Block size, Fig: 1.2 2.    Potential Number of blocks: Maximum number of blocks that are derived from the product of one sparse member to other sparse members. Consider Fig: 1.1 we have five sparse members i.e. Account. Entity, Version, Period