This content has been marked as final. Show 7 replies
ESSBASE + OBIEE Dashboards)You will in cubes which ll have hierarchies by default no need to create separate dim hierarchy for them.Search in google to know about cube structer
(OBIEE ADMIN TOOL + OBIEE Dashboards)Normal process we can do here we have to create dim hierarchies in BMM layer
I will suggest you to refer : http://en.wikipedia.org/wiki/Essbase to know much about essbaase cube and their design
so,that u ll came to know which one is better
Go through these links
Firstly it has cube structure and is flexible to work with and multi dimensional users view of data.
easy drill down features
ability to include heterogenous data sources in analysis
as sadi defined hierarchies
More important you said financial module,essabse is good for it.
hope it helps you.
OBIEE has infinitely superior reporting functionality to Essbase.
Essbase is absolutely excellent if you want to give your users data input and intuitive drill features. For financial projects Essbase is excellent for budgeting, planning, forecasting etc where you want a good deal of user input on a flexible and intuitive basis for data modelling from a large end user audience.
Essbase is a highly complimentary product for OBIEE as OBIEE fills its reporting needs, modelling Essbase cubes in the repository is brilliantly fast and Essbase' cubes create things like dimension hierarchies purely by dragging physical cubes into the business model layer.
11g features like asymmetrical drilling, ragged hierarchies etc could have been built with Essbase in mind - and MOLAP was definitely built with Essbase in mind.
I would recommend looking at the Oracle by Example for Hyperion (which has Essbase at its core) for a feel of what Essbase can do for you.