Creating a Dashboard Landing Navigation Page in Oracle Analytics Cloud (OAC) & Oracle Business Intelligence (OBI/OBIEE)

Background                                                                         Dashboard Landing Navigation Pages (also known as start page, landing page, default page, default dashboard, home page) can be […]

Using the Oracle Business Intelligence Cloud Service (BICS) REST API to Clear Cached Data

Introduction   This article describes how to use the Oracle Business Intelligence Cloud Service (BICS) REST API dbcache method to clear the BI Server cached data. Prior to dbcache being added to the BICS REST API, the cache could be cleared by unlocking the Model (in Modeler) and running “Clear All Cached Data”. For DataSync version 1.2 and […]

Integrating Oracle Data as a Service for Customer Intelligence (DaaS for CI) with Oracle Business Intelligence Cloud Service (BICS)

Introduction   This article provides a set of sample code snippets for loading data from Oracle Data as a Service for Customer Intelligence (DaaS for CI) into an Oracle Business Intelligence Cloud Service (BICS) Schema Service Database. “Oracle Data as a Service for Customer Intelligence (DaaS for CI) enables you to analyze your own unstructured text as […]

Integrating Oracle Sales Cloud (OSC) with Oracle Database as a Service (DBaaS) using PL/SQL

Introduction This article describes how to integrate Oracle Sales Cloud (OCS) with Oracle Database as a Service (DBaaS) using PL/SQL.The code snippet provided uses the REST API for Oracle Sales Cloud to create a new OSC contact from DbaaS. The PL/SQL uses UTL_HTTP commands to call the REST API for Oracle Sales Cloud.A sample use case for this […]

Integrating Oracle Sales Cloud with Oracle Business Intelligence Cloud Service (BICS) – Part 2

Introduction   This article provides a fresh approach on the subject of integrating Oracle Sales Cloud with Oracle Business Intelligence Cloud Service (BICS). Integrating Oracle Sales Cloud with Oracle Business Intelligence Cloud Service (BICS) – Part 1, showcased how to use Oracle Transactional Business Intelligence (OTBI) to extract data from Sales Cloud and load it […]

Pipelined Table Functions in Oracle Business Intelligence Cloud Service (BICS)

Introduction   This article outlines how to use a pipelined table function in Oracle Business Intelligence Cloud Service (BICS). Using a pipelined table function makes it is possible to display data in BICS without having to load the data to a physical table. Two possible use cases for pipelined table functions in BICS are: 1) […]

Integrating Social Relationship Management (SRM) with Oracle Business Intelligence Cloud Service (BICS)

Introduction   This article outlines how to integrate Social Relationship Management (SRM) with Oracle Business Intelligence Cloud Service (BICS). Bringing the SRM records into BICS enables the data consumer to refine and focus on relevant data through prompts and filters. Additionally, once in BICS, the SRM data can be mashed with complementary datasets.Three patterns are covered: (a) Managing SRM authentication, authorization, and token […]

Integrating Oracle Social Data and Insight Cloud Service with Oracle Business Intelligence Cloud Service (BICS)

Introduction   This article outlines how to integrate Oracle Social Data and Insight Cloud Service with Oracle Business Intelligence Cloud Service (BICS). Two primary data movement patterns are described: (a) JSON data is retrieved from an external cloud source using REST Web Services. (b) Data is inserted into the Schema Service database with Apex PL/SQL functions. […]

Integrating Oracle Service Cloud (RightNow) with Oracle Business Intelligence Cloud Service (BICS) – Part 2

Introduction This article expands on “Integrating Oracle Service Cloud (RightNow) with Oracle Business Intelligence Cloud Service (BICS) – Part 1” published in June 2015. Please Note – this article is intended to provide the reader with some ideas of how to start an integration with Service Cloud.  The reader would also need to consider other factors such […]

Executing a Stored Procedure from Oracle Analytics Cloud Service (OACS)

Background This blog was originally published on Sept 8th, 2015 for Oracle Business Intelligence Cloud Service (BICS). It was updated on Jan 22nd, 2019 for Oracle Analytics Cloud Service (OACS). The article describes how to configure a link on a Oracle Analytics Cloud Service (OACS) Dashboard that allows a OACS consumer to execute a stored […]

Integrating Oracle Fusion Applications – WebCenter / Universal Content Management (UCM) with Oracle Business Intelligence Cloud Service (BICS)

Introduction   This article describes how to integrate Oracle Fusion Applications – WebCenter / Universal Content Management (UCM) with Oracle Business Intelligence Cloud Service (BICS). The integration pattern covered shares similarities to those addressed in the previously published A-Team blog on: “Integrating Oracle Fusion Sales Cloud with Oracle Business Intelligence Cloud Service (BICS)”. The motivation behind this article […]

Integrating JSON responses with Oracle Business Intelligence Cloud Service (BICS)

Introduction This article outlines how to automate the loading of a JSON response into Oracle BI Cloud Service (BICS) via Oracle Application Express (Oracle Apex). The solution is PL/SQL based and can also be used for non-BICS database environments such as Oracle DbaaS and Oracle Database Schema Service. The main components of the PL/SQL code […]

Integrating Oracle Service Cloud (RightNow) with Oracle Business Intelligence Cloud Service (BICS) – Part 1

Introduction This article describes how to integrate Oracle Service Cloud (RightNow) with Business Intelligence Cloud Service (BICS), illustrating how to programmatically load Service Cloud (RightNow) data into BICS, making it readily available to model and display on BICS dashboards. PLEASE NOTE – this article is intended to provide the reader with some ideas of how […]

Integrating Oracle Sales Cloud with Oracle Business Intelligence Cloud Service (BICS) – Part 1

Introduction This blog describes how to integrate Oracle Sales Cloud with Business Intelligence Cloud Service (BICS). The blog outlines how to programmatically load Sales Cloud data into BICS, making it readily available to model and display on BICS dashboards. Three artifacts are created in the process: 1)    OTBI Answers / Analysis Request Sales Cloud data […]

OBIEE Developer-controlled BI Cache Settings (On-Premise and SaaS)

Introduction As an Oracle Business Intelligence (BI) Developer, you may not always have direct access to the BI Common Semantic Model (RPD) or the underlining Operating System. This can make it difficult or near impossible to change the global cache settings. That said, as a developer, you can still change the cache settings at the […]

OBIEE Troubleshooting RPD Patching Issues

Introduction At times a BI patch may fail with RPD consistency errors. If so, it may be beneficial to perform some initial troubleshooting  steps to pinpoint the root cause of the errors. This blog describes how to read and download the various patch RPD and log files. Additionally, it gives insight into how these files […]

How to Hide the Catalog UI from the Global Header in Oracle Analytics Cloud Service (OACS)

Background This blog was originally published on Feb 3, 2014 for Oracle Business Intelligence Enterprise Edition (OBIEE). It was updated on Jan 23rd, 2019 for Oracle Analytics Cloud Service (OACS). The steps are still applicable to Oracle Business Intelligence Cloud Service (BICS) and Oracle Business Intelligence Enterprise Edition (OBIEE). By default all users with the BI […]