A Deep Dive into FlexibleDataGridDefinitionBuilder and DataGridDefinitionBuilder!

In the world of Oracle EPM Cloud, data grids serve as the backbone for interacting with multidimensional datasets. Whether you're querying data or preparing it for analysis, the choice of grid definition builder can significantly impact your productivity and script efficiency. Oracle EPM Cloud provides two main tools for constructing these grids: DataGridDefinitionBuilder and FlexibleDataGridDefinitionBuilder.

In this blog, we’ll explore these two builders, dissect their features, and help you decide which one suits your needs. Along the way, we’ll cover best practices, showcase example scripts, and highlight why the flexibility of the FlexibleDataGridDefinitionBuilder often makes it the preferred choice for modern Oracle EPM applications.

Automating Multiple Data Push in Oracle Cloud EPM Using Groovy Business Rules!

In Oracle Cloud EPM, Groovy scripting has become a powerful tool for automating business processes, ensuring real-time validations, and enhancing interactivity. This blog explores a practical use case where a Groovy business rule dynamically sets substitution variables and validates Data Maps before executing Smart Push operations.

The rule also demonstrates on using runtime prompts (RTPs) to set values for Substitution Variables, validate Data Map existence, execute Smart Pushes for specific members, and log user execution details.

User Audit Report (v2) Detailed Overview

 User Audit Report (v2) Detailed Overview

Purpose:

The User Audit Report (v2) REST API generates a detailed audit report of user activities within a specified environment and timeframe. This report is crucial for monitoring user access and activities, ensuring security, and maintaining compliance.

Functionality:

Oracle Cloud Application Update Readiness!

In this blog lets explore the Oracle Cloud Application Update Readiness. It provides comprehensive information on the latest updates for Oracle Cloud Applications. Here are the key components explained in detail:

1. Feature Listing Report

Oracle publishes a Feature Listing Report that is updated monthly. This report includes:

• New Features: Details about the latest features available in Oracle Cloud Applications.
• Implementation Dates: Information on when these new features will be available or become mandatory.
• Optional Features: A timeline of when optional features will be automatically enabled if not already activated by the user.

All about During daily maintenance!!!

During daily maintenance in Oracle EPM Cloud, the system creates a maintenance snapshot, applies patches, adjusts configurations, and analyzes activities to generate an Activity Report. The environment is then rebooted, with initial access limited to Service Administrators. Certain operations are restricted during this period, especially for processes like Planning and Financial Consolidation. Maintenance usually starts between 10:00 p.m. and 1:00 a.m. local time and a 15-minute notice is given before maintenance begins. The process typically takes less than an hour.

---

 

Find and Download Files from an Oracle EPM Cloud Environment

In this Blog lets see the example script to automate the process of downloading files from an Oracle Enterprise Performance Management Cloud environment using a text string as a wildcard.

This script matches the string specified in the FILENAME parameter with file names displayed using the listfiles command, then automatically downloads the matching files.

Ensure you set the appropriate search string to the FILENAME parameter. For example, FILENAME="Scheduler Output/epm" will match file names containing "Scheduler Output/epm" in the listfiles command output, identifying the files to download.

Automation PowerShell Script to invoke EPM Automate commands!

Lets have a detailed walkthrough of the PowerShell script detailing its purpose and functionality. The script is designed to perform several tasks: logging into the EPM, run the Data Management Integration rule, download the generated extract created by the integration rule, download the data file & then logout from the EPM instance.

All About Clear Cube & Merge Data Slices!

 In this Blog post we will explore the Clear Cube & Merge Data Slices option in Planning and can be leveraged to EPCM applications using the REST API & Groovy

Clear Cube

The Clear Cube can be accessed from the Simplified Interface. 

Running EPCM Calculation Manager rules in sequential and Data Management rules as a child job using Groovy!

In this blog we will see how to run the EPCM (Enterprise Performance Management Cloud)  Calculation Manager rules using groovy in a sequential manner also invoking Data Management rules as child jobs using the jobFactory.

Groovy script is fetching substitution variable values from an operation's application and printing them. Here's a detailed explanation along with the provided script: 

subVarValue is defined to fetch the value of a substitution variable from the application.

Also Sets the connection name, which is already predefined for the REST API to work. 

def connectionName = 'Localhost'

Closure subVarValue = { String subVar -> operation.application.getSubstitutionVariable(subVar).value }

String CurYr = subVarValue('CurYr')

String CurMth = subVarValue('CurMth')

println "The Rule is using the Sub Var Current Year : " +CurYr +" " + "Current Month : " +CurMth

Setting User variables values for the first time using Groovy rule!

User variables function as filters within forms, allowing users to narrow their focus to specific members, like a department. Prior to linking a user variable to a form, you need to establish the user variable. When designing forms with user variables, users are required to initially designate values in preferences for the variable prior to accessing the forms. Subsequently, users can modify the variable within the form only if it's dynamic. If not, they must persist in setting the variable in preferences. For instance, if a user variable named "Cost Center" is created, users must designate a Cost Center before engaging with the form.

When users interact with a form for the first time, they set their preferred variable, such as a department or division, in their preferences. This initial selection is crucial as it helps customize their form-viewing experience.

After the initial setup, users have the flexibility to update this variable. They can either go back to their preferences and make changes there, or they can directly adjust the variable within the form itself. This flexibility allows users to adapt their form interactions based on changing needs or contexts without needing to navigate away from the form.

Overall, this approach ensures that users have control over their viewing preferences and can tailor their experience to suit their individual requirements.

All about Vanity URLs!

Vanity URLs

 Vanity URLs offer a convenient solution for memorizing complex URLs associated with Oracle Enterprise Performance Management Cloud environments. 

These customized URLs provide direct access to EPM Cloud environments via web browsers, Oracle Smart View for Office (version 20.200 and higher), and EPM Automate. 

To generate a new vanity URL, you can utilize third-party services such as T.ly, Bitly, Rebrandly, or TinyURL, or opt for an open-source alternative like YOURLS. When leveraging an API gateway or reverse proxy, substitute the EPM Cloud URL with the designated URL and context specified for your environment.