473,396 Members | 1,666 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,396 software developers and data experts.

DB2 OLAP vs Hyperion Essbase (version, package)

Hello All,

We are currently considering DB purchases for a new system, we are
looking at Cognos, Oracle, DB2 and Essbase. We came across some
questions regarding Essbase and DB2 OLAP.

1. Are DB2 OLAP and Essbase are identical?
2. Does the standard Essbase SDK is provided with DB2 OLAP?
3. Does EIS is provided with DB2 OLAP?
4. Is there a way to get a "translation table" between DB2 OLAP and
Essbase versions?
5. Does any patch that will be available for Essbase will also be
available for DB2 OLAP?

Any additional information will also be helpful.

Thanks,
Gadi R.
Nov 12 '05 #1
2 5204
JC
> We are currently considering DB purchases for a new system, we are
looking at Cognos, Oracle, DB2 and Essbase. We came across some
questions regarding Essbase and DB2 OLAP.

1. Are DB2 OLAP and Essbase are identical?
====================
Yes they are - IBM is a reseller of Essbase under the banner DB2 OLAP.
However, their version numbers may differ (leading to your question #4).
Skills are directly transferable between DB2 OLAP and Essbase - from the
OLAP server administration perspective.
====================
2. Does the standard Essbase SDK is provided with DB2 OLAP?
====================
Yes - the APIs are the same. Applications built for Essbase can work
against DB2 OLAP and vice versa (provided there are no version conflicts).
====================
3. Does EIS is provided with DB2 OLAP?
====================
I believe IBM resells EIS as well, but probably seperately. This is
something you would have to ask the IBM rep about.
====================
4. Is there a way to get a "translation table" between DB2 OLAP and
Essbase versions?
====================
IBM does have a document that compares the DB2 OLAP version numbers to
Essbase - but I'm not sure if its published anywhere easy to find (I did a
quick search of IBM's web site but did not find anything - but it might be
there somewhere).
====================
5. Does any patch that will be available for Essbase will also be
available for DB2 OLAP?
====================
Generally yes, but there may be a lag in getting updates for the DB2 OLAP
versions. In reality, this is not really a major issue, as most
organizations have a testing lag before they apply patches in production.
====================
Any additional information will also be helpful.

Thanks,
Gadi R.


=====================
The only major difference between DB2 OLAP and Essbase is that DB2 OLAP has
the option to build ROLAP cubes - something the Hyperion version cannot do
(EIS allows for Hybrid cubes, but not pure ROLAP cubes).

Also, IBM has ported Essbase to the OS 390 platform (ShowCase has ported
Essbase to the AS/400).

Regards,
Jade
-----------------------------------------
Jade Cole
Senior Business Intelligence Consultant
Clarity Systems
jc***@claritysystems.com
www.claritysystems.com


Nov 12 '05 #2
> 3. Does EIS is provided with DB2 OLAP?

====================
It is provided with DB2 OLAP. It's called Integration Services
(instead of Integr. Server). And you should configure it after
installing DB2 OLAP.
====================
Nov 12 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

7
by: Will | last post by:
On the subject of Data Warehouses, Data Cubes & OLAP…. I would like to speak frankly about Data Warehouses, Data Cubes and OLAP (on-line analytical processing). Has it dawned on anyone else...
0
by: DD | last post by:
Hi Guys! Just would like to share with you my experiense in this matter. I was trying to evaluate how suitable Oracle OLAP for our applications. As probably you did, I have downloaded from OTN...
0
by: mrwoopey | last post by:
Hi, Instead of using the Japanese version of the OLAP control for vs.net there is now an English version: Visual Studio .NET Web Control for Business Intelligence - ...
1
by: serge | last post by:
When I start creating a new DTS Package and I choose the Analysis Processing Task icon, I only have the option of working with the local Microsoft Analysis Server. How can I choose a remote...
3
by: Joel Leong | last post by:
I use C# to invoke DTS. The DTS run successfully if no process cube function in it. But after i add process cube function, the ASP.NET page hang. I even impersonate ASP.NET to an account with...
3
by: George Sakkis | last post by:
After a brief search, I didn't find any python package related to OLAP and pivot tables. Did I miss anything ? To be more precise, I'm not so interested in a full-blown OLAP server with an RDBMS...
0
by: YellowFin Announcements | last post by:
Yellowfin Reporting Announces Release 3 OLAP Connectivity New Features Including OLAP-to-Relational Drill Through Provide Customers with One Complete Web BI Tool for OLAP Analysis Yellowfin,...
0
by: YellowFin | last post by:
Yellowfin Announces Release 3 OLAP Connectivity New Features Including OLAP-to-Relational Drill Through Provide Customers with One Complete Web BI Tool for OLAP Analysis Yellowfin, today...
0
by: =?Utf-8?B?c3Bhcmtlcg==?= | last post by:
Has anybody had the occasion to to build a VB.NET 2008 application that will manipulate an Excel workbook including the Hyperion Essbase Plugin? I was not sure which forum to post this question in...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.