The Oracle PBCS November 2018 update adds a few good features that you probably run into during your PBCS implementations. I have listed a few below. You can find Oracle’s November Updates release document here
New EPM Automate Utility
The new utility adds the following commands. These are particularly helpful when you want to perform automated security updates and have a source system that can provide you with security details via an extract file:
- addUsersToGroup: Use this to add users to existing groups set up in Access Control using a csv file already uploaded
- removeUsersFromGroup: Use this to remove users from existing groups set up in Access Control using a csv file already uploaded to the environment
Additionally, the new utility provides improved performance when processing large files utilizing the copyfilefrominstance, downloadfile, uploadfile commands in EPM Automate
New Smartview Version 11.1.2.5.810
The new version adds support for-
- Drill-Through to Excel Sheets from EPM Cloud
- Attaching Files to Cells in Forms and Ad Hoc Grids
- Additional Information Added to Health Check
- Support for Oracle Sales Planning Cloud
Data Maps and Smart Push between Strategic Modeling and Planning
PBCS now supports data maps that push data from Strategic Modeling to a Planning Cube or from a Planning cube to a Strategic Modeling model.
REST API’s for managing users
New REST API’s to add users to a group or remove users from a group
New Expressions in Data Integration
New target dimension expression types include Copy Source value, Prefix, Suffix, Substring, Replace, Default, Rtrim, Ltrim, Rpad, Lpad, Constant, Conditional, Split, and SQL
ASO Functions in Calculation Manager
The following new functions can be used in POV of an ASO custom calculation or allocation –
- @FilterDynamic:Removes all dynamic members from the list of members
- @FilterShared: Removes all shared members from the list of members
- @FilterSharedAndDynamic:Removes all dynamic and shared members from the list of members
Design-Time Prompt Functions in Calculation Manager
- @IsAncest: Returns true if the specified ancestor member is an ancestor of the child member
- @IsChild: Returns true if the specified child member is a child of the specified parent member
New Custom Function in Calculation Manager
- @CalcMgrDateTimesToExcel: Converts multiple dates in YYYYMMDDHHMMSS format to Excel dates
Hi Amit,
Thank you for your post. it is helpful.
Right now, I am working in an EPM on-premise environment and interested in learning towards Cloud.
Is there any way I can subscribe to EPBCS service for training needs? or any pointers. Appreciate your help.
Thanks,
Krishna
Hi Krishna,
Thank you!
You have to purchase/subscribe to Oracle cloud in order to get a pod.
Check on the Oracle EPM cloud website if they have any demo subscriptions available.
Regards,
Amit