Clear a GL Accounting Scenario in an ERP Essbase Cube

When using additional Accounting Scenarios in your ERP GL Essbase cube to hold non-Actuals data (e.g. Budget or Forecast data from PBCS), it is occasionally necessary to clear out an entire Accounting Scenario in ERP, for example:

·         The data is incorrect and must be cleared out
·         The data pushed from PBCS was mapped to the wrong version
·         The data needs to be overwritten completely e.g. a “Latest Forecast” scenario which is updated monthly

When pushing Budget or Forecast data from Planning (PBCS) to a defined Accounting Scenario in ERP, the data will only be overwritten for combinations which have non-zero data in the push. This means that if data has been cleared to #missing in the PBCS source data, then existing values in ERP will not be overwritten. 

See my previous blog for more on pushing from Planning to ERP: https://lydia-maksoud-epm.blogspot.com/2019/07/write-back-budgets-from-pbcs-to-fusion.html

Unfortunately, in Oracle Cloud ERP this isn’t as simple as running a business rule to clear out a specified slice of data, unlike in the agile world of Oracle Planning. However (luckily) there is a way!

Important Note! This method of clearing an accounting scenario will clear data for the specified scenario for ALL Ledgers, Accounts, Currencies, COA segments, etc. We are essentially deleting and re-adding the scenario in the ERP cube. 

To clear out an Accounting Scenario in ERP, follow the instructions below:
1.       Log into ERP system
2.       Go to Tools > Setup and Maintenance
3.       Search for Manage Chart of Accounts Value Sets and go to the task
4.       Search for Accounting Scenario and click Manage values
 
5.       Search for the relevant Scenario and untick the Enabled box so that it is now blank, to disable this Scenario
6.       Click Save


7.      Go to Tools > Scheduled Processes and click to Schedule a New Process 
8.    Search for the process Create Scenario Dimension Members and click OK

9.    Under the options select Yes from the drop down for Delete Disabled Members and Dimensions.
      10.  Then click Submit



       11.  This will refresh the cube, deleting the Scenario that was disabled in step 5
       12.  Go back to Manage Values (step 4) and find the disabled Scenario
       13.  Tick the Enabled tick box to re-enable the scenario


      14.  Go to Tools > Scheduled Processes and click to Schedule a New Process
      15.  Search for the process Create Scenario Dimension Members and click OK



     16.  Under the options select Yes from the drop down for Delete Disabled Members and Dimensions.
     17. Then click Submit

    18.  This will re-add the enabled Scenario back into the ERP cube as a new, empty Scenario.


Once this process is complete, the newly added Scenario is empty and ready for data to be pushed from Oracle Planning (PBCS) to ERP. In other words, problem solved!

Comments

  1. Srinu Vasu18 February 2020 at 00:28

    Hi, I really loved reading this article. By this article i have learnt many things about this topic, please keep me updating if there is any update
    Hyperion Essbase Online Training
    Hyperion Essbase Training

    ReplyDelete
  2. Aaaaccounting4 March 2020 at 01:19

    Thank you for your post. This is excellent information. It is amazing and wonderful to visit your site.
    tax return service in barking

    ReplyDelete
  3. Bryant25 April 2021 at 21:54

    I am really very happy for the nice approach is visible in this blog and thank you very much for using the nice technology in this blog.I really appreciate your work.If you require about Startup india rgistration in delhi | opc annual compliance online in delhi please click on it.

    ReplyDelete
  4. PayrollOutsourcingCompanies17 August 2021 at 02:28

    Having read this I believed it was extremely enlightening. I appreciate you taking the time and effort to put this content together. I once again find myself spending a lot of time both reading and posting comments. But so what, it was still worth it!
    Accounts Payable And Receivable

    ReplyDelete
  5. GwayERP software10 October 2022 at 23:27

    Nice content. Thanks for sharing this excellent atricle.it's really useful for our business.We providing ERP software for customized.
    Visit us: erp software in Chennai.

    ReplyDelete

Post a Comment

Popular posts from this blog

Loading multi-period row data files using Data Management

Image
The ability to load multi-period data with the Period and/or Year in the rows is not particularly new (since release 16.10), however it is something that most people seem to forget is possible in Data Management. This really is something worth remembering as it eliminates the need to either split the data files into one file per month or try to pivot the month into the columns. In order to set this up, let’s firstly look at how to add the Period and Year columns to the import format. Add the Period and Year columns using the Add -> Source Period Row dropdown, and input: The Source Column name – e.g. PERIOD The Field Number (file column) – e.g. 3 Any required expressions for that field  As these are Period/Year dimensions, the mappings are not held in the usual Data Load Mappings area. Instead they are configured in the Period Mappings , under the Source Mapping tab. Select the Source System as File to add a new mapping calendar for loading the data ...
Read more

Executing Smart View Retrievals using VBA

Image
When working with Hyperion systems, Smart View is a key tool used for reporting, as well as inputting data. It provides a valuable link between Hyperion and Excel, which allows users to retrieve data from the database straight into Excel with ease. Smart View functions are available through the Smart View toolbar and can be used with Essbase, HFM, Planning or Cloud connections. Occasionally, it is necessary to perform Smart View functions behind the scenes using VBA code, rather than manually using the Smart View toolbar. For example, a spreadsheet which will refresh all the Essbase retrieval sheets on opening, so that users can view the most up to date data, without having to remember to refresh each of the retrieval sheets themselves. This blog will be cover how to retrieve data using a Smart View refresh function in VBA. For more information about Smart View Excel VBA functions, go to the Oracle Hyperion Smart View Developers Guide .  System Requirements ...
Read more

Loading Actuals from Fusion ERP Cloud to PBCS

Image
If you’re looking to set up a data load of Actuals from ERP to PBCS and have heard this is an “Out of the box” integration, then good news! Not only is the OOTB connector included within PBCS Data Management but the integration is simple to setup and to schedule using EPM Automate. This blog will detail how to setup the ERP to PBCS connector in Data Management and some of the common errors found when running the data load. The first thing to know about this integration is that the data source is actually the ASO Essbase cube which sits underneath the Fusion ERP tables, holding the period Actuals values. This ERP Essbase cube is created using job ‘Create General Ledger Balances Cube’ when configuring the ERP system. This cube must be created before the integration can be set up correctly and can be accessed directly via Smart View for reconciliations. Set up the Source System As this is an Oracle built connector, it’s as simple as providing a name for the source system ...
Read more