If you have designed a logical, business-oriented universe, designers need to do very little to provide users with multidimensional analysis capabilities. Drill capabilities are automatically available to users; there is no need to explicitly build a cube. With robust measures, users can further perform rankings, top 10 queries, and so on.
New in XI Release 2 is the ability to create a universe on top of an OLAP database such as Microsoft Analysis Services, Hyperion Essbase, or SAP B/W. With the synchronized multiple data providers in Web Intelligence, users can create a report that spans both relational ...