The latest upgrade for BICS happened last week and, while there are no new end user features, it is now easier to integrate data. New to this version is the ability to connect to JDBC data sources through the Data Sync tool. This allows customers to set up automated data pulls from Salesforce, Redshift, and Hive among others. In addition to these connections, Oracle RightNow CRM customers have the ability to pull directly from RightNow reports using Oracle Data Sync. Finally, connections to on premise databases and BICS can be secured using Secure Socket Layer (SSL) certifications.
BI, BI Reporting, Data Visualization, Edgewater Ranzal, edgw, Enterprise Performance Management, EPM, EPMA, Hyperion, hyperion experts, OBI, OBI Publisher, OBIEE, Oracle, Oracle Business Intelligence Enterprise Edition, Oracle EPM, Oracle Hyperion, ranzal, Uncategorized, Visual Analyzer
Ranzal was recently invited to participate in a number of chalk talks for the Healthcare Industry User Group (HIUG) in San Antonio, TX. One of these chalk talks covered how an organization should prepare for and execute an upgrade to Oracle Business Intelligence (OBI) 12c. Since the technical steps are already covered in numerous blog posts as well as Oracle documentation, our conversation focused on a strategic approach to the upgrade. Our conversation essentially came down to four topics:
Data Relationship Management, DRM, Edgewater Ranzal, Enterprise Performance Management, EPM, Hyperion, hyperion experts, OBI, Oracle, Oracle Business Intelligence Enterprise Edition, Oracle EPM, Oracle Hyperion, ranzal
More and more Oracle customers are finding value in federating their EPM cubes with existing relational data stores such as data marts and data warehouses (for brevity, data warehouse will refer to all relational data stores). This post explains the concept of federation, explores the consequences of allowing hierarchical structures to get out of synchronization, and shares options to enable this synchronization.
As mentioned in the previous post, Dynamic Report Grouping with Oracle BI Publisher, Edgewater Ranzal is working with a client to convert XML Publisher reports to BI Publisher reports. As part of Ranzal’s initiative, we began looking for opportunities to improve the user interface as well as create a standard methodology that report developers could utilize in the future. One of the initial areas we focused on was to improve the prompting feature. To this effort, we concentrated on:
Edgewater Ranzal is working with a client to convert XML Publisher and nVision reports to BI Publisher as part of a larger initiative to consolidate reporting under the Oracle Business Intelligence solution. The client currently does not use the BI Publisher Layout Editor, but rather relies on RTF templates to display results to the user. One nVision report in particular presented a challenge because of the grouping requirements.
BI Reporting, EPM, Essbase, Multi-Dimensional, OBI Answers, OBI Interactive Dashboards, OBI Publisher, OBIEE, Oracle 11g, Oracle BI Administration Tool, Oracle Business Intelligence Enterprise Edition, Oracle Hyperion, Planning & Essbase, Relational, Smart View, Smartview
Oracle has been busy focusing on improved consolidation of their BI applications this past year. This next offering within Oracle's arsenal of BI apps will allow for enhanced integrations between the multi-dimensional and relational worlds of Essbase and OBIEE. The new application is called Oracle Business Intelligence Essbase Cube Builder (OECB) previously referenced as Oracle Essbase Integrator (OEI) during beta testing and its purpose will help refine and make for more consistent binary integrations. OECB will permit OBI apps to push metadata and data into Essbase cubes, a significant advancement for OBIEE users where leveraging in-depth ad hoc and what-if scenarios can be available. You can download OECB on the Oracle e-delivery site:
1, BI Reporting, OBI Answers, OBI Interactive Dashboards, OBI Publisher, OBIEE, Oracle 10g, Oracle BI Administration Tool, Oracle Business Intelligence Enterprise Edition, Oracle Hyperion, Oracle Repository, Planning & Essbase, SQL Server