Rittman Mead Blog - Hyperion

Tagged

Hyperion

A collection of 67 posts

Oracle EPM 11.1.1.3 & Oracle OLAP 11g – Reporting on Oracle OLAP using Essbase Excel Add-in/Smartview - XOLAP

This is the week of Colloborate 2010 [http://www.collaborate10.org/] conference. Mark, myself, Pete and Stewart were scheduled to present this year but due to the European Airspace closure, myself and Pete haven’t been able to actually travel this year. Its a real shame as we all really

Oracle EPM 11.1.1.3 - Deploying EPM reporting Portlets in Weblogic Portal 10g

There are multiple ways of integrating reporting tools(oracle or non-oracle) to external portals. The most commonly used ones are the URL based integration, Web Service calls and calling native portlets directly from the portals. I have covered the details of the techniques some time back here [http://oraclebizint.wordpress.

Oracle EPM 11.1.1.3 - Life Cycle Management - Part1 - Essbase Migration

One of the major issues that i commonly encountered while doing 9.3 based essbase implementations was the fact that there was no built in utility within the Hyperion stack that could migrate various applications from a Development to a Test/Production machine(not essbase alone but also other related

Oracle EPM 11.1.1.3 - Customizing EPM Workspace

A common requirement that always comes up as part of an Organization wide EPM rollout, is in customizing the look and feel of the products to match the company logo, style etc. In the case of BI EE, the customization is quite straight forward, as BI EE segregates the look

Oracle EPM 11.1.1.3 - Installing Hyperion Components on Multiple Machines

In any EPM deployment, rarely do all the components get installed on a single machine. In majority of the cases, you will see that each component is actually installed on separate machines with their own application and web servers. So, how does this all work and how do we go

Oracle EPM 11.1.1.3 – Essbase Clustering for High Availability

Its been almost a couple of weeks since i last blogged due to a flurry of events like Open-World, Training Days, Client Engagements etc. Getting the materials completed took most of my time and since then i haven't had a chance to blog. But now that the busiest

Early News on the Oracle BI Apps - Essbase Integrator

I was recently going through the recorded Open World sessions using Oracle Open World on Demand [http://openworld.vportal.net/], and came across an interesting session by Alaric Thomas and Mike Nader on the forthcoming Oracle BI Applications to Essbase Integrator. This is a technology project going on within Oracle

Oracle EPM 11.1.1.3 – Hyperion Shared Services integration with external Applications – Java API – Part 1 - Introduction

One of the major enhancements that came in the Hyperion EPM 11 release is the availability of Java APIs to access shared services from external applications. In the prior releases, SDK’s were available but those have been enhanced completely now in this release to accommodate new features. Also with

A Quik Look at QlikView

Outside the world of Oracle, one of the rising stars of the BI world has been Qliktech, the Swedish software company behind QlikView [http://www.qlikview.com/]. QlikView is one of a new breed of desktop, in-memory BI tools [http://www.olapreport.com/Comment_InMemBI.htm] (see also the forthcoming

Announcing Rittman Mead Training Days 2009, London

I'm very pleased to announce details of our second-ever Training Days [http://www.rittmanmead.com/trainingdays2009] event, to be held at the Bloomsbury Hotel [http://www.doylecollection.com/locations/london_city_hotels/the_bloomsbury_hotel.aspx] in London on October 27th - 29th 2009. This year I'

Hyperion Planning 11.1.1.2 – New Smart view OracleSV protocol – Integration into smart view and other desktop applications – Part 1

In the last few blog entries, i have been covering some of the new features of the EPM 11 release. Continuing on the same line, lets look at another new feature that was introduced for integrating smart view with Hyperion Planning. The most common way of integrating multiple web based

Hyperion Essbase 11.1.1.2 – XOLAP – MDX to SQL Conversion – Part 1

One of the interesting aspects of XOLAP is the fact that it exposes Essbase as a dynamic relational aggregation engine. XOLAP to an extent is pretty good in determining what kind of sql should be pushed back to the relational sources and what requires custom in-memory calculations. For example, lets

Hyperion Essbase 11.1.1.2 – Varying Attributes

Another excellent feature that was introduced as part of the EPM 11 release was the support for varying attributes. Varying attributes help in providing different perspectives of multiple attributes of a dimension over time. One can visualize this as SCD 2 in a relational world. For example, lets take the

Hyperion Essbase 11.1.1.2 – Altering Measure Formats – Format Strings and Text Measures

If you had read my blog entry here [http://oraclebizint.wordpress.com/2008/12/10/hyperion-essbase-1111-handling-textual-facts-text-list-manager-and-text-measures/] , i would have shown how to go about creating textual measures in Essbase. Though that was a new feature introduced as part of the EPM 11 release, one related feature that i did not

Oracle BI EE – Bulk Write backs to Essbase – Using JAPI, Global Temporary Tables and UTL_HTTP – Part 2

I had covered an approach here [http://oraclebizint.wordpress.com/2009/05/25/oracle-bi-ee-10-1-3-4-1-writebacks-to-essbase-using-japi-and-custom-html-part-1/] to do write backs into Essbase from BI EE. In some cases that approach would be sufficient. But in most of the cases, end users would want the capability to do a bulk write back similar

Fun and Games with OBIEE Connection Pools and Essbase Logins

When you bring in an Essbase database into the Oracle BI EE 10.1.3.4 and higher semantic model, you typically import it using the "admin" Essbase user ID. This is a standard account that comes with the default installation of Essbase and provides full access to

What Skills Does an Oracle BI Developer Need in 2009?

One of the publications that I write for is the ODTUG Technical Journal, where I contribute a regular "business intelligence" column. ODTUG is aimed at technical developers and consultants, and so I was having a think about how the product skills required by such people have changed over

Using Essbase as an Aggregation Layer for Federated OBIEE Models

Now that the 11.1 release of Essbase is out [https://www.rittmanmead.com/blog/2008/07/15/oracle-epm-aka-hyperion-system-95-now-available-for-download/] , together with Essbase Studio, an option that's now open to us is to use Essbase as an aggregation layer for OBIEE. You can build a single logical dimensional model

Essbase Multi-Dimensional OLAP Analysis using OBIEE Plus and Oracle Financial Reporting

I've been working with a few customers recently who are implementing OBIEE along with Essbase. Typically they are long-standing users of Essbase, and bought OBIEE because it could integrate both their multi-dimensional Essbase data and the relational data in their data warehouse. What they were finding though was

EPM Workspace 11.1 and OBIEE 10.1.3.4 (Updated)

Something I've been trying to get working for several weeks now, is proper integration between EPM Workspace 11.1 and the various OBIEE tools. I posted an article a few weeks ago asking whether anyone else had got it working [https://www.rittmanmead.com/blog/2008/12/15/

Ten Thoughts on Oracle BI&DW for 2008

Today is New Year's Eve, and a kind of review of the year, here's ten of my thoughts on what happened in Oracle B&DW in 2008. 1. Oracle Business Intelligence Enterprise Edition. 2008 was the year that OBIEE went from early-adopter technology (at least

Adding Essbase Measures to Relational OBIEE Models

I'm running an especially extended version of our OBIEE developer course in early January, and the client in question wants us to include a bit more content on Essbase integration. Whilst bringing Essbase cubes into OBIEE and then reporting on them in their own subject area is good,

OBIEE and Essbase Articles in OTN 2008 Top 10

Well there's a surprise. Justin Kestyln in his Best of 2008 : The Most Popular Tech Articles and How-To's Published This Year article [http://blogs.oracle.com/otn/2008/12/best_of_2008_the_most_popular.html] has two of my articles in the top 10. Apart

Has Anyone Got EPM 11.1.1 Workspace and OBIEE Working Completely?

The other week I blogged about the integration between EPM Workspace 11.1.1.1 and OBIEE 10.1.3.4 [https://www.rittmanmead.com/blog/2008/12/09/epm-workspace-1111-integration-with-obiee-10134/], and I said at the time that firstly, I couldn't get single sign-on working between the two application

EPM Workspace 11.1.1 Integration with OBIEE 10.1.3.4

Something I've been working on in my spare time recently, is getting integration with EPM Workspace 11.1.x working with OBIEE. The basic idea here is that EPM Workspace can act as a "container" for both your Hyperion and OBIEE tools, so that users can