MDAccess - Multi Dimensional Database Access

MDAccess is a Charting and Reporting program that displays data from MDA (Multi-Dimensional Access/Sql Server) Databases, and is essentially a wrapper and interface to the MDA Databases. It provides easy Access and Manipulation of that data, displaying selected subsets of that data in Chart or Spreadsheet Report form.

MDA Databases are a type of OLAP Database, which are discussed in this Wikipedia web site:
OLAP Databases

MDA Databases can be Constructed by any of the following software programs:

• MDAccess
• ETR
• PointMan Reporter

• Access databases
• Excel Spreadsheets
• Oracle databases
• Sql Server databases

After the MDA Database is built from the Source Data, it's ready for display in MDAccess. Within MDAccess subsets of data can easily be selected and rotated by the different Dimensions to display those subsets of data in various Orientations, Plot Types, or Calculations. Data can also be downloaded to Excel for further Display and Examination.

MDAccess Example Plots

(right click to pause screen in Internet Explorer)

MDA Database Construction

MDA (Multi-Dimensional) Access/Sql Server databases can be constructed from simple Excel spreadsheets that have at a minimum three columns, one of which is numeric and two are alphanumeric. They can also be built from data queried from a Sql database that results in multiple columns with at least two character columns to represent dimensions, and at lease one numeric column to represent a measure value. The option to build these databases is available in MDAccess under the 'Database' menu item.

For directions on building an MDA Database from MDAccess, click the link below:

How to Build an MDA Database from within MDAccess

Once the MDA database is constructed, the data can be viewed and utilized by MDAccess.

Features offered by MDAccess include...

1. Flexible Element Selector
       - allows for easy manipulation of available database elements with various searching, sorting, sub setting capabilities.
2. Seamless Plot Type Conversion
       - allows for easy change of one plot type to another.
3. Easy Axis Rotation
       - allows for easy data view alteration.
4. Calculations
       - allows for minor algebraic calculations including subtotaling of elements by attributes or individual selections, which combined with the MDA Database export function, allow for easy access to pre-calculated values.
5. Change History
       - allows for easy Undo and Redo of alterations.
6. Multiple Document Forms
       - allows for multiple forms showing multiple plots from multiple databases.
7. Multiple Plots per Form
       - allows for multiple plots to be displayed in same form.
8. Multi-Page Plots
       - allows for easy arrangement of multiple pages of plots within a plot.
9. Plot and Plot Section Positioning as well as Plot and Plot Section Drag and Drop
10. Easy Plot Form Definiton Save and Restore
11. Excel Export Functionality
        - provides for easy export of data to Excel.
12. Editable MDA Databases by Access or Sql Server Management Studio
13. MDA Database Builds from External Data
        - allows data in Excel, Oracle, Sql Server, or Access databases to be used as input to build MDA Databases.
14. MDA Database Builds from Existing MDA Databases
        - allows data to be subset or add Elements to MDA Databases.
15. MDA Database Direct Editing
        - to build MDA Databases from Scratch or alter existing MDA Database Values.
16. Context Sensitive Help
17. Print Preview
18. Annotations
        - easily positioned and arranged.
19. Annotations with Background Pictures
20. Pictures
        - easily added and positioned.
21. Same Scaling across Multiple Plot Pages
        - optionally allows auto-scaling across any number of pages of plots.
22. Text Group Formatting
        - allows various fonts, colors, and appearance features to be added to groups of function related text.
23. Plot Sections with Coloration or Background Pictures
24. Dynamic Plot Section, Plot Piece Tooltips
        - includes tabular as well as plot section tooltips.
25. Statistical Lines

plus many more...
New features for Current Version (Limited and Release)

A Free Limited Version is now being offered.

The Limited Version does not have a time expiration restriction as the Trial Version had.

The Limited Version is limited in:

1. The size of the External Data Source the MDA Database can be built from
2. The size of the MDA Database it call build
3. The size of the MDA Database it can read
   

The Limited Version limitations are:

1. A Maximum of 3000 External Data Source Rows can be read to build an MDA Database
2. A Maximum of 200 Elements in an MDA Database Dimension
3. A Maximum of 300 Total Elements on All MDA Database Dimensions

Link to download and install Free MDAccess Limited Version:
MDAccess 2.6.8 Limited Version

MDAccess requires the 'Microsoft .Net Framework 4 Client Profile' (or '.Net Framework 4').
The Framework may already be installed on your computer.
The install program will inform you if the Framework is not already on your computer.

Link to download and install Microsoft .Net Framework 4 Client Profile:
Microsoft .Net Framework 4 Client Profile
(to read Oracle Databases .Net Framework 4 is needed:
Microsoft .Net Framework 4)

Test Data Available for Download

Additionally, available for download is the link below, which is a .zip file containing test input data for MDAccess and ETR.
The test MDA databases can be read in either the Limited Version or the Release Version of MDAccess.

These files are Example data files to show how an MDA database can be created from data you may have in an Excel file or a Sql database.

Link to download MDAccess and ETR test data:
TestData1.zip

Purchasing the Release Version