Command Line Utility for Resaving Derived Entities and Essbase Cubes

OFSAAI has facilitated a utility called MetadataReSave.sh to resave Derived Entity objects and Essbase Cubes. This file resides under ficdb/bin area. In case of resaving Derived Entities, you can use additional runtime filters dynamically to refresh only selected records in the Derived entities.

To run the utility directly from the console:

1. Navigate to $FIC_DB_HOME/bin of OFSAAI FIC DB tier.
2. Execute MetadataReSave.sh (UNIX) with proper parameters:
   • INFODOM- Specify the information domain name.
   • USERID- Specify the user id.

     Note:

     The User ID or Service accounts are “SMS Auth Only” in case of SSO and LDAP configured setups.
   • Metadata Service Type – 856 for Derived Entity and 5 for Essbase Cube
   • Derived Entity Code for resaving Derived Entities- Specify the derived entity codes separated by tilde “~”

     Or

     Essbase Cube Code for resaving Essbase cubes- Specify the Essbase Cube code.

   • Runtime filter- In case of derived entity, specify the runtime filter to refresh only a selected set of records.

   For example,

   For resaving Derived Entities:

   ./MetadataReSave.sh,INFODOM,USERID,856,<Derived Entity code1>~<Derived Entity code2>

   For resaving Derived Entities with Runtime Filters:

   ./MetadataReSave.sh OFSAAAIINFO AAAIUSER 856 DE006 3^4 -f "DIM_ACCOUNT.f_Latest_Record_Indicator = 'Y'"

   For resaving Essbase Cube:

   ./MetadataReSave.sh,INFODOM,USERID,5,<Essbase Code>

   Note:

   ~ is not supported for Essbase Cubes. Only one Essbase Cube can be resaved at a time.

To run the utility through the Operations module:

1. Navigate to the Operations module and define a batch.
2. Add a task by selecting the component as RUN EXECUTABLE.
3. Under Dynamic Parameter List panel, specify as following in the Executable field:

   For resaving Derived Entities:

   ./MetadataReSave.sh,INFODOM,USERID,856,<Derived Entity code1>~<Derived Entity code2>

   For resaving Derived Entities with Runtime Filters:

   ./MetadataReSave.sh,OFSAAAIINFO,AAAIUSER,856,DE006,4^5,-f,DIM_STANDARD_ACCT_HEAD.V_STD_ACCT_HEAD_ID='CAP622'

   For resaving Essbase Cube:

   ./MetadataReSave.sh,INFODOM,USERID,5,<Essbase Code>

4. Select Yes or No for the Wait and Batch Parameter drop-down lists. For more information, see Component: RUN EXECUTABLEComponent: RUN EXECUTABLE section.

After saving the Batch Definition, execute the batch to resave Derived Entity Objects or Essbase Cubes.

You can find the logs in $FIC_DB_HOME/log/MetadataReSave.log.