469,270 Members | 1,839 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,270 developers. It's quick & easy.

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 5019
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 discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by George Sakkis | last post: by
reply views Thread by YellowFin Announcements | last post: by
reply views Thread by =?Utf-8?B?c3Bhcmtlcg==?= | last post: by
1 post views Thread by CARIGAR | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.