Home > OLAP Module > How Does The OLAP Module Fit In > How does Sage Intelligence Reporting OLAP Module fit in ?

How does Sage Intelligence Reporting OLAP Module fit in with other OLAP solutions?

Microsoft Analysis Services cubes may have already been created. Sage Intelligence Reporting allows you to connect to these cubes so you can use the rest of the Sage Intelligence Reporting interface to create a report off this cube, and browse it using Microsoft Excel. The advantage of this is that you now have one common interface for all your organizations reporting, whether it is fixed format reporting or analysis.

The Advantages of Sage Intelligence Reporting OLAP Module over other OLAP solutions?

Business Intelligence tools like Sage Intelligence Reporting transform data into knowledge. It is worth considering what local cube technology offers an organization as an extension to Microsoft Analysis Services as an OLAP tool. Sage Intelligence Reporting OLAP Module offers functionality to build and maintain Local cubes.

So why would an organization want to do this?

• A local cube file can be loaded on a laptop, so that a user can browse multidimensional data while disconnected from the network

• A local cube can be e-mailed to a remote user who does not have access to the Analysis Server

• Local cubes can be downloaded from web sites, so that remote users can be given access to multidimensional data

• Different local cubes can be created and distributed to different users, with each cube containing only the information the person is authorized to see

• Local cubes can be created that have a subset of the Analysis Server cube's data. This can greatly increase convenience and browsing speed for the user

• When a cube only contains the subset of information that the user wants to use, they can browse more quickly and more efficiently