OLAP cubes

OLAP cube.

The OLAP cube data source provides connectivity to MDX-compliant multi-dimensional data secttructures (cubes) such as Microsoft SSAS and other cubes.

Omniscope DataManager workspace currently supports direct connections to Microsoft Analysis Services and some other MDX-compatible mutli-dimensional cube structures from other vendors.

In order to use the OLAP connector you will need to configure HTTP access to the MDX server. Most OLAP sources support this, however you may need to configure access on the server.

The following link provides details on configuring HTTP access to SQL Server 2008 Analysis services. Information on configuring access to other cube providers can normally be found on the internet or by speaking to your system administrator.

Visokio made the decision to provide access cubes via MDX because it provided a generic solution, allowing connection to several different providers. The downside of this solution is that it does require some pre-configuration and data retrieval may be slower than a direct connector. Visokio intend to implement direct connectors for OLAP servers such as Microsoft SSAS in the future. This development will be dictated by demand from clients.

Options

The connection details section allow you to specify how to connect to the OLAP server.

Server URL. Enter the name or IP address of the OLAP server.
Username/Password. Enter the authentication details that you use to connect to the OLAP server. Once you have entered the connection details click the "Connect" button. If the connection was successful a list of OLAP cubes, dimensions and measures will be downloaded and available for selection.

The cube data section specifies what data you want to retrieve from the OLAP server. You can only select this data once you have successfully connected to the OLAP server.

Cube. Select the Cube that you want to import.
Dimensions. Choose the dimensions available in the selected cube.
Measures. Choose the measures from the selected cube.
Check max rows. Select this option if you want Omniscope to check that the maximum number of rows obtained from the dimensions selected does not exceed a specified value. This check is done before the data is imported into Omniscope.
Custom MDX. Select this option if you want to modify the MDX or enter a custom MDX statement. Not all MDX will be compatible with Omniscope.

Formatting

The formatting secion determines how the data will be structured when it is imported into Omniscope.

Pivot data. Select this option if you want to pivot the data before importing it into Omniscope.