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