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:
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.
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:
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:
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:
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 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.)
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