Analytix

Analytix is an out of the box solution developed using Analytix SDK that seamlessly links to any Microsoft® SQL Server Analysis Services cube. Analytix is delivered with a free-roaming analysis facility and a suite of packaged analysis techniques that can be configured by the end user.

Analytix SDK

This is the ultimate productivity tool for building tailored front end applications for Microsoft SQL Server 2000 Analysis Services. The software is fully integrated and offers complete flexibility and, being based on Visual Basic and ActiveX technology, ensures a risk free, future-proof investment.

The Analytix SDK offers a range of objects and programming methods, which enable the differing types of front end to be built quickly. Available within the system are tools which allow the user to navigate through the dimensions and hierarchies, display the data in both grid and graph format and a splitter control which gives resize capabilities to the objects on screen. When an application has been built data can be colour coded for exceptions and the shape of grids can be saved as recallable views. Powerful ad hoc capabilities are also provided to aggregate items in the hierarchy which are not predefined consolidations and complex in flight calculations can be defined.

This unique approach to building front-end applications successfully blends together the specifics of OLAP with the generic features of Visual Basic. Combining these two allows for more elegant applications to be developed.

Component Description
aaConnection aaConnection is used to connect Analytix SDK controls on the form to a data source. The data source can be either an Analysis Services database on a server or a local cube file. Multiple instances of aaConnection can be placed on a form enabling connections to a number of different datasources or multiple connections to a single cube.
ActiveSlice The grid control is the component that displays numeric information. The grid will display nested dimensions and supports a range of ad hoc added value features such as colour coding of exceptions, precise formatting and the ability for users to define additional calculations on the fly. picture
ActiveChart The chart control will display graphs that can either be synchronised with the contents of the grid or driven separately with embedded features that will add or remove dimensions and members. This component offers a large degree of control over graph styles and types. picture
ActiveScribe The reporting control is a high performance report and calculation tool that uses information from the grid control. picture
ActiveChoice The navigation component gives you the ability to navigate through the structures of the cube. The left hand pane shows the dimensions in the cube, the centre pane shows the contents of a selected dimension and the right hand pane displays the members selected for display in the grid if the dimension is visible or which member is fixed on if the dimension is not visible. picture
aaCubeSchema aaCubeSchema enables the user to browse the structure of cubes. Programming features enable the display of dimensions, levels and members to be restricted. picture