An Essbase OBIEE integration walk through with tips and tricks

Best Practices or Tips & Tricks?

It’s probably best practices for myself but tips and tricks for you.

During the past few months, I have been going through theories and logics of KPIs, Dashboards and Strategy management. There are still a lot to go through but I’ve decided to go technical again for those who are missing out on Essbase & OBIEE. I’ve been doing Essbase and OBIEE integration since 2009, accumulated more than 30 Essbase OBIEE projects and there are lots of improvements on the tools since then. Unfortunately, Hyperion experts usually don’t like OBIEE and vice versa. I know that feeling since I came from the Hyperion side and always was an Essbase fan, that was back in 2004. The integration is actually not as difficult as it seems nowadays. You just need some tips and tricks for Essbase OBIEE integration.

Continue reading “An Essbase OBIEE integration walk through with tips and tricks”

Advertisements

Essbase ASO Outline Grows Too Big – Solution to Fragmentation Using Compact

Compacting ASO Outline – Defragmenting

Why does it grow?

In BSO, defragmenting the cube is actually quite simple. One way is to do a full restructure and the other way is to export, clear all blocks then re-import the data. So you think ASO doesn’t need to defrag since it doesn’t contain any blocks? Too bad, you’re very wrong. ASO fragmentation happens when you add/delete/regroup members or delete/add dimensions. So to make it simple, any meta-data changes will cause fragmentation. In fact, even if you use EPMA or work direct from EAS or Essbase Studio and EVEN OBIEE AGGREGATE PERSISTENCE WIZARD, it will still cause fragmentation.

So how much would it grow?

To be honest, I do not have the algorithms on this. But if you update the cube on a daily basis, I should think it will double the size in a few months time.

What happens if I don’t do anything?

If you don’t do anything to it, and when .otl file grows to over 2gb in size, EAS won’t be able to open the outline. Would users still be able to access it? Yes they would. It’ll still work but it doesn’t really feel safe does it?

What are the solutions?

There are 3 ways to compact the outline which in the end is basically defragmenting the outline, each with pros and cons. They are explained as follows:

Continue reading “Essbase ASO Outline Grows Too Big – Solution to Fragmentation Using Compact”

OBIEE and Essbase in BI Survey

There as a recent post saying that OBIEE is poorly ranked for Enterprise Reporting. Yes, it probably might not be the best. However, if BI Foundation Suite is purchased, then it really depends on the vendor if they implement correctly. Dashboard is a dashboard which is good for interactive reporting, data analysis, drilling. It isn’t the best idea for enterprise reporting though.

Let’s take a look at BI Survey and what they have for BIFS.

Continue reading “OBIEE and Essbase in BI Survey”

Creating Text Entry in Essbase – SmartList

Essbase Text Entry – SmartList

You might all have known that Essbase does not store text. Yes, in a sense it doesn’t but it stores SmartList. In a way, smartlist are numbers that are tied with text. Payment terms maybe a good example to demonstrate this.

First, in your BSO / ASO outline, open up the Properties tab like below and ensure Typed Measures enabled is true (which is not by default). Then you will have a Text List Manager tab.

1_SmartList

Continue reading “Creating Text Entry in Essbase – SmartList”

EAL – Essbase Analytics Link for HFM Installation

EAL Installation

Oracle Essbase Analytics Link for Hyperion Financial Management provides a seamless integration between Hyperion Financial Management applications and Business Intelligence tools. Analytics Links enables the ability to effortlessly expose HFM from within an Essbase database and use the Essbase analytical features on top of live HFM data.

Important Note: Prior to installing this product, you must download and install Oracle Universal Installer. Please refer to the Oracle Essbase or Oracle Hyperion Financial Management, Fusion Edition links for downloading these products.

*Keep in mind that this installation cannot be rolled back.

Continue reading “EAL – Essbase Analytics Link for HFM Installation”