Checking essbase.sec file in readable format

Hi All,

From version 11essbase.sec file is in encrypted format, and if we want to see the content of essbase.sec file we have to follow some simple steps.

1. Goto Maxl Editor and type below command

2. After this command executed successfully goto %Essbase_ARBORPATH%/bin and find "EssbaseSecFile" is created there

3. Open "EssbaseSecFile"

You can see essbase.sec file in Readable format

Thanks,

Avneet Singh Bhatia

Extracting MetaData Using Outline Load Utility

Planning 11.1.2.1 - Extracting Meta-Data using OutlineLoad utility

With the recent release of 11.1.2.1 the utility brings in the option to export dimension metadata which I didn't see mentioned in the planning new features document, so the utility has evolved as not just a loader but an extractor as well.

The utility is available on the machine where planning has been deployed in the folder <MIDDLEWARE_HOME>\user_projects\epmsystem1\Planning\planning1\

To extract a dimensions metadata it is as simple as executing:-

bash>./Outlineload.sh /A:<application> /U:<username> /D:<Dimension-name> /E:<OutputFileName>

 for Example:

./OutlineLoad.sh /A:RDAPP /U:training /D:Account /E:DimExtract.csv

  

Extracted Meta-Data file will be generated in same format by which we load the metadata .

Thanks,

Avneet Singh Bhatia

How to avoid implicit share in config file

Hi Guys,

Technology: Hyperion Essbase
Version: Version 11.1.2
Definition: When does Implicit sharing happen in essbase? And what are the ways we can define them in essbase config file.?

Solution:
1) A parent has only one child. In this situation, the parent and the child contain the same data.
Essbase ignores the consolidation property on the child and stores the data only once —thus the
parent has an implied shared relationship with the child.
2) A parent has only one child that consolidates to the parent. If the parent has four children, but
three are marked as no consolidation, the parent and child that consolidates contain the same
data. Essbase ignores the consolidation property on the child and stores the data only once—
thus the parent has an implied shared relationship with the child.
3) The following commands can be inserted in the .CFG file to disable Implied Sharing:
IMPLIED_SHARE FALSE/TRUE (This shall Turn OFF/ON implied sharing for All Application on that Essbase
Server)
IMPLIED_SHARE [app_name] FALSE/TRUE (This shall Turn OFF/ON implied sharing for Specified
Application on that Essbase Server)
Tagging the Outline Members “Never Share” Turns OFF implied Sharing for those Members and not tagging Turns ON implied sharing.
Order of Prevalence
Member level Implied Sharing Setting – Prevails over Application, Server Setting
Application level Implied Sharing Setting – Prevails over Server Setting
Server level Implied Sharing Setting - Least
4) E:\Oracle\Middleware\user_projects\epmsystem1\EssbaseServer\essbaseserver1\bin
ImpliedShare.txt

You can also refer

http://docs.oracle.com/cd/E17236_01/epm.1112/esb_tech_ref/frameset.htm?impliedshare.html

Hope this will be helpful,

Thanks,

Avneet Singh Bhatia

Encrypting Username and Password in Maxl Sript

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

./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,