Essbase BSO and ASO Cube and Backup Scripts

BSO Cube =
exec_maxl "alter database ${APP}.${DB} archive to file '${BACKUP_PATH}/${APP}_${DB}.arc';" "1056023";

ASO Cube =
exec_maxl "export database ${APP}.${DB} level0 data to data_file '${BACKUP_PATH}/${APP}_${DB}.txt';" "1013270";

Do not forget the artifacts:
/usr/bin/zip-q -D ${BACKUP_PATH}/${APP}_${DB}_${TIME_STAMP}.zip  ${ARBORPATH}/app/${APP}/${DB}/* -x *.pag *.ind *.tct *.inn *.pan *.otn *.app *.dmf *.dbb *.db *.esm *.apb *.dat *.org *.dbd  *.jar  *.xml *.keep

Hyperion Updates from Kscope19 - On-Premise 11.2 version

Updates on On-Premise 11.2

Thanks,
Mady

Financial Reporting Migration Tool : FR Reports migration from HFM to FCCS

Kscope19 updates on Hyperion On-Premise:

The Financial Reporting Migration Tool (FRMT) is a utility that accelerates the migration and conversion of financial reports built in Oracle Hyperion Financial Management (HFM) into financial reports that are compatible with Oracle Financial Consolidation and Close Cloud (Oracle EPM Cloud).


The Financial Reporting Migration Tool (FRMT) is a utility that accelerates the migration and conversion of financial reports built in Oracle Hyperion Financial Management (HFM) into financial reports that are compatible with Oracle Financial Consolidation and Close Cloud (Oracle EPM Cloud).  This utility reduces the time and effort needed for report conversion by automating many of the manual tasks associated with the process.


The main features of the Financial Reporting Migration Tool include:


Maps dimension and member names to the new Financial Consolidation and Close model


Preserves the report formatting and layouts

Converts reports in bulk

Provides ready to use reports for Financial Consolidation and Close

The download includes the utility, full documentation, and examples.

Developers and implementer can extend and enhance the utility by editing the provide Python script to match specific use cases.











Reference links:

https://cloudmarketplace.oracle.com/marketplace/en_US/listing/50393071

https://kscope19.odtug.com/e/in/eid=32&s=2851&print=1&req=info


Thanks,
Mady