Solved

Can I do integrated reporting from Multiple Essbase Cubes using Microstrategy?

Posted on 2009-07-01
8
1,578 Views
Last Modified: 2012-05-07
Dear experts,
My company has data available in different Hyperion Essbase Cubes. We currently use Webfocus for most of the BI reporting needs. There was a need to have a proper Dashboard in which user can drill down into any level of details of the data. Does Microstrategy provide the capability of providing this integrated reporting from multiple cubes.

I checked with a Business Intelligence colleague and he suggested that Microstrategy cannot pull from Essbase cubes. But I did some reading from Google and Microstrategy's website and found that it does support the same.

If it is possible, I think it will take less time than developing the same in Webfocus.

If someone has experience in these lines, could you please reply?

Thanks in advance.
0
Comment
Question by:j1981
  • 5
  • 3
8 Comments
 
LVL 5

Expert Comment

by:garycris
ID: 24754196
I don't have direct experience, but having been an Essbase developer for many years I can tell you that a lot of third party front ends do not work that well with Essbase unless they have been specifically written for Essbase.  Tools like Business Objects for instance can connect to Essbase but they often treat it more like a relational OLAP source rather than the true multi-dimensional OLAP data source that it really is.  These products often have trouble working with Essbase features that support ragged hierarchies and attributes.  Often the tool will deconstruct the Essbase data and then roll it back up itself, defeating the entire purpose of having it in Essbase to begin with, as Essbase is much more efficient at consolidating than these products.
So I believe there is an adapter for Microstrategy that will allow you to connect to Essbase, but you might not want to get your hopes up too high as I'm not sure what functionality it is going to expose.
0
 

Author Comment

by:j1981
ID: 24754400
Thanks a lot for the response.

We are actually looking for a short term solution(1.5 years) till the completion of a datawarehousing solution. Can you suggest any Essbase specific tools that can serve the purpose,Other than the Essbase Excel Add-in? We could have tried in Excel, but there are too many issues coming up like lower performance, Excel crashes etc..

0
 
LVL 5

Accepted Solution

by:
garycris earned 500 total points
ID: 24765699
The default web reporting tool for Essbase was something called Hyperion Analyzer, which is now called Web Analysis.  I've never been a fan of the product, but it does some basic things okay.  The thing with that is, rumor has it Oracle is going to be dicontinuing the product.  Oracle's plan is to get people using their OBI platform which they are currently revamping to work better with Essbase.  Their products have the issues I talked about above, but since they aquired Hyperion they are now updating the OBI platform to work better with the Hyperion products.  Needless to say OBI would be a pretty big implementation.  Based on the needs you are describing, you might want to look at a company called Applied OLAP.  They have an awesome web tool called Dodeca http://www.appliedolap.com/
I would check them out, they are very knowledgable about Essbase and I believe the product is reasonably priced.
You could probably get it up and running very quickly and have reports out to your users soon after.
I think they could be a good fit for what you are looking for.

Best of luck.
0
 

Author Comment

by:j1981
ID: 24770636
Thanks a lot. I checked through the site and it looks perfect to match the requirement. There are no pricing informations given and they are asking to contact them for a site demo. I am going to raise it to my managers to do it.  I will revert as soon as I have some update. Thanks again.
0
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 

Author Comment

by:j1981
ID: 24793386
Hi Garycris,

All your responses were of immense help and is greatly appreciated.

If you have the info, could you let me know how much is the licensing fee for Dodeca? It may help me in putting the case across to my managers before an actual demo is requested.

Thanks in advance.

 
0
 
LVL 5

Expert Comment

by:garycris
ID: 24794059
I don't know the pricing yet, I am currently in preliminary conversations with the vendor.  I know some other people who are using it and said the pricing was very reasonable.  You now how this stuff goes, they don't generally throw the price right out there until they get a chance to talk to you.  I can say that these guys don't seem too bad from the sales side, they are not overly pushy and have been willing to answer all my questions.  So I would just go ahead and reach out to them and ask any questions you have.  The guys I have been talking to are Michael McCarty [mccarty@appliedolap.com] and Tim Tow [timtow@appliedolap.com]
0
 

Author Comment

by:j1981
ID: 24794133
Thank you again. I am waiting for the response from my managers. I will revert soon on the progress.
0
 

Author Closing Comment

by:j1981
ID: 31623728
I am still to get approval to check in further on this, but I feel this is the exact tool for my kind of requirement. Once something more happens I will add it to the end as a separate comment. Thanks Garychris for the prompt and great help.
0

Featured Post

Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Linking to Report Server Shared Data Source 4 103
Historical Data of SSRS Reports 1 68
SSRS and Visual Studio Setup 7 79
VB RDLC Report 1 72
Problem Statement In an SAP BI BO Integration project when a BO universe is built on a BEx query, there can be an issue of unit & formatted value objects not getting generated in a BO universe for some key figures. This results in an issue whereb…
Jaspersoft Studio is a plugin for Eclipse that lets you create reports from a datasource.  In this article, we'll go over creating a report from a default template and setting up a datasource that connects to your database.
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.

757 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now