Recent Posts by Jay Pearson

 Background * This blog was last tested on OAC 5.9 + ADW 19c + ATP 19c * This article walks through the steps to configure an Oracle Analytics Cloud (OAC) BI Repository (RPD) file to connect to both an Autonomous Data Warehouse (ADW) and an Oracle Autonomous Transaction Processing (ATP) database in the same region. These steps can be applied to connect to any other Oracle Autonomous Database (ADB) - as long as it is in the same region. This blog mostly pertains to those using an...

The A-Team Chronicles blog post you were trying to access has expired. The reason for the expiration is that the content is no longer relevant or the Oracle on-line documentation has been updated to reflect the content of the blog. Regards, A-Team Chronicles Administration

* This blog was last tested on OAC Version 5.9 + ADW 18c *   Background This article walks through the steps to invoke Oracle REST Data Services (ORDS) in Oracle Analytics Cloud (OAC) Data Visualization (DV). Possible Use Cases: * Write-back * Running DML statements (insert, update or delete etc.) * Passing pre-process dynamic parameters to selects statements or stored procedures * Passing parameters to a web service Functionality Covered: * DV Data Actions * Apex ORDS RESTful Services *...

 Background * This blog was last tested on OAC 105.8.0-133 (Version 5.8) + ADW 18c + Oracle Analytics Client Tools 5.8.0 [aka Oracle BI Administration Tool Version 12.2.5.8.0]  + SQuirreL SQL Client Version 4.1.0 + Windows 10 Pro 64-bit OS *  This article walks through the steps to query an Oracle Analytics Cloud (OAC) and Oracle Fusion Analytics Warehouse (FAW) data model with SQuirreL (an open-source Java SQL Client). The blog demonstrates both Resource Owner and JSON Web...

 Background This blog assumes some basic knowledge of Oracle Analytics Cloud (OAC) - BI Publisher (BIP), Oracle Analytics Publisher (BIP) Desktop, and RTF Templates. For those who have never used BIP before, the Create Pixel Perfect Reports using Analytics Cloud class is a good place to start. BIP Desktop can be downloaded from here. The BIP Desktop bit version must match the MS Office bit version (which is not necessarily the same as the Operating System bit). This blog was...

 Background * This blog was last tested on OAC 105.8.0-133 (Version 5.8) + ADW 18c * ~ This blog explains how to reference relational data sources using a Pipelined Table Function. See this blog for instructions on how to reference SOAP/REST API's sources using a pipelined table function. ~ This article walks through the steps to use Pipelined Table Functions in Answers (Analysis) Dashboards. Pipelined table functions provide the ability to create a dynamic table view of the...

 Background * This blog was last tested on OAC 105.8.0-133 (Version 5.9) + ADW 18c * Click here for recommended prerequisite reading on OAC Usage Tracking. Usage Tracking is a powerful feature that has been available in Oracle Business Intelligence (OBI) since its early inception. It was first made available in Oracle Analytics Cloud (OAC) in Release 105.2 - March 2019. This article walks through the steps to configure OAC Usage Tracking with an Autonomous Data Warehouse (ADW). No...

 Background * This blog was last tested on OAC 105.8.0-133 (Version 5.8) + ADW 18c + Oracle Analytics Client Tools 5.8.0 [aka Oracle BI Administration Tool Version 12.2.5.8.0]  + Instant Client for Microsoft Windows (x64) - Version 19.8.0.0.0 - Basic Package *  This article walks through the steps to configure the Developer Client Tool for Oracle Analytics Cloud (OAC) in a proxy-enabled network. The blog demonstrates how to perform the following in a proxy-enabled network: * Open...

 Background * This blog was last tested on OAC 105.8.0-133 (Version 5.8) + ADW 18c * *** This blog is not applicable for BIApps OAC customers. BIApps customers should follow this MOS "Doc ID 2663180.1: OBIA 11g:Setting User Preferred Currency Options in BIApps". The BIApps doc can be found by logging onto My Oracle Support. Additional documentation on BIApps currency settings can be found here. *** This article walks through the steps to configure non-BI Apps Oracle Analytics...