Implementing Data Level Security in Oracle Analytics Cloud using Identity Cloud Service

Introduction This post describes implementing Data Level Security in Oracle Analytics Cloud (OAC) using Identity Cloud (IDCS) groups. It focuses on what steps are needed. Links to relevant documentation are provided for details on how to perform the steps. One case for using IDCS satisfies a corporate requirement specifying that the assigning of users to […]

Connecting Oracle Analytics Cloud Version 5.x to the Autonomous Data Warehouse

Last Validation: April 2, 2019 for OAC Client version 105.2, OAC 105.2.0-307 and ADW 18.4.0.0 Introduction This post details the steps required in OAC version 5 (18.3+) to upload Autonomous Data Warehouse (ADW) wallets and to create ADW data, replication and console connections. The wallets are used for Data Visualization (DV) data sets, DV Replications, […]

Connecting Oracle Analytics Cloud Version 4 to the Autonomous Data Warehouse

Introduction This post details the steps required in OAC version 4 (versions 18.2.x and less) to upload an Autonomous Data Warehouse (ADW) wallet and create data and console connections in Oracle Autonomous Analytics (OAAC) or Oracle Analytics Cloud (OAC). The wallet is used for Data Visualization (DV) data sets, Metadata (RPD) connection pools, and Thin Client […]

Connecting an Oracle Analytics Cloud RPD to the Autonomous Data Warehouse Cloud

Deprecation Recent enhancements to OAC have made this post obsolete.  The latest OAC4 post is Here. The OAC5 post is Connecting Oracle Analytics Cloud Version 5 to the Autonomous Data Warehouse Introduction This post details the steps required to prepare an OAC instance for an RPD with an Autonomous Data Warehouse Cloud (ADWC) data source connection. It uses the […]

Creating an Oracle Analytics Cloud RPD Connection to the Autonomous Data Warehouse

Last Validation: April 2, 2019 for OAC Client version 105.2, OAC 105.2.0-307 and ADW 18.4.0.0 Introduction This post details the steps required to create an Autonomous Data Warehouse (ADW) data source connection using the Oracle Analytics Cloud (OAC) Developer Client Tool on Windows. It also prepares a complete RPD ready for uploading to both Autonomous […]

How to Recover the RPD Repository Password in Fusion Applications or OBIEE

Introduction The RPD Repository file contains the metadata to create reports.  This includes details of the physical data sources and connections, the business model mapping with joins, and the presentation layer that is presented to report writers.  The RPD file is encrypted with the Repository Password.  Without that password – the BI Administration tool can […]

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 […]

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 […]