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

Question

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

Aleck · Answer

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

[Deleted User] · Answer

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.

cesar.advincula.o · Answer

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