Multidimensional Export Tool for Excel is a handy tool that helps analysts to extract data from Excel spreadsheet to multi-dimensional format. The software extracts data facts and dimension values from the spreadsheet and saves to XML, JSON or text/CSV format as well as loads the data to database table for aggregation or analyze directly.
This function prepares source data to analyze with OLAP tools those can operate with a multi-dimensional presentation of data only. For example, if you have sales from a few sources (shops, departments, divisions, etc.) as a matrix with the source in columns with a date and the product name in rows our software helps you to transform this matrix to flat table that can be aggregated by any dimension: date, source and/or product.
Also, the export tool is suitable for bulk matrix data conversion. Once describe the file format and save it as a schema, the user is enabled to apply it to any number of source spreadsheet with the same structure. It is a helpful function for companies with distributed net of departments that requires data consolidation. Each department can send Excel spreadsheet with local data and Multidimensional Export Tool for Excel collects them to common store.