Loading Data from Oracle Field Service Cloud into Oracle BI Cloud Service using REST

Introduction This post details a method of extracting and loading data from Oracle Field Service Cloud (OFSC) into the Oracle Business Intelligence Cloud Service (BICS) using RESTful services. It is a companion to the A-Team post Loading Data from Oracle Field Service Cloud into Oracle BI Cloud Service using SOAP . Both this post and […]

Loading Data from Oracle Identity Cloud Service into Oracle BI Cloud Service using REST

Introduction This post details a method of extracting and loading data from Oracle Identity Cloud Service (IDCS) into the Oracle Business Intelligence Cloud Service (BICS). It builds upon the A-team post IDCS Audit Event REST API which details the REST API calls used. One use case for this method is for analyzing trends regarding audit events. […]

Loading Data from Oracle Field Service Cloud into Oracle BI Cloud Service using SOAP

Introduction This post details a method of extracting and loading data from Oracle Field Service Cloud (OFSC) into the Oracle Business Intelligence Cloud Service (BICS). A compelling reason to use such a method is when data is required that is not in the standard daily extract. Such data might be planning (future) data or data […]

Loading Data into Oracle BI Cloud Service using OTBI Analyses and SOAP

Introduction This post details a method of loading data that has been extracted from Oracle Transactional Business Intelligence (OTBI) using SOAP into the Oracle Business Intelligence Cloud Service (BICS). The OTBI instance may either be Cloud-Based or On-Premise. This method may also be used to load data from Oracle Business Intelligence Enterprise Edition (OBIEE). It […]

Oracle Business Intelligence – MDS XML in RPD

Introduction Oracle Business Intelligence (OBIEE) platform is a development framework, where multi-users can create and work on a common object model and store them into a repository (for detailed information about the repository refer to this Blog). These models form the foundation for the Business Users to create Analyses, Dashboards, Key Performance Indicators (KPIs) and […]

How to Examine the SQL in a BI Answers Report

Introduction In a standalone OBIEE environment, or within the Analytics Reporting home page of Fusion Applications, there may be occasions where it would be useful to find the SQL being generated against the underlying database by the BI Presentation Server.  This post presents one method to locate this SQL. Main Article The first step is […]

Fusion BI RPD and Webcat files

Introduction Oracle Fusion Applications have a built in Business Intelligence framework based on Oracle Business Intelligence Enterprise Edition (OBIEE). With this framework, organizations are provided with the capabilities of transforming their business process automation systems into powerful Business Intelligence systems. There are many components which constitute the Business Intelligence suite within Fusion Applications but two […]

Installing and Configuring BI Admin Tool for Fusion Applications

Introduction The Repository, or ‘RPD’, is the file that contains the metadata for the BI Server in Fusion Applications.  This includes database connections, tables, joins, and structure by which these are presented to the report writer.  In order to read, or make changes to the RPD file, the BI Administration Tool must be installed. While […]

Index of BI and Reporting articles

Provides information on how Fusion Applications makes use of BI, both in terms of OTBI as well as the warehouse option for Fusion Applications. The information found here is intended for on-premise customers. The best practices and operational aspects of the content in this site is a service provided as a part of the Fusion […]

Generating barcodes in reports

I recently had a comment posted on a previous blog post regarding generating barcodes in the reports that come with the records management module (either in WebCenter Content/UCM or WebCenter Content: Records/URM).  

I knew we could o…

Configuring Essbase Cluster for Fusion Applications

If you have provisioned an FA environment using Release 3 (11.1.3) or Release 4 (11.1.4) and followed Chapter 14 of the Enterprise Deployment Guide to cluster BI and Essbase, you will get an error similar to the one below when running Create Cubes ESS …