OLAP ModelKit 4.0.1.0

OLAP ModelKit 4.0.1.0 effectively assists you to achieve success in business.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.

OLAP ModelKit™ is a multifunctional OLAP component for .NET written in C# containing only 100% managed code. This component is superior to competing products because of an XP Themed appearance and the ability to use any .NET data sources (including ADO.NET and IList).

The flexibility of the product is additionally extended by the ability to present data with the help of any third-party component, especially chart components.

OLAP ModelKit™ is easy and convenient to use with a friendly User Interface that is attractive and comprehensible.

OLAP ModelKit™ allows developers to embed an effective OLAP technology in all Windows applications based on relational data, allowing end users to interact with huge databases, summarizing, and exploring data infinitely.

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. Please be advised that OLAP ModelKit 3.9.0.0 supports only .NET 2.0/3.5. If you work with .NET Framework 1.1, please use OLAP ModelKit 2.3.2.1 that is compatible with .NET 1.1 and .NET 2.0

With OLAP ModelKit™ embedded in your application, your users will be able to view any amount of data in any way considered suitable at the moment, as well as performing interactive analysis of any type and quality. The following manipulations are available: data filtering, drilling down, rolling up, dimensional pivoting, and ranking.

Why should we choose OLAP ModelKit™?

1. High Data Processing Speed: Effective data processing as you go. When you change the settings of the table layout (i.e. modify groupings in dimensions or add new groupings and facts), a new report is presented to you right away. Immediate access to the required data allows performing qualitative and comprehensive analysis.
2. Various Data Calculation Instruments: Using Aggregate Functions you can calculate different aggregates for the same data. Moreover, the product enables the creation of custom aggregate functions. Due to a built-in expression language, the OLAP ModelKit allows the creation of cross reports of any complexity depending on the data-source information.
3. Support for Any .NET Data Sources: You can use any .NET data source for your cross reports. It can be both ADO.NET objects (such as DataSet, DataTabel or DataView) and/or your own objects with support for IList and IListSource interfaces.
4. Data Visualization: Appearance Uses XP Styles, as well as Office and Smooth Styles, and Custom Drawing. More then 30 styles performed in various palettes are predefined in the Wizard. The OLAP ModelKit is fully compatible with the chart component Chart ModelKit, so you can visualize the results of multidimensional data analysis with the help of powerful charts. Make your reports look more professional!
5. Ease of use: Use of the applications, developed with OLAP ModelKit, doesn’t require any special programming knowledge. The developers would be pleased with the drag-and-drop mechanism, which allows the execution of any operations over the cube with the help of a mouse. Simplify development of the applications which use OLAP technology!
6. Technical Support: Technical support is provided according to the following plans: Free and Premium. Regardles of the plan you choose, our support staff will process and respond to your request. Premium Support subscribers get additional benefits. You can purchase Premium Support subscription together with license for the product.
7. Upgrades and Updates: Perpetuum Software LLC specialists are constantly improving the products. The purchase of the OLAP ModelKit guarantees a free delivery of all fixes, updates and new versions during one year.
8. Full Source Code in C# and Unit Tests: The full source code provided with the professional version will give you full control of your application. Moreover, availability of unit tests provides the ability to test separate units of your application source code.
9. OLAP ModelKit is royalty-free: This means that you can distribute OLAP ModelKit within your applications to end-users without any additional fees.
10. Favorable pricing when switching from competing products to OLAP ModelKit: If you are using or used any competing software component and consider switching to any Perpetuum Software product, we are ready to make you an advantageous offer and provide you with assistance of any kind. Click here to contact our representative for competitive pricing options and help. Please, indicate the name of the software product you are switching from.
11. Easy Ordering: Purchasing a software product via the Internet saves you time and trouble. A variety of payment methods guarantees quick order processing and timely product delivery. Your order will be processed by Plimus or Share-it. After your payment is received, you will be able to download an appropriate license key required for trial activation. An e -mail with instructions on how to obtain a license key and activate your product copy will be dispatched to you. 

Major Features:

1. General
   
   • OLAP ModelKit™ contains only 100% .NET managed code. Compatible with Visual Studio 2003/2005 and Microsoft .NET Framework 1.1/2.0
   • Wizard for Cubes Creation is Available: The pivot table setting wizard is available both at visual design time and at your application run time. Using the wizard, you can easily group dimensions, adding new groupings or modifying the existing ones, specify what information contained in a data source should be used in calculations and the rules for such data use, define the final table presentation style, and so on.
   • Allows Saving All Parameters in XML File: You don’t need to adjust a big cube over and over again when it is necessary to create a new report. Just save the settings of the table layout and display style and use them repeatedly, making any necessary changes.
   • Full Source Code in C# and Unit Tests are Available: The full source code provided with the professional version will give you full control of your application.
   • Easy to Localize: The OLAP ModelKit™ can be easily localized. The string resources for product localization are stored in xml files and can be used at any time. The localization files are included in the OLAP ModelKit™ package and can be found in the Localization catalog. The package now contains Romanian, Thai, Danish, German, Turkish, and Russian localizations.
