Technology Blueprints & Strategy with Gary Crisci

Summary This article discusses requirements and solutions for backing up Oracle EPM applications. It highlights a new procedure that is available in Oracle EPM cloud to help meet requirements for keeping application backups viable over a long period of time. Introduction Backups are one of those things we don't think too much about until we need them, then they suddenly become very important. It's something we know we have to do, routines are set up to do it, and we hope it works when it's needed. If we're really diligent, we test the recovery process from time to time to ensure it works as expected. One thing I've learned about backups is that they are not all the same. We take backups for different reasons with different expectations. Just saying "I have a backup" sounds good to check it off a list and make our functional application owners feel good. However, depending on the circumstances when a request comes in to restore a backup, we may find...

While recently working on a project to migrate an on-premise Hyperion Planning application to Oracle Planning and Budgeting Cloud Service (PBCS) I ran into a requirement to export data from the application to a downstream data warehouse. On premise this is handled with a BSO export calculation script. One of the changes we implemented when moving the app to the cloud was to take advantage of the ASO reporting cube plan type to eliminate the need to run aggregations on the BSO plan type. This decision however caused a challenge for exporting the data. When evaluating options we recognized that while we could use a business rule to export the data from the BSO plan type, not all the data we needed was available since we were not aggregating the BSO cube. In light of this we decided we would extract the data from the ASO reporting cube. The challenge with this approach however was that we could no longer use the business rule export since it is not supported for ASO plan type, furthermo...