MDAccess can report from any of the Sql Tables or View listed above, or it can report from intermediate MDA Databases made from those Sql Tables or Views.
Reporting from MDA Databases provides additional functionality to the MDAccess Charts and Reports.
MDA Databases are a type of OLAP Database, which are discussed in this Wikipedia web site:
MDA Databases can be Constructed by MDAccess, 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 so long as there are columns with character data that can be used to represent the dimensions, and column(s) with numeric data to represent the measure values.
See MDA Database Build for more details.
After the intermediate MDA Database is built from the Source Data, it's available for repeated use in MDAccess until no longer needed.
Download and Install MDAccess Version 2.8.0
© Structurally Sound Software Solutions