MDAccess is a windows application that displays data from an MDA (Multi-Dimensional Access) database. The data can be displayed in either charts or spreadsheet reports and easily rotated and selected along the different Dimensions to display the source data in various orientations.
Currently MDA databases can be created by:
￭ ETR, the Element Table Reporter
￭ PointMan Reporter
￭ MDAccess
The MDA Database is conceptually a cube of data 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 tool 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 ability to perform minor algebraic calculations on the data from the various dimensions.
The charts (Plots) can be any one of various Plot Types (pie, line, parallel bar, spreadsheet etc.) and for any given selection of data source Elements from the MDA Database, the source data is displayed accordingly. That is, for a given set of selected data 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 data, that is the data 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 data comes from a Select query or Stored procedure call to one of the above data sources that return a two dimensional table of data. From there MDA Database attributes are specified, and an MDA Database can be built.
With MDAccess you'll be able to easily create charts and spreadsheets from multi-dimensional databases.
Here are some key features of "MDAccess":
· Flexible Element Selector allows for easy manipulation of available database elements with various searching, sorting, sub setting capabilities.
· Seamless Plot Type conversion and easy axis rotation allows for easy data view alteration.
· Calculations allow for subtotaling of elements by attributes or individual selections, which combined with the MDA Database export function, allow for easy access to pre-calculated values.
· Change History allows for easy Undo and Redo alterations.
· Multiple Plot definitions allow for multiple database views simultaneously.
· Context sensitive Help
· Easy Plot Form Definiton Save and Restore
· Excel Export functionality provides for easy export of data to Excel.
Requirements:
· Net Framework 2.0
Limitations:
· 40-day trial
· 200 Elements limit.
Find us on Google+
