Rittman Mead Blog - Hyperion Essbase

Financial Reports - which tool to use? Part 2

Financials in BI Publisher## I find it interesting that BI Publisher is mostly known for the creation of pixel perfect repeating forms (invoices, labels, checks, etc) and its ability to bursting them. To me, BI Publisher is the best kept secret for the most challenging reports known to mankind. In

OBIEE12c

Financial Reports - which tool to use? Part 1

One of the treats of working in the Business Intelligence world is that we are asked to analyze different aspects of a business. In fact, we are asked to analyze many different types of businesses, too. Most of us using BI tools have come from some previous background. Be it

Technical

ASO Slice Clears - How Many Members?

Essbase developers have had the ability to (comparatively) easily clear portions of our ASO cubes since version 11.1.1, getting away from fiddly methods involving manually contra-ing existing data via reports and rules files, making incremental loads substantially easier. Along with the official documentation in the TechRef and DBAG,

Technical

Oracle OpenWorld 2015 Roundup Part 3 : Oracle 12cR2 Database Sharding, Analytic Views and Essbase 12c

With the UKOUG conference starting tomorrow I thought it about time I finished off my three-part post-OOW 2015 blog series, with a final post on some interesting announcements around Oracle Database and Essbase. As a reminder the other two posts were on OBIEE12c and the new Data Visualisation Cloud Service,

Technical

Essbase Studio checkModelInSyncExternal Error

This week I am back at one of my favourite clients to assist with some issues since the latest upgrade to 11.1.1.9. These guys are seriously technical and know their stuff, so when issues pop up I'm always ready for an interesting and challenging day in the

Big Data

Rittman Mead at ODTUG KScope'15, Hollywood Florida

ODTUG KScope’15 is running in Hollywood, Florida next week and Rittman Mead are running a number of sessions during the week on OBIEE, Essbase, ODI and Big Data. I’ve personally been attending ODTUG KScope (or “Kaleidoscope”, as it used to be known) for many years now and it’

Technical

Take Part in the BI Survey 15, and Have Your Voice Heard!

Long-term readers of this blog will know that we’ve supported for many years the BI Survey, an independent survey of BI tools customers and implementors. Rittman Mead have no (financial or other) interest in the BI Survey or its organisers, but we like the way it gathers in detailed

Technical

Announcing the BI Forum 2015 Data Visualisation Challenge

The Rittman Mead BI Forum 2015 is running in Brighton from May 6th-8th 2015, and Atlanta from May 13th - 15th 2015. At this year’s events we’re introducing our first “data visualization challenge”, open to all attendees and with the dataset and scenario open from now until the

Oracle BI Suite EE

Rittman Mead BI Forum 2014 Call for Papers Now Open!

It’s that time of year again when we start planning out next year’s BI Forum, which like this year’s event will be running in May 2014 in Brighton and Atlanta. This will be our sixth annual event, and as with previous year’s the most important part

Oracle BI Suite EE

Rittman Mead / ODTUG India BI Masterclass Tour Roundup

Over the past week Venkat, myself and the Rittman Mead India team have been running a series of BI Masterclasses at locations in India, in conjunction with ODTUG, the Oracle Development Tools User Group. Starting off in Bangalore, then traveling to Hyderabad and Mumbai, we presented on topics ranging from

Oracle BI Suite EE

Oracle Openworld 2013 Day 2: Exalytics, TimesTen and Essbase Futures

Monday's almost over at Oracle Openworld 2013 in San Francisco, and it started for me today with a presentation on Enterprise Manager 12c and the BI Management Pack, alongside Henrik Blixt (PM for the BI Management Pack) and Dhananjay Papde, author of a book on EM12c. I've covered EM12c and

Hyperion Essbase

Installing Essbase Analytics Link for HFM 11.1.2.3

If your requirement is to install EAL for HFM, then this post is for you. Oracle has not yet released a new version of EAL that is certified with HFM 11.1.2.3 and hence you will not be able to find one in the edelivery. The question is

Oracle BI Suite EE

New Feature in OEM Cloud Control 12cR3 - Exalytics Server Management

A few months ago a wrote a series of posts about the new 12cR2 release of Oracle Enterprise Manager Cloud Control, which re-instated the BI Management Pack used for monitoring OBIEE 11g systems. Since then, the 12cR3 update for Cloud Control has been released, and one of the new features

Oracle BI Suite EE

