Posts

Posts

  • John Klinke
    Everything You Need from Analytics in 18 Minutes5.0
    Announcement posted March 19, 2019 by John KlinkeBronze Medal: 1,250+ Points, tagged Analytics, API Management, ATP, Autonomous Data Warehouse, Big Data, Business Intelligence, CASB, Content and Experience, Data Integration, Data Visualization, Database, Developer, Identity, Integration, Internet of Things, Java, Management, Mobile Analytics, Mobile and Intelligent Bots, Process Automation, Visual Builder in Platform Members > Oracle Cloud Infrastructure and Platform Announcements public
    Title:
    Everything You Need from Analytics in 18 Minutes
    Abstract:

    Check out this great new Oracle Analytics demo video created for the vendor bake-off at Gartner’s Data and Analytics Summit this week in Orlando, Florida.

     

     

    Announcement:

    See this Analytics Advantage blog post for an amazing tour of Oracle Analytics Cloud capabilities and the value they can give you:

    blogs.oracle.com/analyticscloud/oracle-augments-gartner-bi-bake-off

  • John Klinke
    February 2019 Release Update for Oracle Cloud Platform
    Announcement posted March 5, 2019 by John KlinkeBronze Medal: 1,250+ Points, tagged Analytics, API Management, ATP, Autonomous Data Warehouse, Autonomous NoSQL Database, CASB, Content and Experience, Database, Developer, Identity, Integration, Java, Management, Mobile and Intelligent Bots, Process Automation, Visual Builder in Platform Members > Oracle Cloud Infrastructure and Platform Announcements public
    Title:
    February 2019 Release Update for Oracle Cloud Platform
    Abstract:

    We are pleased to announce new updates and enhancements to our comprehensive portfolio of PaaS solutions. A summary of Oracle Cloud Platform release updates for February 2019 are listed below. See Oracle Cloud Platform Documentation for more details.

    Announcement:

    Analytics Cloud

    • A new way to deploy Oracle Analytics Cloud Subscription on Oracle Cloud Infrastructure is available. See Create a Service

     

    API Platform Cloud

    • You can now enclose a search term in quotes to find an exact match on list pages. See Understand the APIs List Page
    • A button has been added to display a list of applications for selection. See Apply Application-Based Routing Policies
    • A button has also been added to display a list of gateways for selection. See Apply Gateway-Based Routing Policies
    • The pages in the interface that list the APIs, plans, applications, services, and service accounts have been redesigned
    • Now actions, methods as well as resources from an Apiary specification can be used for resource-based routing policy
    • If the installed version of your gateway is 18.4.3 or later, there is no need to re-install the gateway for 19.1.3

     

    Application Performance Monitoring (part of Oracle Management Cloud)

    • You can now record scripted actions using Selenium IDE and save as a .side file and upload it for Synthetic Tests

     

    Autonomous Data Warehouse

     

    Blockchain Platform

    • Oracle Blockchain Platform was updated to use Hyperledger Fabric 1.3
    • Java chaincodes are now supported
    • You can now define private data collections on channels
    • Now you can add ACL policies to a channel and then apply them to the channel's resources
    • State-based endorsement policies are used now. They allow the SDK to automatically detect information in the network
    • You can now define key-level endorsement policies
    • For compatibility requirements, you can now create channels with Oracle Blockchain Platform 19.1.1 capabilities
    • REST APIs were added that allow access to instance metrics like transaction counts and CPU, memory, and disk utilization
    • Documentation is added to explain the Oracle Blockchain Platform 19.1.1 to 19.1.3 upgrade. See Upgrade Your Instance

     

    CASB Cloud

    • Integration with Oracle Cloud Infrastructure has been enhanced
    • Single sign-on through Oracle Identity Cloud Service is now supported in all registered Oracle Fusion Applications
    • Now you can trigger policy alerts based on additional actions on SharePoint and OneDrive files in Office 365 files
    • New troubleshooting topics for SAP SuccessFactors have been added. See Troubleshooting for SuccessFactors
    • Risk Events now shows ASN (autonomous system number) information for IP addresses
    • For CASB Cloud Service – Discovery, warning is provided when expected user count is exceeded
    • For CASB Cloud Service – Discovery, new key security indicators are generally available. See Key Security Indicators Tab

     

    Configuration and Compliance (part of Oracle Management Cloud)

     

    Content and Experience Cloud

    • New site governance feature makes it easy to create sites that conform to company policy, control and track sites easily
    • Now you can download site files for easy translation outside of CEC and then import the translated files
    • You can upload custom renditions of your images to suit the channel they’re published to such as mobile, tablet, web, etc.
    • Now you can browse for assets stored in Oracle WebCenter Content. See WebCenter Content and OCE
    • Now you can create and configure a custom connector to a third-party content repository
    • Content contributors can now view content metrics on the Analytics dashboard where they have a Contributor role
    • A new REST API for Content Management is now available. See REST API for Content Management
    • Now you can use Sites Toolkit to create content items for text on site pages and to enable page search for a site
    • You can now use the Starter Site CLI to get started with React development quickly

     

    Database Cloud

    • The recovery operation for dbaasapi, dbaascli, and bkup_api has changed to return only data & not the configuration files
    • The bkup_api now has a list jobs command. See Retrieve the History of Scheduled Backup Results with the bkup_api Utility
    • Now using the dbaasapi from the command line, you can get a report on the tooling and image versions
    • Oracle Documaker Enterprise Edition version 12.6.2 has been certified for use with Database Cloud Service deployments

     

    Digital Assistant

    • Now you can use the new export feature to create your own reports. See Export Insights Data
    • Support added to show top-level ODA routing analytics and popular skills by invocation. See Evaluate Usage Patterns
    • Now you can see overall trends for skills for a variety of analysis. See Skill Analytics
    • New Data Management tool lets you track your insights data storage consumption. See Data Management
    • Now you can route the user to a specific agent queue in Oracle Service Cloud. See Oracle Service Cloud Routing
    • Interrupt Flow Confidence Threshold helps you determine when to send the user a prompt and message for switch in flows
    • Channels for Slack, Skype for Business, Microsoft Teams, and Cortana have been added. See Channels
    • New System.OAuth2ResetTokens enables you to revoke all the logged-in users' refresh & access tokens from a dialog flow
    • For OAuth2AccountLink, you can now use a predefined short URL for the fixed fields, state will be dynamically populated

     

    Infrastructure Monitoring (part of Oracle Management Cloud)

     

    Integration Cloud

    New Integration Features

    New Process Features

    • You can now capture form data at multiple points in a process, store it in a DB or file system for archiving or auditing
    • Now you can introduce additional test statements (Else If statements) in If-Then-Else decisions
    • Array filtering feature in structured processes is now available. See Filter Array Data Objects
    • You can now create a Loop decision to iterate over lists or arrays. See Create Loops
    • Guidelines have been added to make decision models easy to develop, maintain, and interpret. See Best Practices
    • You can set the number of days to retain completed analytics before automatic purging (retention of 7 days by default)
    • Here's a reminder to set the number of days to retain completed process instances before they get purged. See Purge

     

    IT Analytics (part of Oracle Management Cloud)

    • Now you can access the Exadata Overview page from the new Exadata menu in the OMC Navigation pane
    • You can now specify the high and low threshold values in the IT Analytics Settings page. See Configure Capacity Thresholds

     

    Java Cloud

    • Now you can provision an Oracle Cloud Infrastructure (OCI) Load Balancer for your service instance on OCI
    • You can now connect a service instance to an Autonomous Transaction Processing or Oracle Cloud Infrastructure database
    • Now using the REST API or CLI, you can download a backup, decrypt it, and extract its contents
    • Scheduled backups are now disabled automatically after seven errors of any type
    • Notification email is now optional for automatic backup disabling
    • For Software Edition, the option Enterprise Edition with Coherence has been renamed to High Performance Edition in the Oracle Java Cloud Service instance creation wizard

     

    Log Analytics (part of Oracle Management Cloud)

    • As an administrator, now you can have finer control on the access provided to each user of Oracle Log Analytics
    • Now you can select the data to purge by specifying a time ranges. See Purge Log Data
    • You can now export the log parsers and user-defined log sources to an XML file using the Oracle Log Analytics
    • Now you can mask the log data using the hash mask to generate a unique hash for each found value of the masked data

     

    Management Cloud

    • Enhancements have been made in the Card visualization and Table visualization option in Data Explorer
    • Now last selected entity context is displayed in dashboards if an entity is not selected in the Global Context Entity Selector
    • In the Topology view, Siebel component nodes are now collated into the Siebel server node

     

    Security Monitoring and Analytics (part of Oracle Management Cloud)

     

    Self-Service Integration

    • Guided Tours are now available for SSI developers

     

    Visual Builder Cloud

     

    See Oracle Cloud Platform Documentation for more details

  • John Klinke
    January 2019 Release Update for Oracle Cloud Platform4.0
    Announcement posted February 1, 2019 by John KlinkeBronze Medal: 1,250+ Points, tagged Analytics, API Management, ATP, Autonomous Data Warehouse, Big Data, Business Intelligence, CASB, Content and Experience, Data Integration, Data Visualization, Database, Developer, Essbase, Identity, Integration, Internet of Things, Java, Management, Mobile and Intelligent Bots, Process Automation, Visual Builder in Platform Members > Oracle Cloud Infrastructure and Platform Announcements public
    Title:
    January 2019 Release Update for Oracle Cloud Platform
    Abstract:

    We are pleased to announce new updates and enhancements to our comprehensive portfolio of PaaS solutions. A summary of Oracle Cloud Platform release updates for January 2019 are listed below. See Oracle Cloud Platform Documentation for more details.

    Announcement:

    Analytics Cloud

    Service Management

    • Deployments on OCI are renamed to “Oracle Analytics Cloud”, previously known as Oracle Autonomous Analytics Cloud
    • Now deployments on OCI Classic are named “Oracle Analytics Cloud – Classic”, previously known as Oracle Analytics Cloud
    • You can now create trial instances faster by setting up Oracle Analytics Cloud on OCI Classic with a single click. See link
    • While setting up Analytics Cloud, now you’ll be asked which identity domain you want to use, if more than one is available
    • Now you can migrate content easily between Oracle Analytics Cloud environments using snapshots
    • Additional menu options in Console make migration from Oracle BI Enterprise Edition 11g easier now
    • Enhancements were made to Snapshot. See Options When You Take a Snapshot and Options When You Restore a Snapshot
    • Data file migration utility now moves data files from one Oracle Analytics Cloud environment to another
    • Now you can set configuration options required for advanced use cases through Console. See Configure Advanced Options

    Data Visualization

    • Now you can easily create a connection to Oracle Autonomous Data Warehouse. See link
    • You can now create connections to Oracle Autonomous Transaction Processing. See link

    Essbase

    • By selecting tuples, you can now focus your calculations in the active Smart View grid, limiting scope to specific data slices
    • Now you can specify the ancestor position for hierarchies in ad hoc grids in Smart View
    • New gallery templates are available in Files catalog. See Explore the Gallery Templates
    • You can create aggregation views to be generated automatically. See Create & Manage Cube Outlines with Web Interface
    • You can now select multiple cells or multiple ranges of cells, and see the merged results in drill through
    • In the Essbase web interface, you can now create a connection and datasource to Oracle Autonomous Data Warehouse

    Pixel-Perfect Reporting

    • You can view an Essbase cube and filter data for reports with POV parameter in an MDX query
    • Now Snapshot includes pixel-perfect reporting. See Take Snapshots and Restore

     

    API Platform Cloud

    • New policy allows you to enable end-user identity to be passed over multiple hops before reaching destination web service
    • New policy allows enforcing verification of credentials sent within SOAP payload & allows authorized users to access APIs

     

    Autonomous Data Warehouse

    • Autonomous Data Warehouse now allows you to directly query and load data stored as parquet files in object stores

     

    Blockchain Platform

    • Oracle Blockchain Cloud Service has been renamed to Oracle Blockchain Platform

     

    CASB Cloud

    Oracle CASB Cloud Service

    • Integration with Oracle Cloud Infrastructure (OCI) has been enhanced
    • SAP SuccessFactors has new enhancements now
    • Microsoft Office 365 policy alerts can now trigger on sharing level
    • Enabling business object auditing is now largely automated for Oracle ERP Cloud and Oracle HCM Cloud

    Oracle CASB Cloud Service — Discovery

    • Navigation menu Discovery option now accesses Oracle CASB Cloud Service - Discovery
    • 11 new key security indicators have been added to the original two ("Users with most apps" and "Top 10 most used apps")
    • Discovery key security indicators are now displayed on a separate Key Security Indicators tab on the new Discovery page
    • Now all key security indicators drill down to details in the discovered applications data

     

    Configuration and Compliance (part of Oracle Management Cloud)

    • SCAP results can be uploaded from OpenSCAP and other SCAP engines directly to Configuration and Compliance
    • Now a complete, self-contained HTML report can be generated for any historic assessment

     

    Data Integration Platform Cloud

    • Architectural changes to Remote Agents require recreating agent to perform new Synchronize Data jobs using Initial Load
    • Microsoft SQL Server is now available for Windows Remote Agents
    • Data Integration Platform Cloud now supports additional data sources. See What's Certified for Agents?
    • Support has been added for remote execution of a Synchronize Data Task that includes Initial Load from behind a firewall
    • Now data can be delivered to Autonomous Data Warehouse targets
    • You can now create a Data Lake using the Data Lake Configuration Element
    • The ODI Execution task now supports Autonomous Data Warehouse Cloud and Oracle Object Storage Connection types
    • Now supports Oracle Object Storage Classic as a source or target Connection type
    • You can now create Policies to schedule job executions
    • Catalog now lists Data Assets and Execution Environments after you create them

     

    Database Cloud Schema

    • Using TLS 1.2 protocol certain Outbound HTTPS network connections can be established from Schema Service

     

    Developer Cloud

    • Support for OCI Compute and OCI Object Storage was added
    • Design for the left navigation bar has been updated
    • New shared Organization Page and Project Home page are available now. See Manage the Organization
    • Now Project Home page provides an improved view of the project's actions, repositories, team members, and statistics
    • Banner with latest news from the DevCS team is now displayed in the page header of Organization and Project Home pages
    • Unpublished changes in Wiki pages are automatically saved as drafts now
    • Breadcrumbs have been enhanced to provide navigation to many child pages so you don't have to use the Navigation bar
    • You can use a named password in a project's build job configurations now
    • A newer version of Firefox is now available in the Software Catalog of Build VM templates
    • Approval-based merge request restrictions are available now. See Set Push and Merge Restrictions on a Branch

     

    Integration

    New Common Features

    • The name “Oracle Integration Cloud” has been shortened to “Oracle Integration”
    • Our user-managed version is now called “Oracle Integration Classic”. These name changes have no impact on functionality

    New Processes Features

     

    Internet of Things Cloud

     

    IT Analytics (part of Oracle Management Cloud)

    • Now the overview page provides an integrated view of monitoring, logs, & analytics on Exadata systems across enterprise

     

    Log Analytics (part of Oracle Management Cloud)

    • You can now upload your log files using On Demand Upload (ODU) wizard on the service console of Oracle Log Analytics

     

    Management Cloud

    • New Edit mode is available for dashboards & dashboard sets. See Create Custom Dashboards & Create Dashboard Sets
    • A hard limit has been introduced on the number of widgets in a dashboard and the number of tabs in a dashboard set
    • Enhancement has been made to the Widget Title Linking feature in dashboards to add custom link to a Widget title
    • New Save As option is added to customize an out-of-the-box widget or a widget created by another user from a dashboard

     

    SOA Cloud

    • You can now update the storage container for backups from the instance administration page
    • Users are recommended to use newer versions of Oracle SOA Suite as Oracle SOA Suite 12.2.1.2.0 is being phased out soon

     

    See Oracle Cloud Platform Documentation for more details

  • John Klinke
    December Release Update for Oracle Cloud Platform5.0
    Announcement posted January 4, 2019 by John KlinkeBronze Medal: 1,250+ Points, tagged Analytics, API Management, Big Data, Business Intelligence, CASB, Content and Experience, Data Integration, Data Visualization, Database, Database Backup, Developer, Identity, Integration, Internet of Things, Java, Management, Mobile Analytics, Mobile and Intelligent Bots, Process Automation, Visual Builder in Platform Members > Oracle Cloud Infrastructure and Platform Announcements public
    Title:
    December Release Update for Oracle Cloud Platform
    Abstract:

    We are pleased to announce new updates and enhancements to our comprehensive portfolio of PaaS solutions. A summary of Oracle Cloud Platform release updates for December 2018 are listed below. See Oracle Cloud Platform Documentation for more details.

    Announcement:

    Big Data Cloud

    • Now includes Sparkline SNAP, a terabyte-scale OLAP option on Spark
    • Invalid REST request URLs now return 404 error

     

    Big Data Cloud Service

    • The system software has been updated to release 4.13.1. This includes Cloudera Distribution with Hadoop (CDH) 5.14.1
    • The Notebook tools are now built on Apache Zeppelin 0.8.0, upgraded from Apache Zeppelin 0.7.2
    • The spark interpreter has replaced the spark2 interpreter. Now the interpreters can be scoped per user and/or per note
    • Time-out based interpreter life-cycle management is available now
    • You can now upload directories from your local computer to HDFS
    • 2 new job types are available: ODHI Query (for generic queries against Hive) and ODHI Import (for loading data into Hive)
    • Data Explorer page allows you to right-click an HDFS file and see partial content of the file with syntax highlighting
    • When creating a new job, you can now select to execute it immediately or to specify its schedule

     

    Blockchain Cloud

    • You can now use longer channel names with a limit of 128 characters in the channel name
    • When a peer is removed from the network, it is automatically removed from any REST proxy configuration that includes it
    • When you deploy a chaincode, you can now select to enable it in multiple REST proxies
    • You can now go to the console's About menu to find your instance's creation date and time

     

    CASB Cloud

    • You can now create policy alerts for identity compartment and identity federation objects
    • Now the threshold risk level can be set for OCI and IDCS security controls
    • You can now register Azure without Azure AD monitoring, which requires only an E3 license. See Adding an Azure Instance
    • You can now register a SuccessFactors instance to be monitored by Oracle CASB Cloud Service
    • Policy alerts are now generated automatically, based on tags assigned to discovered applications
    • You can create custom policy alerts, based on tags assigned to discovered applications
    • The new "irrelevant" tag is available for you to assign to discovered applications
    • Now you can sort on tags assigned to discovered applications
    • You can now collect logs from an external account for an AWS instance that you register with CASB

     

    Content and Experience Cloud

    • Web client and mobile apps now have a Home option in the navigation menu
    • Now you can manage translation jobs through the Translation Jobs page
    • You can now associate conversations with assets, content items, and sites
    • Now the toolbar in the rich-text editor in content types can be customized
    • You can now use VBCS and DevCS to develop forms for CEC sites, and use the forms on CEC sites
    • There are changes in administrator roles. See Content Metrics, Web Analytics Tracking Snippets, and Integrate the Service
    • Developers can now expand macros in content list queries for marketers to use
    • You can now pass the layout category value to a content layout
    • Developers can create section layouts that support lazy load
    • The Documents Usage Log report now includes the parent path of the file or folder and the GUID of the file or folder
    • Preconfigured content connectors for Google Drive, Microsoft OneDrive, and Dropbox can be enabled by an administrator
    • Integration user can now be given access to all sites and templates

     

    Database Cloud

    • Notices of future deprecations and removals have been updated. More details here
    • Cloud tooling update is available for deployments hosting Oracle RAC databases
    • October 2018 PSU, BP and RU patches are available to be applied to existing deployments

     

    Event Hub Cloud

    • Now Apache Kafka Release 2.0.0 support is provided in addition to Kafka Release 1.1.0 support

     

    Identity Cloud

    • In addition to third-party risk providers, you can now activate and deactivate the default risk provider
    • You can now use the slider to set the weighting for events to determine risk-based activity for IDCS users
    • Enhancements have been made to SAML Application Configuration. See Adding a SAML Application
    • You can now allow clients to access OPC resources using hierarchical scope matching
    • IDCS now checks whether verification is done to the email address appearing in the From Email field for all notifications
    • Now you can migrate from traditional Cloud accounts to Cloud accounts with IDCS. More details here
    • You can now configure customized disclaimers and acceptable use policies for users on an application basis
    • Now multiple instances of the same social identity provider can be added
    • New endpoints have been added to IDCS REST APIs. More details here
    • You can now set Permissions for Microsoft Active Directory Bridge
    • Oracle Identity Cloud Service now supports CSV, JSON, and PDF report generation

     

    Infrastructure Monitoring (part of Oracle Management Cloud)

    • Support for new entities and enhanced entity association UI has been added in this release

     

    Integration Cloud

    New Common Features

    • You can change the BYOL metering option of an already existing instance

     

    New Integration Features

    • Support has been provided for Oracle Field Service Adapter to filter expressions to be added to the event subscription

     

    New Process Features

    • Now you can easily insert and configure integration activities in dynamic processes using the new Integration activity
    • User experience has been streamlined to make it easier to build expressions in web forms
    • Now you can use dynamic data to trigger the Change Presentation action
    • New performance management QuickStart App has been added
    • A new simple forms editor is available to quickly build your form
    • Now creating process applications and decision models is faster and more intuitive
    • You can now use RPA tools in your structured and dynamic processes to extend process automation
    • Process Owner and Process Reviewer roles now have better visibility into the task history of process instances
    • Dynamic process components are now available for iFrame integration using embeddable components
    • The Date Time control has been enhanced to adjust to users' time zones
    • You can now update external business objects being used in a process application by uploading a new WSDL file

     

    New Visual Builder Features

    • The Visual Builder generated applications now use Oracle JET 6.0 libraries and components
    • Additional release details are mentioned in the separate Visual Builder section below

     

    Internet of Things Cloud

    • Connector Framework lets you directly connect devices and services without using IoTCS Client Software Libraries
    • Now the new Users dashboard lets you create and manage user accounts
    • New and updated documents are now available in the Oracle Help Center

     

    Java Cloud

    • You can now associate ATP or OCI database as the infrastructure schema database when you provision your JCS instance
    • Oracle Documaker Enterprise Edition is now certified on Oracle Java Cloud Service
    • The QuickStart is unsupported for accounts with Oracle Cloud Infrastructure regions
    • New patch set updates (PSUs) are available for Oracle WebLogic Server and Java Development Kit (JDK)

     

    Log Analytics (part of Oracle Management Cloud)

    • Oracle Log Analytics now supports epoch seconds and milliseconds for the timestamp fields
    • You can use the On Demand Upload (ODU) client to upload your log files to Log Analytics through a command-line interface
    • Link feature gives you the ability to analyze user sessions, extract various parameters to help you get business insights

     

    Security Monitoring and Analytics (part of Oracle Management Cloud)

    • Now you can perform security analysis around two subsets of categories known as suspicious and malicious
    • Support for collecting security logs from monitoring sources in your IT environment has been added. More details here

     

    Self-Service Integration Cloud

    • Now you can create recipe actions against Oracle Configure Price Quote Cloud Service

     

    SOA Cloud

    • Bare Metal database support has been added for Oracle SOA Cloud Service instances on OCI in the Provisioning Wizard

     

    Visual Builder Cloud

    • Visual Builder now supports nested flows with additional features
    • iPad has been added as a deployment target option when building mobile apps
    • Additional support has been introduced for integrations
    • Improvements have been made to Page Designer, Property Inspector, Quick Starts, Action Chain editor and Event Listeners
    • Improved support has been added for installing components
    • New notifications have been added to indicate invalid or missing details for variables and types
    • The application's Settings are now displayed in an editor tab in the designer instead of a modal window
    • Support for child business objects in business rules editor has been added
    • Support for Visual Builder add-in for Excel plugin has been introduced
    • You can now specify a vanity URL for an application in the Application tab of the visual application's Settings editor

     

    See Oracle Cloud Platform Documentation for more details

  • candan pehlivanoglu
    How should we gather external table stats on bda via bigdata...15.0
    Topic posted January 2, 2019 by candan pehlivanogluGreen Ribbon: 100+ Points, tagged Analytics, Big Data Appliance, Big Data SQL, Data Management, Hadoop in Data Management > Big Data public
    Title:
    How should we gather external table stats on bda via bigdata sql.
    Summary:
    Gather stats for external tables.
    Content:

    Hello all;

    We use bds for our external tables. We have daily jobs  to ingest these tables on big data and nealry 200 tables. These tables are partitioned on hive. But, on oracle site, since there isn't any partition column, we should gather all statistic every day. It is taking too much time. Do you have any other method for this operation. Since we use these tables on oracle, Oracle should be able to know statistic information.

     

    thank you.

     

  • Kanika Khillan
    Level 0 descendents for sub parent in Reporting Web Studio34.0
    Topic posted December 11, 2018 by Kanika KhillanGreen Ribbon: 100+ Points, tagged Analytics in Enterprise Performance Mgmt > Tax Reporting public
    Title:
    Level 0 descendents for sub parent in Reporting Web Studio
    Summary:
    Unable to find option to select level 0 members for sub parent in Web studio
    Content:

    Hello,

    I am looking for a option to select level 0 members for sub parent account in Reporting Web Studio.

    Issue is, when I select any sub parent account, I could not find option for selecting level 0 (Base) members/descendants in drop down in member selection window. Bottom of hierarchy does pull all level 0 members of that dimension, but not level 0 members for any sub parent member in that dimension.

    Could you please suggest the solution for this?

    Thank you!

    Version:
    TRCS 18.12.73
    Image:
  • John Klinke
    November Release Update for Oracle Cloud Platform5.0
    Announcement posted November 28, 2018 by John KlinkeBronze Medal: 1,250+ Points, tagged Analytics, API Management, Big Data, Business Intelligence, CASB, Content and Experience, Data Integration, Data Visualization, Database, Database Backup, Developer, Exadata, Identity, Integration, Internet of Things, Java, Management, Mobile and Intelligent Bots, Process Automation, Visual Builder in Platform Members > Oracle Cloud Infrastructure and Platform Announcements public
    Title:
    November Release Update for Oracle Cloud Platform
    Abstract:

    We are pleased to announce new updates and enhancements to our comprehensive portfolio of PaaS solutions. A summary of Oracle Cloud Platform release updates for November 2018 are listed below. See Oracle Cloud Platform Documentation for more details.

    Announcement:

    API Platform Cloud

    • Now you can set rate limits for specific actions in the API. See Setting a Rate Limit for an Entitlement
    • Support for Apiary Actions in the Interface Filtering and Method Mapping Policies has been added
    • You can now filter analytics results by plans, services, and methods. See Filtering Analytics
    • New element called “ScopeClaimDataType” now allows specifying the scope values in JWT
    • You can now add custom pages to the Developer Portal. See Managing Custom Pages

     

    Big Data Cloud

    • Now Apache Spark 1.6 is deprecated and will be removed in a future release, workloads should be migrated to Spark 2.x
    • The identity domain ID and the cluster ID specified in REST requests are now scanned for errors and issues

     

    Blockchain Cloud

    • You can now import and use certificates issued by client-only (external) CAs into an existing blockchain network
    • Now Chaincodes can get the identity of the REST proxy caller to safely use the authenticated identity
    • Use new QuickStart templates to quickly create instances in Developer, Enterprise-X1 & Enterprise-X4 configurations
    • You can now delete an organization from a channel using Edit Configuration option console’s Channels tab
    • Now you can use Oracle Identity Cloud Service federation with remote identity providers
    • You can asynchronously shadow blockchain transaction history for any channel ledger to an Oracle database
    • The Balance Transfer and Car Dealer sample chaincodes are now available in Node.js
    • Functionality has been added to display the chaincode’s endorsement policy and ensure chosen peers satisfy the policy

     

    CASB Cloud

     

    Content and Experience Cloud

    • The sites, templates, and assets user interface have been updated with new views
    • Now you can export assets for easy translation outside of Oracle CEC, and then import the translated files
    • You can now import content into your asset repository from third-party tools like Dropbox, Google, and OneDrive
    • New and improved analytics is available for administrative users
    • You can now download Sites Toolkit and set it up on your local machine to develop with Oracle DeveloperCS
    • The template VBCSSamplesTemplate.zip has been added to Sites Toolkit to integrate Oracle VBCS apps with CEC

     

    Database Cloud

    • The July 2018 PSU, BP or RU, depending on DB version, are now integrated into base image for single-instance DB
    • Database Cloud patching time is now faster by approximately 50%
    • New versions for SQL Developer Web, ORDS, APEX and ORE have been integrated into base image for single-instance DB

     

    Database Exadata Express Cloud

    • All existing Exadata Express customers have been upgraded to APEX version 18.2. See New Features

     

    Database Schema Service

    • All Database Schema Service environments have been upgraded to Oracle Application Express (APEX) version 18.2

     

    Developer Cloud

    • You can now configure a job to trigger a Wercker pipeline when the job’s build runs
    • Now you can configure a job to run Fn commands on a Fn server when the job’s build runs
    • From the Environments page, you can now start, stop, and restart services instances of an environment
    • In the shell commands of a job, you can now use the internal URL of an external Git repository added to a project
    • OCIcli 2.4.32, Packer 1.2.4 and Fn 0.5 are now available in the build executors
    • A project owner can now configure the project’s Maven repository to overwrite artifacts
    • A Git repository’s URLs and download links are now available in the Clone drop-down menu
    • When you add a block comment to a wiki, an auto-watch is set and you get email notifications for changes made

     

    Digital Assistant

    • Now you can create your own digital assistant, a “master bot” that fields requests from multiple skills (chatbots).
    • You can now track conversation trends over time, identify execution paths, determine the accuracy of your intent resolutions, and much more.
    • Your ODA can initiate a conversation with your user whenever it receives a triggering event from another app.
    • New features for instant apps, including localization, bring-your-own CSS support, new styling and an updated look and feel.
    • New System.OAuth2AccountLink component, which completes all the steps for the three-legged OAuth2 flow and returns the OAuth2 access token
    • Now you can define parameters that start with “da” and use them by all the skills that are registered in the same digital assistant.
    • Properties of the System.Intent component, like confidenceLevel and winMargin, are now configured as settings through the UI, instead of from the dialog flow.
    • Entities have a whole set of new features, including pagination, fuzzy matching, and multiple value selection.
    • Composite bag entities can now include non-entity members.
    • ODA now lets you define your intents and custom entities in both English and Simplified Chinese, without having to first configure an auto-translation service.

     

    Event Hub Cloud

    • You can now create, delete and edit Oracle Event Hub Topics from Event Hub Console

     

    GoldenGate Cloud

    • You can now create Oracle GoldenGate Cloud instances with Oracle GoldenGate 18.1 classic and microservices versions

     

    Integration Cloud

    New Processes Features

    • You now have the option of customizing presentations in addition to cloning them. See Work with Presentations
    • Now you can initiate a POST operation while executing REST connector calls in form events and set request-body
    • New “Matches” function is available to check if two strings or expressions match, and returns a Boolean value
    • Now when configuring global connectors, you can select the new Ignore connector error option
    • You can now print forms that contain train component controls (Note that only the selected step is printed)
    • Now you can use the new Append action in the data association editor to add elements to a target array
    • Mapping data within structured processes, allows specifying fallback (default) value in addition to data source argument
    • You can now create decision tables with more than one output variable
    • Now update external business objects already being used in a process application by uploading a new XSD or JSON file
    • REST API options for retrieving dynamic process resources are added

     

    Internet of Things Cloud

     

    Java Cloud

    • Using the REST API, you can now create a service instance that is attached to a private subnet in OCI
    • Now service nodes created in OCI regions (release 18.4.2 or later), get nodes distributed evenly across fault domains
    • You can now update protected context roots after creating a JCS instance with IDCS enabled for authentication
    • Now you can use REST API to change the domain name in WebLogic Server console URL after service instance provision
    • For service instance creation in OCI region, you can choose OCI Load Balancing service as the managed load balancer
    • Now you can provision multiple WebLogic clusters when you provision an Oracle-managed load balancer for JCS on OCI
    • You can now upgrade the WebLogic Server release on which JCS was created to release 12.2.1.3

     

    Log Analytics (part of Oracle Management Cloud)

    • Now search for an extended field based on the how it was created, the type of base field, or with example content
    • You can search for a label based on any of the parameters defined for the labels like Creation Type, Input Field, etc.
    • Before adding a preprocessing function to a parser, now you can test the correctness of the field values and view results

     

    Mobile Cloud

    • Now you can quickly and easily migrate your mobile configurations to Oracle Mobile Cloud using scripts
    • To keep the volume of analytics data under control, now accumulated API calls are automatically deleted every 24 hrs

     

    See Oracle Cloud Platform Documentation for more details

  • Martin Jarvis
    Announcement: New Release of Oracle Digital Assistant is now...25.0
    Topic posted November 28, 2018 by Martin JarvisSilver Medal: 2,000+ Points, tagged Analytics, Bots, Conversational AI, Messaging in Application Development > Digital Assistant and Mobile public
    Title:
    Announcement: New Release of Oracle Digital Assistant is now available !
    Summary:
    Oracle Digital Assistant New Release (18.4.3)
    Content:

    Oracle Digital Assistant New Release (18.4.3)

    We are delighted to announce that the next major release, 18.4.3, of our AI powered Digital Assistant platform is now available in all OCI data centres (Ashburn, Phoenix, Frankfurt and London). This release represents a major evolution in our service, moving on from 1st generation chatbots to now enabling enterprises to deliver 2nd generation Digital Assistants to their customer and employees.

    Over the coming months, and through our continued engagement with the SaaS teams, our customers will benefit from a growing list of out of the box SaaS Skills, pre-integrated and ready-to-go. Customers will able to combine these SaaS skills with Skills they have developed themselves or adapt the supplied skills to their needs.

    New instances are being provisioned with 18.4.3 now and existing instances are due to be upgraded this week.

    We now have the strongest and most complete Digital Assistant platform in the industry. We know you are going to love this new release.

    Key New Features
    With over 25 new features, this release brings even more innovation to position us as the leading Digital Assistant Platform for the Enterprise. Here are a few of these exciting new features.  Click here for more information on What's New in Oracle Digital Assistant.

    Digital Assistants & Skills
    Rather than having multiple, individual chatbots for your enterprise, a Digital Assistant allows enterprises to deliver multiple services or Skills as if they were a single service, but accessible through multiple channels.

    Skill Insights
    Delivering a superior conversational experience requires on-going monitoring of user activity to assure all dialog flows result in successful completion. Insights includes analytics to allow administrators to monitor, trouble-shoot and enhance the value and performance of their Digital Assistant. It helps them find bot dialog and intent problems and fix them.

    Application Initiated Conversations
    Sometimes it’s not enough to have the customer initiate all the conversations with your skills. You may want your Digital Assistant to initiate a conversation with your user whenever it receives a triggering event from another app—like when a user’s expense report is rejected, for example. 

    Chinese Language Support
    Oracle Digital Assistant now lets you define your intents and custom entities in both English and Simplified Chinese, without having to first configure an auto-translation service. Further languages will be added using this language framework in the future. Whilst we are talking Chinese language support, we added support for the WeChat messenger app too.

    And Much More
    Built in greeting support, Composite bag entities, Dynamic entities, Auto entity disambiguation, WebView component, Skill version & life cycle management, Built in Node.js custom code container, Full 3-legged OAuth, Multi session token refresh, Twillio support (for SMS).

  • Michel Schoolenaar
    Tax Reporting Cloud Service Hands-On Workshop...14.0
    Topic posted November 9, 2018 by Michel SchoolenaarSilver Medal: 2,000+ Points, tagged Administration, Analytics, Consolidation, Country by Country, Current Tax, Data Integration, Deferred Tax, Foreign Exchange, Return to Accrual, Smartview, Supplemental Data, Task Manager, Tax Account Rollforward, Tax Provision, Tip in Enterprise Performance Mgmt > Tax Reporting public
    Title:
    Tax Reporting Cloud Service Hands-On Workshop (Live-Virtual-Class), November 22-23
    Summary:
    APAC timezone - Tax Reporting Cloud Service Hands-On Workshop (Live-Virtual-Class), November 22-23
    Content:

    1.5-Day Deep Dive, Hands-on Partner Training for Tax Reporting Cloud Service.

    Dear Valued SaaS Partner,
    Oracle invites you to attend the Tax Reporting Cloud Service Workshop at Oracle Hong Kong Office or join the Live-Virtual-Class  using WebEx. This event requires registration.

     

    This training will be for consultants experienced in Tax provisioning or Hyperion consolidation solutions (HFM, FCCS) who are interested in bringing tax and finance together and details on configurations and implementation for TRCS on the Oracle EPM Cloud. This will be delivered by EPM Product Management.

     

    Topic: APAC Tax Reporting Cloud Service Hands On Workshop (Live-Virtual-Class)

    Speaker: Michel Schoolenaar, Senior Principal Product Manager

    Venue: Oracle Hong Kong Office, 8/F, Lee Garden Three, 1 Sunning Rd, Causeway Bay, Hong Kong
    Date and Time:
    Thursday, 22 November 2018 9:00, Singapore Time (Singapore, GMT+08:00) to Thursday, 22 November 2018 17:00, Singapore Time (Singapore, GMT+08:00)
    Friday, 23 November 2018 9:00, Singapore Time (Singapore, GMT+08:00) to Friday, 23 November 2018 13:00, Singapore Time (Singapore, GMT+08:00)

     

    Agenda:

    • Tax Reporting intermediate and advanced concepts
    • Implementation guide and “Tips and Tricks"

    Audience profile: Free to APAC SaaS OPN members 

    Pre-requisites: Consultants experienced in Tax provisioning or Hyperion consolidation solutions (HFM, FCCS)

     

    -------------------------------------------------------
    To register for the online event
    -------------------------------------------------------
    1. Go to https://oracletalk.webex.com/oracletalk/onstage/g.php?MTID=e9dec065e21e26b11d723cd215c2035e3 (Day 1)

    2. Go to https://oracletalk.webex.com/oracletalk/onstage/g.php?MTID=e48103c2702e9b2901ae17876e2a96a70 (Day 2)
    3. Click "Register".
    4. On the registration form, enter your information and then click "Submit".

    Oracle profile badging

    When registering for this event you will be asked to login using an Oracle corporate single sign-on account. Partners can verify existing accounts or create new accounts using their business email address on the Oracle PartnerNetwork portal. Please note that only business email addresses are accepted  for registration to our events.

    Once Oracle approves your registration, you will receive a confirmation email message with instructions on how to join the event.

    -------------------------------------------------------
    For assistance
    -------------------------------------------------------
    You can contact your local Alliances & Channels Manager.

  • Marty Gubar
    Big Data SQL 3.2 - Cloudera Certified5.0
    Topic posted October 29, 2018 by Marty GubarBlue Ribbon: 750+ Points, tagged Analytics, Big Data Appliance, Big Data SQL, Data Management, Hadoop, SQL, Tip in Data Management > Big Data public
    Title:
    Big Data SQL 3.2 - Cloudera Certified
    Summary:
    Big Data SQL 3.2.1 is now officially certified with Cloudera 5.14.1
    Content:

    Big Data SQL 3.2.1 is now officially Cloudera Certified (see Oracle certified products here).  The certification took place with Cloudera 5.14.1.  The testing captures real world functional integration usage of the product on a cluster that meets certain security requirements, including:

    • Kerberos
    • Sentry
    • HDFS Encryption
    • Auditing
    • Network Encryption. 

    It also examines the product architecture, including integration with Cloudera Manager and key CDH Components.  Finally, it reviews how the product leverages scale-out processing on Hadoop clusters.