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

Aleck

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

Gianni Ceresa

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

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]

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

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