OBIEE 11.1.1.7 + Essbase : Essbase Filters within Fusion Middleware 11g Security

Data and metadata filters are used with Essbase to limit access to data in a cube. When you use data filters to restrict access to a certain set of dimension members in the cube, the end-user can see that the member exists, but can't see any data associated with it.

Oracle BI Suite EE

Conclusions on Storing Detail-Level Data in Oracle Exalytics

Last week I wrote a blog post on the topic of storing lots of detail-level data in Oracle Exalytics, not the primary use-case for the product but something we're increasingly asked about. Most implementations of Exalytics use OBIEE's Summary Advisor to recommend aggregations against large, data warehouse data sets with

Oracle BI Suite EE

Optimizing TimesTen for Exalytics Queries using TimesTen's Index Advisor

Late last week I posted an article on our blog on loading detail-level data into Exalytics; whilst the article was intended really as an introduction to Essbase Aggregate Storage Option, and how it could offer an alternative to TimesTen when storing large amounts of detail-level data, to make the case

Oracle BI Suite EE

Storing Detail-Level Data in Oracle Exalytics

Although the primary use-case for TimesTen within Oracle Exalytics is to store relatively-small aggregate tables created using the Summary Advisor, many customers have asked us whether it's possible to store their entire reporting dataset in TimesTen. With 1TB of RAM in the original version of the Exalytics hardware, and now

Oracle BI Suite EE

New With OBIEE 11.1.1.7 and SampleApp v305 - Essbase Cube Spin-Off

Now that the new v305 OBIEE SampleApp that we previewed in May is out, I thought it'd be a good time to take a look at an experimental feature added into OBIEE 11.1.1.7's logical SQL that gives you the ability to create, or "spin-off", an entire Essbase

Oracle BI Suite EE

An Oracle BI "Blast from the Past": Ten Products from Oracle's BI History You May Not Have Heard Of...

With Oracle BI Enterprise Edition, the BI Apps and Hyperion EPM Suite, Oracle have a set of reporting and analysis tools that can be considered "best of breed" and compete with any other tool on the market. Coupled with the Oracle database, the engineered systems strategy and the Fusion Apps/

Oracle BI Suite EE

SmartView as the Replacement for BI Office with OBIEE 11.1.1.7

Apart from system-wide improvements to Essbase integration across OBIEE 11.1.1.7, the other Essbase-related improvement that came with this latest release was the (re-)introduction of SmartView as the replacement for Oracle BI Add-in for Microsoft Office ("BI Office"), OBIEE's previous MS Office solution. As a reminder, BI

Oracle BI Suite EE

Essbase and EPM Integration Improvements in OBIEE 11.1.1.7

One of the major new feature areas in OBIEE 11.1.1.7, but which has so far got very little attention, is the significant improvement in integration between Essbase, the Hyperion EPM Suite, and OBIEE 11g. The integration between EPM Workspace and OBIEE's Presentation Services which disappeared when 11g

Technical

Can Endeca Provide an Alternative to OBIEE for Fast, Complex Ad-hoc Analysis?

Towards the end of last week I was pulling together an article for Oracle Magazine on Oracle Endeca Information Discovery, and how it can now use OBIEE's BI Server and repository as an additional data source. I won't go into the details of that connectivity now as it'll be covered

Technical

Improvements to Essbase Integration in OBIEE 11.1.1.6.2 BP1 : ASO Aggregate Persistence, Combined Install & Systems Management

The recent 11.1.1.6.2 BP1 patchset for OBIEE 11g provided a bunch of new features including trellis charts, Oracle BI Mobile and the repository Model Checker, but it also sneaked in another set of new features that will be of particular interest to Essbase users: closer integration

Oracle BI Suite EE

Hyperion Profitability & Cost Management - Overview

Recently i have been doing lot more work on the Oracle EPM stack than on the Oracle BI stack. So, i will be writing more on the various Oracle EPM products like HFM, Planning, FDQM etc in the forthcoming weeks. To sort of kick start the series of postings, i

Oracle BI Suite EE

OBIEE Calculations, MDX Functions, Flattened Measures, and Essbase Sources

When you starting working with Essbase sources and OBIEE, how you create calculations quickly becomes one of the more interesting aspects of working with the two technologies. With Essbase, you've got a powerful multi-dimensional database that features many functions and calculation capabilities that you'd like to use with your analyses