Upgrade Aggregate Storage Outline Version

These are the steps to perform to upgrade an aggregate storage outline to Essbase 21c.

1. Note that these steps can be performed only after importing the outline.
   1. Download platform- specific Essbase 21c ESSCMDQ from Download ESSCMDQ to your target Essbase system.
   2. Unzip the files directly to the same directory where ESSCMD is present in your installation.
   3. Make a copy of the existing script:

      ./Oracle/domains/esscs/esstools/bin/startESSCMD.sh

      as

      ./Oracle/domains/esscs/esstools/bin/startESSCMDQ.sh

      Within this newly created script, change the call from:

      <Essbase_Product_Home>/products/Essbase/EssbaseServer/bin/startESSCMD.sh

      to

      <Essbase_Product_Home>/products/Essbase/EssbaseServer/bin/startESSCMDQ.sh

   4. Make a copy of the script:

      <Essbase_Product_Home>/products/Essbase/EssbaseServer/bin/startESSCMD.sh

      as:

      <Essbase_Product_Home>/products/Essbase/EssbaseServer/bin/startESSCMDQ.sh

   5. Edit

      <Essbase_Product_Home>/products/Essbase/EssbaseServer/bin/startESSCMDQ.sh

      and change the last line from

      <EssbaseBasePath>/bin/ESSCMD

      to:

      <EssbaseBasePath>/bin/ESSCMDQ

2. Just before this last line, add the following lines:

   export ESSCMDQ_UTF8MODE=1
   export ESSLANG=.UTF-8@Binary

3. After launching this script:

   <Essbase_Product_Home>/products/Essbase/EssbaseServer/bin/startESSCMDQ.sh

   execute the following commands in ESSCMDQ:

   
   login hostname username password;
   
   select "appname" "cubename";
   
   openotl 2 1 "appname" "cubename" "outlinename" y y 0;
   setopgversion 0 "111241";
   getopgversion 0;
   
   writeotl 0 2 1 "appname" "cubename" "outlinename";
   restructotl 1;
   closeotl 0;
   unlockobj 1 "appname" "cubename" "outlinename";
   logout;
   exit;