How does OLAP fit in ?

Alchemex

Home > Analysis Module > How does the Analysis Module fit in > How does Sage Accpac Intelligence Analysis Module fit in ?

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

Microsoft Analysis Services cubes may have already been created. Sage Accpac Intelligence allows you to connect to these cubes so you can use the rest of the Sage Accpac Intelligence interface to create a report off this cube, and browse it using 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 Accpac Intelligence Analysis Module over other OLAP solutions?

Business Intelligence tools like Sage Accpac Intelligence 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 Accpac Intelligence Analysis 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