OneCloud Data Prep Launch, REST API Enhancements, Log Synching to Amazon S3, Oracle Essbase, (E)PBCS, and HFM Enhancements
Release Date: 10 November 2020
OneCloud will be making platform enhancements, Saturday, November 10, 2020, from 11 am to 1 pm EDT. There will be no downtime for this release.
OneCloud Integration Studio REST API Enhancements
The OneCloud Integration Studio REST API now supports retrieving Chain execution details. This enhancement allows the individual Chain node execution results to be programmatically retrieved and utilized in various processes. Additionally, a new endpoint has been added to retrieve all Chains that meet a certain search criteria similar to the Monitor View in the OneCloud Integration Studio administrative console.
OneCloud Integration Studio Log Syncing to S3 Buckets
OneCloud Integration Studio now supports syncing OneCloud Integration Studio GroundRunner logs to Amazon S3 buckets. GroundRunner logs capture execution details for each Chain run in OneCloud Integration Studio. This new integration provides a simple, native way to collect log information in Amazon S3 buckets for additional analysis and data retention.
The Oracle Essbase BizApp now includes the ASO/BSO Export to Tabular Command which can be used to create a consistent tabular data layout when performing an extract from aggregate storage (ASO) Essbase databases. This Command supports both on-premises and Essbase 19c Cloud deployments.
The Oracle (E)PBCS BizApp now includes a Merge Data Slices and Optimize Aggregation Command. These Commands utilize the native Oracle EPM Cloud REST API endpoints and are intended to optimize performance in an Aggregate Storage (ASO) database. The Oracle documentation for Optimize Aggregation should be reviewed prior to utilizing this Command.
The Oracle HFM BizApp now officially supports the 11.2.x release of Oracle HFM as well as all 184.108.40.206.x releases.
OneCloud Data Prep
OneCloud is pleased to announce the official launch of OneCloud Data Prep (ODP). ODP is a new product in the OneCloud platform that enables business users to transform, map, and harmonize data in an interactive Excel-like interface. With the introduction of OneCloud Data Prep, the product known as OneCloud has been rebranded as OneCloud Integration Studio (OIS). All of our documentation will transition over the coming weeks and months to reflect the new product names.
While ODP is a separately licensed standalone product, it integrates seamlessly with OIS to provide OneCloud users the ability to manage the entire integration process without writing a single line of code. To learn more, please see the OneCloud Data Prep product overview. If you would like to see a live demonstration, please book a time to meet.
The following defects are fixed in this platform update:
Page error when GroundRunner stats are displayed
Error when converting an array to CSV when the last character is a backslash
In certain browsers, horizontal and vertical scrollbars do not display correctly
Advanced Query Error - Line too long
Warning result of a Run Chain event results in failed result at parent Chain
Command still running after Chain has experienced runner failure
PagerDuty Integration Broken
HFM Extract to Database fails
Many of our recent changes come from user insights, so please don't hesitate to drop us a line at email@example.com!