This last year I have been lucky to work with EDMCS. I am impressed with its functionality and the different approach to metadata management. My current client does metadata changes in EDMCS during the month and then sends the changes to their EPBCS applications, on-premises Essbase, and relational data sources on a monthly schedule. They … Continue reading How to Dynamically Add Metadata from EPBCS to EDMCS Using REST and GROOVY
Drill from a cube not loaded through Data Management
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!!!
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.......
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
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
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?
The syntax you will need to update a SubVar with spaces using epm automate.
Here is a recent solution we devised to resolve slow transfers of data between the Workforce cube and the ASO Workforce reporting cube.
This is part two of the import/export utility for PBCS. Extracting security is fine, but now we want to import the security back into our system.