MDAccess 2.5 is a windows solution that shows info from an MDA (Multi-Dimensional Access) database. The info can be displayed in either charts or spreadsheet reports and easily rotated and selected along the different Dimensions to display the source info in several orientations.
Currently MDA databases can be maked by:
- ETR, the Element Table Reporter
- PointMan Reporter
- MDAccess 2.5
The MDA Database is conceptually a cube of info similar to a two, three, four, or more, dimensional array of numbers. The MDAccess program acts as a wrapper to the database, or essentially a utility that makes the numbers in the database viewable.
Additionally, the MDAccess program offers Calculations that extend the reporting and analysis capabilities of the program by providing the faculty to accomplish minor algebraic calculations on the info from the several dimensions.
The charts (Plots) can be any one of several Plot Types (pie, line, parallel bar, spreadsheet etc.) and for any given selection of info source Elements from the MDA Database, the source info is displayed accordingly. That is, for a given set of selected info elements, that set can be displayed as a Pie chart, a Bar chart, or a Line chart, etc.
The MDA Database is constructed by the above listed programs. The original souce of the info, that is the info source for the MDA Database constructor programs could be a database of any one of the following types:
- Sql Server
- Oracle
- Access
- Excel
The source info comes from a Select query or Stored procedure call to one of the above info sources that return a two dimensional table of info. From there MDA Database attributes are specified, and an MDA Database can be built.
With MDAccess you'll be capable to easily make charts and spreadsheets from multi-dimensional databases.
(more…)