2. Data P rocessing
   
   • You can Connect to any .NET Data Sources: ADO.NET, IList, and IListSource. The Product Supports Nested Data Sources: You can use any .NET data source for your cross reports. It can be both ADO.NET objects (such as DataSet, DataTabel or DataView) and/or your own objects with support for IList and IListSource interfaces.
   • Effective Data Processing as You Go: When you change the settings of the table layout (i.e. modify groupings in dimensions or add new groupings and facts), a new report is presented to you right away.
   • Dynamic Data Sorting and Filtering by Assigned or Arbitrary Conditions: Need a table displaying a definite set of values from a grouping or a table column? You simply specify all necessary values and click the OK button. Moreover, the expression language allows you to specify any condition for value selections. The ability to change data sorting within the dimension grouping is especially useful when you have a large range of data sources.
   • Includes Powerful Expression Language, and a Convenient Expression Editor: Due to a built-in expression language, the OLAP ModelKit™ allows the creation of cross reports of any complexity depending on the data-source information.
   • Aggregate Functions: It is Possible to Calculate Different Aggregates for the same Data: The calculation of intermediate table results is conducted subject to aggregate functions such as standard deviation, estimate of standard deviation, variance, estimate of variance, median, skewness, and kurtosis. The display shows not only the sum, but also the minimum, maximum, and average values for the entire table or the whole number of values, and other manipulations. In addition, the OLAP ModelKit™ enables the creation of custom aggregate functions.
   • Ability to Break Date and Time Fields into Series Dimensions (Year, Quarter, Month, Day of Week): The expression language contains a set of functions for date processing; groupings by months or days of the week can be created within dimensions based on dates taken from the data source.
   • You can easily group any data by a range of values using the special functions provided within the expression language.
   • Source data editing: It is possible to access the set of source data used for any pivot table cell calculation and to analyze and edit these data.
   • An Unlimited Number of Dimensions and Measures: In order to increase report visualization and the data systematization level while projecting a pivot table, you can define as many groupings as required.
   • Interactive values grouping: Interactive grouping of values allows sophisticated and effective analysis.
   • Sorting by total: Sorting by total columns makes quantitative data analysis easier – just click on the corresponding total.
3. Data visualization
   
   • Appearance Uses XP Styles, as well as Office and Smooth Styles, Custom Drawing, and Custom Format: The OLAP ModelKit™ allows the display of pivot table reports corresponding to the visual style currently used.
   • It is Possible to Present Data with the Help of Chart ModelKit™ and any Third-Party Data Visualization Components: More tight integration with Chart ModelKit™ provides the display of your pivot table as comprehensive charts. Just place Chart Viewer on the form the DataCubeGrid is located on, few mouse clicks and the data is transformed into meaningful information. The DataCubeView component delivered in the OLAP ModelKit™ package allows converting a cube in such a way as to make the data available for use by third-party components.
   • Header and footer displaying: Cube layout allows you to specify headline, header and footer printed out and taken into account when the document is exported to Excel, Html and Pdf formats. Headers and footers are edited in the wizard available for both developers and end users.
   • Graphic and Percentage Data Output: You can set special modes for the display of cell values making your cross reports more visual. Values can be displayed as percents or as a progress bar that fills the cell depending on the percent value.
   • Print Ability: An End User Can Preview And Print Necessary Reports At Any Time. A user can preview and print reports at any stage while working on a pivot table. It is possible to adjust the print of the document: you can specify whether styles will be taken into account or whether page headers and the values of the dimension groupings will be printed on every page.
   • HTML, Excel, and PDF Export: A created pivot table can be presented not only in the form of your application but as a hard copy. You can export your pivot table to an Excel or HTML document. Table layouts as well as all visual settings will be taken into account.
   • Interactive Data Representation Management: You can change dimension groupings, set groupings, and table filters even without running the designer. All operations are available either from contextual menus or conducted by means of the drag-and-drop option.
   • Interactive Grid for Preview with Drag-and-drop Support: The interactive DataCubeGrid component delivered in the OLAP ModelKit™ package allows the display of the pivot table on your application form. This component provides a set of easy-to-use layout controls for the pivot table modification at runtime. Any operations on the cube can be executed from contextual menus, from the tool bar, or by drag-and-drop.
   • Ability to Change all Appearance Properties including Styles at Design Time and at Run Time

Requirements: .NET Framework 2.0

 WareSeeker Editor