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!!!
Category: EPBCS
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?
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.
Part 2 – Where is my import/export security utility? How to Import Security
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.
Where is my import/export security utility???
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.
EPBCS – Improved Smart List Lookup in Calculations
Do you want your Smart Lists to be dynamic but do not want to write long if/then statements for every possible value in the lists?