Business Intelligence – Oracle

EPM 11.1.1 – Essbase Studio, XOLAP – First Impressions

Posted by Venkatakrishnan J on July 18, 2008

I just did a complete install of the latest EPM release 11.1 on my laptop. One of the first things that i noticed was the naming of this release. This is a fusion release. So, you would notice a uniform look and feel across all the products. Also, the installation procedure itself has changed quite a bit. There is no more setup.exe that we need to click for each of the products. The entire EPM package can be installed at one shot. There is a seperate installer download. This installer would provide the UI for installing all the components. The screenshot below gives you a sample of the installer.

    

It would be interesting to see whether all the other oracle softwares like BI EE etc would follow the same installation procedure. There is also one more change that i noticed. There is no need for having seperate schemas for storing EAS and Shared Services related metadata. All of them can use the same database schema which simplifies the installation. Be warned if you are doing this installation on an XP machine. Shared Services would not start from the services console(i believe this would be a problem in all XP machines since i have noticed this on 3 different machines with XP as OS. Let me know if that is not the case). One would have to manually start it. The first thing that i did after the installation was to check out the Essbase Studio and the newly introduced XOLAP.

    

I was expecting some glitches here and there since this is its first release. But so far, all the connections, metadata creation etc have been pretty seamless. Also, there are some very helpful custom tool tips that pop up which provide you with proper direction whilst you are navigating within the studio. It looks like a lot of thinking has gone into this Studio version and so far it is looking really good. There is a very good lineage editor which shows the lineage of the metadata within Essbase Studio.

    

The other very good feature is that it now recognizes BI EE metadata, Oracle, Essbase as data sources.

    

Unfortunately, it does not understand BI EE hierarchy yet. It does not use the ODBC driver directly. Instead it directly connects to the 9703 port of the BI Server to extract the metadata. This i believe, is to bypass issues in using the ODBC driver. Now, lets see how we can create a simple XOLAP cube and see what XOLAP actually means. As a first step, lets import the tables in the default SH Schema.

    

We shall then create a new folder in the Metadata Navigator which would hold all the Multi Dimensional elements.

    

    

Once this is done, let us drag and drop relevant/needed columns from the source into the folder that we created above.

    

Now, create simple hierarchies on Channel, Time & Customer containing one column each (the hierarchies would be flat containing the ids to keep it very simple. This is not the best of examples).

    

Also, create a measure hierarchy to include AMOUNT_SOLD and QUANTITY_SOLD.

    

Now, lets create a new Cube Schema that would contain all cube related objects like Hierarchies and measure hierarchies. This is similar to the metaoutline creation step that one does in Essbase Integration Services.

    

After the creation of a cube schema, lets create a deployment model for that cube schema. So, basically the idea is to create all the possible hierarchies first in the root folder and then determine the type of hierarchies to load in different cube schemas.

    

Now, in the properties of the Model, choose the deployment option as XOLAP.

    

Now, right click on the model and click on the deployment wizard. As you see this is similar to the screen that we have in EIS for cube deployment. Lets choose a new application and database name to do the deployment.

    

As you see, since this is a XOLAP model, it will only build the outline. And the data would be retrieved at run time using SQL. So, this is very similar to ROLAP in OWB. But the difference here is that the outline resides outside of the database and SQL Queries would be fired on the fly while retrieving the data. Once deployed, lets look at the new cube from the Essbase Administration Console.

    

The XOLAP application also has a set of rule files and also the corresponding outline with the ids. Now, lets go into Visual Explorer and see whether the cube actually fires queries to get the data back for us.

    

Well it does work. But somehow it errors out whenever i try to do a pivot. On the whole, the Essbase Studio has a pretty intuitive user interface and looks very neat. Next, we shall see the new features of HFR and workspace.

Advertisements

6 Responses to “EPM 11.1.1 – Essbase Studio, XOLAP – First Impressions”

  1. Raj said

    Hi Venkat,

    it is very detail and nice. Thanks..

    When I try to configure after installation is successful, shared services registration is failed for every product. Surprisingly there is no way for me to control shared services registration process (I guess in this release shared services registration is implicit, I wonder how would it take any password changes, it doesn’t even asking for any shared services user id and password while configuring). I am still using the default user id and password for shared services admin. Can you please let me know any special registration process that we should do.

    Thanks
    Raj

  2. […] ImpersonationCustomizing OBI EE – SOAP APIOracle BI Publisher and BI EE – Invisible Admin Tab!!!EPM 11.1.1 – Essbase Studio, XOLAP – First ImpressionsHyperion Essbase Analytic Server – First ImpressionsOracle BI EE 10.1.3.3/2 – Using LDAP/OID […]

  3. Assia K said

    Hello,
    just wandering if the problem Raj reported was solved and how. I am now trying to install EPM 11 on a virtual machine and have struck the exact same issue. Shared Services registration fails for every product in the config tool but there is no individual option (like before) for Registering with SS.

    I can log into SS but get an error when I try to open the Projects Folder. I am also unable to provision users (“This option is not available”) or log into Workspace.

    I read somewhere that the Migration assemblies should be included in the installation, so I did that and I also eliminated the “Host resolves to IP address” error in the beginning of the installation.

    I am impressed by the installation process and how much easier and quicker it is now, just a shame that the config let the whole experience down :(!

    Any suggestions are most welcome.
    Many thanks,
    Assia

  4. Devyn C said

    Hello,
    I am having the same issue as Assia and Raj. Is there a fix for the registration issue? It is as if all of the Shared Services components are not being installed or recognized. You can access Shared Services login and when attempting to provision users, you just get an error stating that provisioning is not supported. Any advice would be great. Thanks.

  5. Kos said

    Guys, I have the same issue. But on some machines it works. May be problem is in some os settings…

  6. subrahmanyam said

    Hi Venkata Krishna,

    is it possible to use the parent child relation method to build the hierarchies using the Essbase studio, can you confirm please?

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: