The True Power of Oracle’s Enterprise Planning Suite Unleashed at POET: A Case Study

Cloud, Oracle Business Intelligence Enterprise Edition, Oracle Hyperion, Oracle Cloud, Enterprise Planning & Budgeting Cloud Service

 

“If you are going to change the world, you need a system to help get you there. For us, it was… about strategic opportunities. POET was at a crossroads. We needed a system that we could grow with and that could grow with us.”
Lezlee Herdina, Director of FP&A, POET

Oracle Business Intelligence Cloud Service (BICS) September Update

BI Reporting, BICS, Business Intelligence, Edgewater Ranzal, Hyperion, hyperion experts, Oracle, Oracle Business Intelligence Enterprise Edition, Oracle Hyperion, Performance Tools, ranzal

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.

A Comparison of Oracle Business Intelligence, Data Visualization, and Visual Analyzer

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

Upgrading Oracle Business Intelligence to 12c

Edgewater Ranzal, Healthcare, Hyperion, OBI, OBIEE, Oracle, Oracle Business Intelligence Enterprise Edition, ranzal, Uncategorized

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:

Oracle Business Intelligence – Synchronizing Hierarchical Structures to Enable Federation

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.

Default and User Friendly Prompting With BI Publisher

BI Reporting, Hyperion, OBI Publisher, OBIEE, Oracle BI Publisher, Oracle Business Intelligence Enterprise Edition, oracle essbase, Oracle Hyperion

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:

Dynamic Report Grouping With Oracle BI Publisher

BI Reporting, Essbase and BI, Oracle BI, Oracle BI Publisher, Oracle Business Intelligence Enterprise Edition

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.

Oracle Business Intelligence Essbase Cube Builder: Continued Integrations with Essbase and OBIEE

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:

Creating an OBIEE Repository for Relational Data Source

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

OBIEE (Oracle Business Intelligence Enterprise Edition)

About Edgewater Ranzal

Edgewater Ranzal is an integrated Business Analytics solution provider deeply rooted in Enterprise Performance Management (EPM). Coupled with our Business Intelligence (BI) and Big Data (BD) expertise, we provide holistic solutions that help organizations define, measure, and innovate their business, provide a clear vision, and drive business value.

Subscribe to Email Updates

Recent Posts

Posts by Topic

see all