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...
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...
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 be used to locate, debug, source, and information on re-creating patch errors. Since there is a wide range of RPD errors, with varying levels of difficulty...
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...
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...
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 Consumer role can view and run any analyses, dashboards, and agents directly though the Catalog UI....
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)....
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...
Introduction In a standalone OBIEE environment, or within the Analytics Reporting home page of Fusion Applications, there may be occasions where it would be...
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 to make sure logging is turned on for the user that will be running the report. Using the BI Administration tool, open the RPD repository...
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...
