Oracle Analytics and How to unlock insights from data living within Oracle EPM - Part 2 (The Test Drive). In this post we will cover how to connect to Oracle EPM Cloud using the OAC Smart SAAS connector. We will also cover what is good and what needs improvements.
Oracle Analytics Cloud for Oracle EPM Part 1 – Lets Intro
Oracle Analytics and How to unlock insights from data living within Oracle EPM. When and when not to use OAC and for what purpose is it suited. A better future with improved connectivity for EPM!
Oracle EPM Planning – Budget Adjustment Tracking
Quick dive in Oracle EPM Planning / PBCS to show a clever approach to track and report on Budget Adjustments / Changes. Concept can be applied to forecasting also. Enjoy!
Oracle EPM Planning Mapping Smart Lists to Attributes
Attribute dimensions are excellent tools for establishing descriptive capability of a dimension member and to then enable slice and dice capability by this attribute. For example, a project may have an attribute of a project manager as you would typically only have one project manager per project. The challenge results in the administration of this, as tends to be a manual task using the dimension editor and power is taken from the user to change/update this themselves and becomes an admin based task. ⢠Why? Gives the control to users to easily view & update ⢠How? Our approach relies on automation using EPM Automate (extract and import)
PBCS Enable Summary Drill
In this post we look at Summary Level Drill from PBCS!!!!! Yes, it is finally here. Now despite my excitement, I promise to remain unbiased in this blog post and tell you what I like and what I donāt like about the recently enabled feature. This blog post will cover how to activate the feature with a drill to Fusion Cloud.
PBCS – Restricting Form Triggered Business Rules with User Variable Selections
Quick dive in PBCS to show a clever approach to Restricting Form Triggered Business Rules with User Variable Selections. Enjoy!
Triggering On-Demand Source Data Loads from within PBCS
In this post we look at on-demand data loads from source to PBCS. In on-premise Hyperion, if the requirement is to trigger on-demand data loads from within Hyperion they are a few options like Calc Manager command line triggers or Workspace Generic Jobs both of which can trigger batch scripts on the underlying servers to trigger the load from source systems to Hyperion. In PBCS this is a lot more difficult due to limitations of PBCS being a cloud solution that is not able to directly integrate with all source systems due to both technology and locations of these systems.
Groovy This & Groovy That ā Part 3 The Example
Lets now get a little bit more practical with an example to show how we will Login to PBCS and run some commands, but with a twist.... Why ordinary!!!! That would only be boring. Today our example, will run a program that will interact with the triggering user and execute commands based on the entered input. This program/mini-application will allow the user to list files, delete files, upload and download files to and from PBCS and execute Jobs in PBCS using Groovy commands. Please note this example can be further expanded to do much more in PBCS and leverage all the PBCS REST API functions, however the commands listed will be used as the example in this post.
Write Back to Fusion Cloud from PBCS – This is How We Do It Edition
This is how we do it - Write Back data to Oracle Fusion Cloud or Fusion Financials from Oracle PBCS. Not your typical blog post.
Groovy This & Groovy That – Part 2 The Setup
Nothing special here just a basic how to install Groovy for PBCS integration and a simple test to show is working: Hello World Println from the Hyperion Jedi.