Don’t Fear the Statistics – Using OBI for Statistical Analysis Part 2

Edgewater Ranzal, EPM, Hyperion, OBI, OBIEE, Oracle, Oracle EPM, Oracle Hyperion, Uncategorized

Nearly every client Edgewater Ranzal partners with uses statistical averages in their analytic and reporting solutions. As far as statistical functions go, it is probably the easiest to understand, however; the limitation of using the average is that it can be difficult to determine how to rate the individual performance of contributors to that average.  Consider the following examples:

Don’t Fear the Statistics – Using OBI for Statistical Analysis Part 1

EPM, Hyperion, OBI, OBI Answers, OBIEE, Oracle, Oracle Hyperion, Uncategorized

Recently, Ranzal has been working with a client in the healthcare space implementing Oracle Business Intelligence (OBI), and a requirement surfaced to translate a scorecard report into an OBI dashboard. One of the data elements was simply captioned “Trend” and colored red, yellow, and green.  It was discovered that this Trend was the slope of a linear regression plot (more on what that means in a moment) and the color was based on an arbitrarily chosen number.  This immediately raised some concerns from the Ranzal team who then made some suggestions for more pertinent statistical analysis.

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:

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:

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:

BI for the BlackBerry Crowd

BI Reporting, EPM, OBIEE

During the recent COLLABORATE 2009 Conference, Ranzal was selected to present a session designed around showing how to use the reporting tools from either traditional Hyperion or Oracle (formerly Siebel Analytics) and deliver content to smart phones.  The session started off with an overview of smart phones, methods of delivery to those phones and some potential pitfalls and considerations, such as what if a user loses their phone? What kind of security policies need to be in place?  Then a couple quick demonstrations in Hyperion were given which included a few tips and tricks on formatting.  This was all done using Interactive Reporting and Workspace.  Lastly, a couple quick demos in OBIEE Answers were provided to the attendees.

Business Intelligence Technology Environment – Welcome to the Buffet

1, BI, BI Reporting, EPM, Essbase, FDM, Fusion, HFM, OBIE, OBIEE, ODI, Oracle, Oracle DRM, Oracle Hyperion, Planning & Essbase, Shared Services, System 11

Business Intelligence Technology Environment or BITE is my own little tag line and acronym (maybe I should copyright it) to express the host of solutions available in the Business Intelligence application world today. (It could also be used as a verb to describe the plethora of poorly designed solutions… ahh but that is another story.)

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)

OBIEE and Essbase - Defining OLAP Integration

Administration Tool, Answers, BI Reporting, Business Model & Mapping Layer, Dashboard, EAS, Essbase, OBIEE, OLAP, Oracle Hyperion, Physical Layer, Presentation Layer, Subject Areas

In this second part of our OBIEE series, the integration between OBIEE and Essbase is a seamless transition from our OLAP cube to the OBIEE suite managed by using OBIEE’s Administration Tool.

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