Posts

IPM Scaling & Precision Settings

Image
As part of the 26.06 EPM release in June 2026, Oracle have added scaling and precision settings for IPM insights! This is a welcome feature, meaning administrators have more control over how data is presented in their IPM insights description, graph and data grid. The scaling can be applied using the Apply Scaling (K, M, B, T) to values displayed in IPM Insights toggle. By default, this will be enabled and will apply scaling based on the magnitude of insight values.   There are also custom scaling options which can be applied using predefined UDAs on the Account dimension, as below: HSP_DISPLAY_SCALE_K  HSP_DISPLAY_SCALE_M HSP_DISPLAY_SCALE_B HSP_DISPLAY_SCALE_T The precision settings are similar to the settings in forms, which allows administrators to set the minimum and maximum precision setting for Currency, Non-Currency and Percentage values independently.  The release dates for the 26.06 patch is as below: Test Environment – Friday 5 th June P...
Post a Comment
Read more

Using Substitution Variables in Pipelines for Metadata Loads

Image
Data Exchange Pipelines have now replaced the batch functionality previously available in Data Management, allowing administrators to have a more enhanced visual representation of scheduled jobs. Pipelines consist of a series of stages, which are made up of a range of jobs, including business rules, integrations or platform jobs such as database refreshes. Substitution Variable Setup In a previous blog post, I explained how substitution variables can be used in pipelines using format &DataLoad_Mnth#&DataLoad_Year where the variables are in the below format: DataLoad_Mnth – references the current month for loading actuals (e.g. Mar) DataLoad_Year – references the current financial year for loading actuals (e.g. FY26) See my previous blog here for more detail:  https://lydia-maksoud-epm.blogspot.com/2024/01/Substitution-Variables-Pipelines.html This works great for data load integration jobs; however, I’ve recently found that this method does not work when attempting to...
Post a Comment
Read more