Using ESSUTF8 Utility for Unicode ASO Cube Dim Build

Hello,

It has been long that I have shared any article / topic in my blog. Actually I was too busy with my current projects / assignment.

However, few days back I found an interesting utility while building UNICODE DIMENSIONS for Essbase ASO cube.

When you use Essbase Studio to build Unicode ASO cube dimensions, the in-build features of Essbase Studio take cares of building Unicode ASO Cube dimensions while connecting Relation Database with Essbase Cube.

However, when you are suppose to build Unicode ASO cube dimensions using ASCII format files via MaxL command, you are in trouble. You get dimension build errors (Command Failed. Return Status = 1054036).
However the same MaxL runs perfectly on the EAS MaxL editor.


There are few ways to make this run using MaxL on command.

Option 1 : Create the MaxL using EAS MaxL editor. While saving the MaxL into a file, check the "Unicode" check box which appears at the bottom of the Save File option window. Use this file to run on MaxL Command

Option 2: Use ESSUTF8.sh /ESSUTF8.exe utility stored at the path arbor path(Essbase Server Path)/bin

essutf8 -b -s  

and use this MaxL file to run on MaxL command. you can find more details of using ESSUTF8 utility in the link

Hope this helps.

Happy sharing

Issue: MaxL and Esscmd not opening from windows command line

Hi,

I am currently busy installing Oracle Hyperion EPM product suite v11.1.2.1 on VMware machines and the issues which I face while installation, I just thought of sharing here on this blog.

After installation of Essbase Server on one of the VMware machine, I found that I cant open MaxL or esscmd command from windows command line. I found that ARBORPATH and ESSBASEPATH environment variable were not set. I set it for the seesion and it worked. It can be set in the Environment Variable and then MaxL and Esscmd can be executed from windows command line.

Hope this helps you all

Keep Sharing

OraHyperion

Shared Connections Drop-Down List empty in Smart View 11.1.2.1

Hi,

I was working on the installation of Oracle Hyperion EPM v11.1.2.1 on 64 bit VMware Server. I installed and configured all the required products (Foundation Services , Essbase, EAS and Provider Services) in that order. Then installed SmartView v11.1.2.1 on my local machine to check the connectivity with Essbase using workspace install link. It got installed successfully and I was able to connect to the Essbase Server using Private Connection (http://ProviderServer:PORT/aps/APS). However when I connected to Shared Connection, the drop-down of the list was coming as empty and it was not allowing me to enter hps details either.

I googled for the solution and found that I need to reconfigure Foundation Services ->Web Server after the installation of SmartView so that Web Server is configured for all the required products. I did the same and the issue was resolved. After connecting to Shared Connection using the URL http://ProviderServer:PORT/workspace/SmartViewProviders in SmartView Options->Advance-> Shared Connection URL, I could see Oracle Essbase Server in the drop-down list. Then I remembered having read the same in epm_install_11121 pdf file which has always refered to configure Web Server in LAST. I got the point and thought of sharing the same here

Hope this helps you all

Happy Sharing

EPM Configuration Tool Not Opening : Oracle EPM v11.1.2.1

Hi,

I faced a peculiar problem today while running EPM Configuration Tool on one of a new Hyperion server which I was building for migration. EPM Configuration Tool ran fine when I ran the tool for configuring Essbase Server. However after the Essbase configuration completed, I tried to run Configuration tool again to configure Essbase Studio on the same server and I got an error message:

  

I looked for the solution in the troubleshooting guide for v11.1.2.1 (TrobuleShooting Guide - EPM System Configurator Startup 

but this could not help as I was using the same user name to install and configure the products. 

Then I closely looked that the error message on the console and found that the configurator was not able to read some of the file under C:\Oracle... I navigated to the drive and found that I am not able to edit any of the files under Oracle folder in C: drive. I changed the permission for the user which I was using to install the Hyperion Products on the "Oracle folder" to FULL CONTROL on all the files and folders under C:\Oracle and that worked. This issue I observed on VMware server having Microsoft 2008 server (OS) - 64 bit

Hope this helps you all

Keep sharing

Encrypt Essbase UserID and Password in MaxL script

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