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.
The Oracle EPBCS/FCCS platform does not come with a nice way of exporting and importing object security the way the on-prem version of Hyperion Planning had with its command line utilities. I decided to take a stab at hopefully making it easier.