Background * This blog was last tested on Oracle Service Cloud 20B (Build 266) + ADW 18c + CXDev Toolbox 19.10.4.0 * This article describes how to integrate...
Background * This blog was last tested on Oracle Service Cloud 20B (Build 266) + ADW 18c + CXDev Toolbox 19.10.4.0 * This article describes how to integrate Oracle Service Cloud (RightNow) with PL/SQL, illustrating how to programmatically load Service Cloud data into Oracle Autonomous Data Warehouse (ADW), making it readily available to model and display in Oracle Analytics Cloud (OAC). PLEASE NOTE - this article is intended to provide the reader with some ideas of how to...
Background * This blog was last tested on Oracle Service Cloud 20B (Build 266) + ADW 18c + CXDev Toolbox 19.10.4.0 * This article describes how to integrate Oracle Service Cloud (RightNow) with...
Background This blog was written in 2015 for Oracle BI Cloud Service (BICS) + Oracle Application Express (Oracle Apex). Since Oracle Analytics Cloud (OAC) now...
Background This blog was written in 2015 for Oracle BI Cloud Service (BICS) + Oracle Application Express (Oracle Apex). Since Oracle Analytics Cloud (OAC) now supports direct connectivity to Oracle Fusion Sales Cloud, the BICS component of this blog has been removed and has not been converted to OAC. This is not a recommended method to integrate Fusion and Oracle Analytics Cloud (OAC). This blog has been left active to illustrate how PL/SQL may be used to integrate Oracle...
Background This blog was written in 2015 for Oracle BI Cloud Service (BICS) + Oracle Application Express (Oracle Apex). Since Oracle Analytics Cloud (OAC) now supports direct connectivity to Oracle...
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...
* This blog was last tested on OAC 105.8.0-133 (Version 5.8) + ADW 18c * Background As an Oracle Analytics Cloud (OAC) developer, you may not always have...
* This blog was last tested on OAC 105.8.0-133 (Version 5.8) + ADW 18c * Background As an Oracle Analytics Cloud (OAC) developer, you may not always have direct access to the BI Common Semantic Model (RPD) or other config files. 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...
* This blog was last tested on OAC 105.8.0-133 (Version 5.8) + ADW 18c * Background As an Oracle Analytics Cloud (OAC) developer, you may not always have direct access to the BI Common Semantic Model...
* This blog was last tested on OBIA 11.1.1.8.1 * Click here for OBIA: Oracle Business Intelligence Applications Statement of Direction (Doc ID 2515201.1). ...
* This blog was last tested on OBIA 11.1.1.8.1 * Click here for OBIA: Oracle Business Intelligence Applications Statement of Direction (Doc ID 2515201.1). Background 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 can...
* This blog was last tested on OBIA 11.1.1.8.1 * Click here for OBIA: Oracle Business Intelligence Applications Statement of Direction (Doc ID 2515201.1). Background At times a BI patch may fail with...
Background * This blog was last tested on OAC 105.8.0-133 (Version 5.8) + ADW 18c * This blog was written for Oracle Analytics Cloud (OAC). These steps...
Background * This blog was last tested on OAC 105.8.0-133 (Version 5.8) + ADW 18c * This blog was written for Oracle Analytics Cloud (OAC). These steps are also applicable to previous OBI releases such as Oracle Business Intelligence Cloud Service (BICS) and Oracle Business Intelligence Enterprise Edition (OBIEE). By default all users with the BI Consumer role can view and run any analyses, dashboards, and agents directly though the Catalog UI. This article discusses...
Background * This blog was last tested on OAC 105.8.0-133 (Version 5.8) + ADW 18c * This blog was written for Oracle Analytics Cloud (OAC). These steps are also applicable to previous OBI releases...
Introduction Oracle Business Intelligence (OBIEE) platform is a development framework, where multi-users can create and work on a common object model and store...
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 Reports. It has an in-built source control mechanism, but until recently, it could not be integrated...
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...
* This blog was last tested on OAC 105.8.0-133 (Version 5.8) by Jay Pearson (Oracle A-Team) * Introduction In Oracle Analytics Cloud (OAC) and Fusion Oracle...
* This blog was last tested on OAC 105.8.0-133 (Version 5.8) by Jay Pearson (Oracle A-Team) * Introduction In Oracle Analytics Cloud (OAC) and Fusion Oracle Transitional Business Intelligence (OTBI) 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 to make sure logging is turned on for the user that will...
* This blog was last tested on OAC 105.8.0-133 (Version 5.8) by Jay Pearson (Oracle A-Team) * Introduction In Oracle Analytics Cloud (OAC) and Fusion Oracle Transitional Business Intelligence (OTBI)...
Introduction Oracle Fusion Applications have a built in Business Intelligence framework based on Oracle Business Intelligence Enterprise Edition (OBIEE). With...
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 of them play significant roles in...
Introduction Oracle Fusion Applications have a built in Business Intelligence framework based on Oracle Business Intelligence Enterprise Edition (OBIEE). With this framework, organizations...
