Creating a Hyperion Essbase(Analytic Server) Cube
Posted by Venkatakrishnan J on July 21, 2007
In this example, I would be using Sales Warehouse data that comes in Oracle SH schema. It would make a lot of sense if one creates a cube out of transactional data. But for the sake of simplicity I would be focussing on the cube creation process with a simple warehouse schema.
Before you start, ensure that you have all the components (Analytic Server and Analytic Integration Services up and running)
Open up the Analytic Integration Services Console. As soon as you start, it would prompt you to create an OLAP catalog.
Enter connection details for a schema that you generally use for storing metadata (recommended to create a separate schema in order to store the metadata). Once that is done it would automatically take us to the following screen
On to the left is the OLAP metadata connection. Enter the details that you entered in the previous screen. On to the right is the Analytic Administration Services connection. Enter those details here. The next step is to create an OLAP Model.
Next is the screen to establish a connection to the data source. As I said, I would be connecting to the Sales Warehouse schema.
There are two types of files that we would be dealing here. They are
ü Olap Model
ü MetaOutline
In Olap Model one can establish all the joins of the tables that they want in their schema. It requires a fact table and their corresponding dimensions. Hierarchies should be specified here.
Metaoutline is a file type wherein one can create the dimensions and specify the measures. Once the Olap model is created the next step is to design the Metaoutline.
The next step is to load the data.
Then one can use the excel add in to view the data.
This is one of the ways to create a cube. One can also create the cube directly from the Analytic Administration Services. Also, I have not gone into lots of other features that would make essbase stand part. This was just to show an overview for people would like to start with Essbase but do not know where to begin from.
July 21, 2007 at 6:36 pm
Hi Venkatakrishnan J,
Very good blog post, it’s most interesting seeing the basics of setting up Essbase. I look forward to reading your postings in the future. I’ve also added you to our blogroll.
– regards, Mark
July 21, 2007 at 9:34 pm
[...] weekend, and as a parting link, here’s a new Oracle BI blogger who’s recently posted a “getting started with Hyperion Essbase” article - good [...]
July 22, 2007 at 5:39 pm
Thanks Mark.
-Venkat
July 30, 2007 at 5:09 pm
Venkat,
Very nice posts so far. Provides much needed blog content around the various MOLAP servers. Suggestion - provide comments on how to load and extract data directly into cubes from external apps like ETL. Thanks.
January 11, 2008 at 12:40 pm
let me know exact meaning cube in hyperion essbase?what is the purpose in project?
April 21, 2008 at 12:52 pm
Hi Venkat,
Gr8 article………..infact, it helped me in understanding my current project requirement!
If possible, can you please post a similar article on developing an essbase aso cube without using AIS?
Thanks,
Vasanth Kumar
May 8, 2008 at 1:53 pm
very informative