Beginner OBIEE question, possible to connect to multiple Essbase cubes? — Oracle Analytics

Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Beginner OBIEE question, possible to connect to multiple Essbase cubes?

Received Response
31
Views
4
Comments
Aleck
Aleck Rank 1 - Community Starter

Expect a little bit of hazing being new to OBIEE and this is probably a dumb question...  But I have 2 Essbase cubes, almost exactly alike but one cube has an additional dimension.  Is it possible to have one dashboard being populated by both Essbase cubes?

Thanks!

OBIEE New-B

Answers

  • Hi and welcome to OBIEE,

    Yes you can connect to as many cubes as you want.

    The RPD accept multiple physical sources, so not an issue at all to connect to your 2 cubes.

    The detail is mainly what do you really except with "have one dashboard being populated by both cubes" : having independent pieces of the page or like a single table showing data from both?

    In the end it's all possible, also because your cubes seems to be really close (just one dimension being different?).

    So you can do all these things in OBIEE.

  • cesar.advincula.o
    cesar.advincula.o Rank 6 - Analytics Lead

    As part of this oracle epm you could import essbase, hfm, etc.  if you want to import essbase as a data source you have to install a essbase client and modify your biinit.cmd, http://docs.oracle.com/cd/E28280_01/bi.1111/e10540/datasource.htm#BIEMG1233

    http://www.oracle.com/webfolder/technetwork/tutorials/obe/fmw/bi/biee/r1013/essbase/biee_essbase.htm

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    No hazing as you asked nicely and you were quite precise about what you want to do :-)

    As Gianni already said yes that's perfectly possible and supported. You can both have the two cubes in separate Subject Areas which for your question would mean simply having 2 analyses on the same dashboard being populated from 2 SAs.

    You can however also model both cubes into a combined business model and then combine the data into a homogeneous model serving a central SA.

  • Aleck
    Aleck Rank 1 - Community Starter

    Thank you very much Christian, Cesar and Gianni!  Your reply's are most appreciated!