Hi all... I am a SQL/Report Developer a bit of VB and VBA here and their. However I am going to be starting my new role soon which will be that of DBA. The main aspects of the job will be to implement SQL Anlytical Services for OLAP. Now here is my question, the only kind of OLAP tool I have had exposure too is Oracle Essbase and only small exposure at that. As I understand it, data in an OLTP goes into the Warehous and it goes in calculated etc so its geared for heavy reporting. Why then do you need Essbase ? Cant one just use a report write agains the warehouse, what is the difference between the 2. I know Essbase is a MDBMS so why do we need the warehouse, why not just bypass the warehouse and have the OLTP feed into Essbase.
Start Free Trial
