1 / 9

OpenWorld 2018 How to Get Value from Data in Oracle Analytics Cloud

Learn how to leverage data in Oracle Analytics Cloud to gain valuable insights. Explore configuration, metadata, uploading repositories, and creating variables.

kburke
Download Presentation

OpenWorld 2018 How to Get Value from Data in Oracle Analytics Cloud

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. OpenWorld 2018How to Get Value from Data in Oracle Analytics Cloud Phillip ScottSenior Principal Instructor2018 Confidential – Oracle Internal/Restricted/Highly Restricted

  2. Safe Harbor Statement The following is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, timing, and pricing of any features or functionality described for Oracle’s products may change and remains at the sole discretion of Oracle Corporation. Confidential – Oracle Internal/Restricted/Highly Restricted

  3. Singleton Data Dictionary • There is a clear separation between environment configuration and environment metadata. Configuration files are no longer duplicated. • Separate configuration files still exist, but they are not duplicated for a cluster. • Oracle Business Intelligence metadata is stored in a Singleton Data Directory (SDD). • SDD is used for metadata and other cross-cluster files. • There is one SDD for each domain. • The default location is set to DOMAIN_HOME/bidata. • The SDD path is defined in the bi-environment.xml file located in: DOMAIN_HOME/config/fmwconfig/bienv/core/bi-environment.xml

  4. Uploading a Repository to BI Cloud Services • You can upload an on-premises repository (.rpd file) created with Oracle BI Enterprise Edition to Oracle BI Cloud Service. • After uploading an on-premises data model to the cloud, you can build visualizations, analyses, and dashboards with Oracle BI Cloud Service in the usual way. Access the Service Console for Oracle BI Cloud Service and click the Replace Data Model button.

  5. Data Modeler UI Elements– Unlocked Model Dimension Tables Model name Fact Tables Click to lock the model Source tables and views Model objects Join conditions Managed by the service administrator (read only)

  6. Creating Variables in Data Modeler Name the variable SQL query to initialize the variable Click to test the query Click to save the variable

  7. WIDTH_BUCKET Function • WIDTH_BUCKET returns either the bin number or one of the two end points of the bin interval. Low Range Number High Range

  8. TRENDLINE Function

More Related