August 10, 2010

The SAI Analysis module supports the creation of Microsoft local cube files or .cub files off any ODBC compliant datasource. However, SAI also supports the ability to connect into existing Microsoft SQL Analysis Services Cubes.

-Launch the Connector module and browse to the very last connection in the listing called Microsoft OLE DB Provider for OLAP Services.
-Right click on this connection, and choose Add a new connection, and give it a name.
-Fill in your properties regarding the OLAP server i.e. name, database name, credentials
-Right click on this connection and select “Check test” to confirm that you have a valid connection.
-Right click on this connection and choose add a data container, and you should be provided with the existing list of OLAP data cubes in your server for selection.\
-Now launch the report manager and select “Add Report” and choose “Cube Report” and select the relevant OLAP cube data container from the Connector module that you just made available in the Connector module.
-Accpac Intelligence uses Microsoft Excel pivot tables as the default cube browser
-The advantage of this offering is that your customers can have a seamless and consistent experience for running all their reports whether they be direct from source or via OLAP data cubes.
-The above process, eliminates the need to have the SAI Analysis module, as you are connecting to pre-created OLAP cubes. Should you need to create the data cubes yourself, the Analysis module is used to define and create dimensions and measures for your cubes, and build them seamlessly.


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: