MDAccess simplifies data analysis by allowing users to create multi-dimensional charts and reports from either tables or database views. Additionally, it also facilitates the creation of multi-dimensional charts and reports by querying data from databases into MDA databases.
MDAccess is a user-friendly Charting and Reporting program that offers a flexible and easy-to-use interface. This program is designed to display data in Chart or Grid Report form from Sql Data Sources. MDAccess is the Windows version of Chart It.
With MDAccess, accessing, displaying, and manipulating selected subsets of data is a breeze. You can select subsets of data within the software and rotate them by the different dimensions. This allows you to display subsets of data in various orientations, plot types, or calculations.
You can use MDAccess to report from either direct Sql Tables and Views or indirect MDA databases made from Sql Tables and Views. The source Sql Tables or Views for either direct reporting, or indirect reporting is listed below.
MDAccess reports directly from Sql Server Tables or Views, MSAccess Tables, and Excel Spreadsheets. It also reports indirectly from Sql Server Tables or Views, MSAccess Tables, Excel Spreadsheets, and Oracle Databases.
The software can report from any of the Sql Tables or View listed above or intermediate MDA Databases made from those Sql Tables or Views. Reporting from MDA Databases provides additional functionality to the MDAccess Charts and Reports.
MDAccess Databases are a type of OLAP Database that can be constructed in the software under the Database menu or when a new Plot is being defined. The Source Data Table or View can be any query or spreadsheet of data as long as there are columns with character data that can represent the dimensions, and column(s) with numeric data to represent the measure values.
After the intermediate MDA Database is built from the Source Data, it is available for repeated use in MDAccess. Overall, MDAccess is a powerful software that makes charting and reporting a seamless process.
With MDAccess, accessing, displaying, and manipulating selected subsets of data is a breeze. You can select subsets of data within the software and rotate them by the different dimensions. This allows you to display subsets of data in various orientations, plot types, or calculations.
You can use MDAccess to report from either direct Sql Tables and Views or indirect MDA databases made from Sql Tables and Views. The source Sql Tables or Views for either direct reporting, or indirect reporting is listed below.
MDAccess reports directly from Sql Server Tables or Views, MSAccess Tables, and Excel Spreadsheets. It also reports indirectly from Sql Server Tables or Views, MSAccess Tables, Excel Spreadsheets, and Oracle Databases.
The software can report from any of the Sql Tables or View listed above or intermediate MDA Databases made from those Sql Tables or Views. Reporting from MDA Databases provides additional functionality to the MDAccess Charts and Reports.
MDAccess Databases are a type of OLAP Database that can be constructed in the software under the Database menu or when a new Plot is being defined. The Source Data Table or View can be any query or spreadsheet of data as long as there are columns with character data that can represent the dimensions, and column(s) with numeric data to represent the measure values.
After the intermediate MDA Database is built from the Source Data, it is available for repeated use in MDAccess. Overall, MDAccess is a powerful software that makes charting and reporting a seamless process.
What's New
Version 2.7.8:
1. Added Database Editing option to add Image_Location to MDA Database Elements.
2. Added Images as an optional Plot Piece fill type for MDA Databases.