Category: Support, Information, Code, Elaboration, Daiwa, BDA
Create a Start_ESSCMDQ.cmd with to start esscmdq
@ECHO OFF
@REM This file is created to start ESSCMD
rem Set ESSBASEPATH
set ESSBASEPATH=D:\Oracle\Middleware\EPMSystem11R1\common\EssbaseRTC-64\11.1.2.0
set ESSCMDQ_UTF8MODE=1
set ARBORPATH=%ESSBASEPATH%
set PATH=D:\Oracle\Middleware\EPMSystem11R1\bin;%ESSBASEPATH%;%PATH%
%ESSBASEPATH%\bin\ESSCMDQ.exe %1
Command to compact outline
Login “hkntap309” “admin” “passw0rd” ;
Select “Outlet_SubB” “Outlet_SubB” ;
Openotl “2” 1 “Outlet_SubB” “Outlet_SubB” “Outlet_SubB” “y” “y” 1 ;
Writeotl 1 “2” 1 “Outlet_SubB” “Outlet_SubB” “Outlet_SubB” ;
Restructotl 1 ;
CloseOtl 1 ;
Unlockobj 1 “Outlet_SubB” “Outlet_SubB” “Outlet_SubB” ;
LogOut ;
This is caused by ASO Data Fragmentation hence need to compact outline. This happens when ASO outline changes or data changes.
Result after compacting Yamaya monthly 3GB -> 29MB
Step of Compacting Outline
1. Download ESSCMDQ
2. Download “Compact_Outline.rar” in attachment
3. Unzip ESSCMDQ.zip and “Compact_Outline.rar”
4. Put “ESSCMDQ.exe” to “D:\Oracle\Middleware\EPMSystem11R1\common\EssbaseRTC-64\11.1.2.0\bin”
5. Put “Compact_Outline.bat” and “Start.bat” in to following custom directory “D:\Scripts\CompactOTL”
6. Execute “Start.bat”
a) If you can type command after running “Start.bat” – Success
b) If command dos close immediately – Fail
7. Execute “Compact_Outline.bat” to compact outline. User need to enter following information,
a) Essbase Server Name (E.g hkntap309)
b) Application Name (E.g City_CompSubB)
c) Database Name (E.g City_CompSubB)
8. Check the Essbase Outline size.
Useful Link:
Important note!
Automated compress will have a chance of corrupting the outline if outline is 100% defragmented.
Refer to Link ASO Outline Compaction Using eescmdq