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...
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 procedure from a OACS Dashboard. The sames steps can be followed for Oracle Business Intelligence Enterprise Edition (OBIEE/OBI). In the...
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...
Introduction Event Based notification functionality for Oracle's BI Cloud Service (BICS) will be available later this year, but until that time some of the same...
Introduction Event Based notification functionality for Oracle's BI Cloud Service (BICS) will be available later this year, but until that time some of the same functionality can be created through Apex. This article will walk through a process for creating notifications, both e-mail and SMS text message, based on a data event within BICS. The article will also demonstrate how these can be scheduled to run automatically. While written with a BICS audience in mind, it is...
Introduction Event Based notification functionality for Oracle's BI Cloud Service (BICS) will be available later this year, but until that time some of the same functionality can be created...
Introduction Oracle Service Cloud (henceforth referred to as OSvC) provides a complete customer service solution that offers cross-channel service delivery, web...
Introduction Oracle Service Cloud (henceforth referred to as OSvC) provides a complete customer service solution that offers cross-channel service delivery, web customer service, self-service, knowledge management, and a host of other features. Besides its functional capabilities, OSvC provides a robust, API based integration and extension framework. In this and a few upcoming blogs we’ll focus on the Integration Framework and explore the Connect Web Services (CWSS) APIs in...
Introduction Oracle Service Cloud (henceforth referred to as OSvC) provides a complete customer service solution that offers cross-channel service delivery, web customer service,...
Background This article describes how to integrate Oracle Fusion Applications – WebCenter / Universal Content Management (UCM) with Oracle Business...
Background 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 is to provide a fresh perspective on this subject,...
Background This article describes how to integrate Oracle Fusion Applications – WebCenter / Universal Content Management (UCM) with Oracle Business Intelligence Cloud Service (BICS). The integration...
Background This article outlines how to automate the loading of a JSON response into Oracle BI Cloud Service (BICS) via Oracle Application Express (Oracle...
Background 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 are as follows: 1) Read in the JSON response as a CLOB using the apex_web_service.make_rest_request function. 2) Convert the CLOB...
Background 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...
Background This article describes how to integrate Oracle Service Cloud (RightNow) with Business Intelligence Cloud Service (BICS), illustrating how to...
Background 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 to start an integration with Service Cloud. The reader would also need to consider other factors such as...
Background This article describes how to integrate Oracle Service Cloud (RightNow) with Business Intelligence Cloud Service (BICS), illustrating how to programmatically load Service Cloud (RightNow)...
Background This blog describes how to integrate Oracle Sales Cloud with Business Intelligence Cloud Service (BICS). The blog outlines how to programmatically...
Background 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 is retrieved via an Oracle Transaction Business Intelligence (OTBI) Answers / Analysis request created within Sales...
Background 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...
Introduction I recently had a colleague ask me for assistance on extracting particular pieces of data from an HTML CLOB stored in a database. The data...
Introduction I recently had a colleague ask me for assistance on extracting particular pieces of data from an HTML CLOB stored in a database. The data represents some of the content from one of our wiki sites and he was trying to generate a report on some of that data. We considered using dbms_lob functions (e.g. dbms_lob.instr and dbms_lob.substr) to search and extract for the data, but ran into string length limitations. The solution we ended up with was to basically treat...
Introduction I recently had a colleague ask me for assistance on extracting particular pieces of data from an HTML CLOB stored in a database. The data represents some of the content from one of...
Background As an Oracle Business Intelligence (BI) Developer, you may not always have direct access to the BI Common Semantic Model (RPD) or the underlining...
Background 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 analysis request level. This can be done from the Advanced tab of the analysis request. If your dashboard is not refreshing and you feel the...
Background 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...
