How to handle explicit and implicit shared members in extracts!
Author: Anthony Manfredi
How to Dynamically Add Metadata from EPBCS to EDMCS Using REST and GROOVY
Update I have added loops to check the job status for the creation of the attachment and the import of the transactions. Here is an example of the code in groovy def LOOP_STATUS = new JsonSlurper().parseText(jsonResponse.body) as Mapprintln "$RESTSTAGE Status is $LOOP_STATUS.status"while(LOOP_STATUS.status != "COMPLETED") {jsonResponse = operation.application.getConnection("EDMCS").get("/jobRuns/$jobid/result").header("Content-Type", "application/json").asString()LOOP_STATUS = new JsonSlurper().parseText(jsonResponse.body) as Mapprintln "$RESTSTAGE Status … Continue reading How to Dynamically Add Metadata from EPBCS to EDMCS Using REST and GROOVY
Drill from a cube that was loaded via a Data Map
Drill from a cube not loaded through Data Management
Write a Grid to a CSV File
I was looking at the API the other day an saw a cool function exportDataToFile. This will allow you to export any grid object to a flat file!!!
How to Utilize Groovy to Create Rule Sets
The goal of this blog is to demonstrate how, in a Groovy rule, we can: Execute a calculation only on the changed cells Rollup the Financial Cube utilizing the OOB rollup rule Transfer the data to reporting cube using a Smart Push with overrides. Before I worked on this approach, I would use three different rules as part of a rule set, but this technique opens up your implementation toolkit to be able to do so much more.......
How to enter Direct Salary for New Hires
I hear that this feature is coming out soon from Oracle. However, I put together this video to show you how you can implement this in your workforce applications today. It's fairly simple, and it may trigger ideas for other customizations to your application. Below is the formula modification to Basic Salary that I discuss … Continue reading How to enter Direct Salary for New Hires
EPBCS ASO Level 0 Export
I was so excited the other day when I read this small yet so inviting tidbit in the EPBCS release notes for May: You can now use Calculation Manager to export and import level zero data from an ASO cube. I have been struggling with getting data out of ASO cubes in a usable format … Continue reading EPBCS ASO Level 0 Export
Smart View and multiple pods, how can I simplify connections?
Now that I am in the cloud I have Urls and domains flying at me from all directions. How can I make sense of it in Smart view?
Spaces, SubVars and EPM Automate
The syntax you will need to update a SubVar with spaces using epm automate.
EPBCS Data Maps – How to improve the Headcount Transfer to Reporting
Here is a recent solution we devised to resolve slow transfers of data between the Workforce cube and the ASO Workforce reporting cube.