OLAP

.NET

Pivot table

data cube

analytical data processing

One of conditions to achieve success in business is quick data analysis that allows saving money and time. Today many companies use pivot tables which have imperfections such as lack of flexibility and integrity of dataset, intraprocess transparency. Companies should put a question if they are ready to loose competitive ability using inaccurate data or apply progressive technology. For those who are eager to increase the efficiency by applying such a technology Perpetuum Software offers OLAP ModelKit. In addition to common functionality inhered by the existing OLAP components such as accuracy and easiness of data analysis, ability for creating and treating alternative relations etc. OLAP ModelKit has its own particularities. The product is fully compatible with .NET due to 100% managed code. This component has an XP Themed appearance and an ability to use any .NET data sources (including ADO.NET and IList). OLAP ModelKit supports nested data sources. Now there is no need to prepare a special data access meeting the required calculations. This library is intended for creating and utilizing cross reports based on multiple statistical data of large volumes. Moreover, OLAP ModelKit provides an opportunity to represent the final report data not only as a table; it also allows organizing the information so to make it available for use by third party chart components. It should be mentioned such features as comprehensible User Interface. Now end users have an ability of data filtering, drilling down, rolling up, dimensional pivoting, ranking. The product allows embedding OLAP technology in all Windows applications based on relational data. It is possible to export a cross report into an Excel table, HTML or PDF. OLAP ModelKit is a high-performance OLAP component specially designed to help reduce development time and costs while building effective decision support systems. Full source code in C# is available. Distribution of OLAP ModelKit is royalty free.