Keeping up with EPM Cloud

In November 2021, Oracle released Intelligent Performance Management (IPM), which integrates directly into your EPM applications to provide automated predictions, data analysis and insight into anomalies or patterns which may otherwise go unnoticed. Then in the August 2023 EPM patch, Oracle released new Calendars & Events functionality to IPM, which allows admins to setup regional calendars containing events. These events can then be taken into account for the predictions and insights generated, helping to add context that IPM may not be aware of from the data. Calendars and events can be setup in the Configure card, under IPM. Configuring Calendars Calendars can be setup to allow for different events to be assigned depending on the region or time. For example, an event for Christmas may only apply to EMEA/US, so we’d need a different calendar for those regions. Calendars can also be defined for a range of time series, e.g. Daily, Weekly, Monthly or Quarterly, depending on ...

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 ...