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...
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...
Introduction SOA Suite for Healthcare Integration pack comes with a pre-installed simulator that can be used as an external endpoint to generate inbound and...
Introduction SOA Suite for Healthcare Integration pack comes with a pre-installed simulator that can be used as an external endpoint to generate inbound and outbound HL7 traffic on specified MLLP ports. This is a command-line utility that can be very handy when trying to build a complete end-to-end demo within a standalone, closed environment. The ant-based utility accepts the name of a configuration file as the command-line input argument. The format of this configuration...
Introduction SOA Suite for Healthcare Integration pack comes with a pre-installed simulator that can be used as an external endpoint to generate inbound and outbound HL7 traffic on specified MLLP...
