主要特征：Cube 定義

• 支持以下數(shù)據(jù)源：
  

• 單表或者查詢?nèi)魏螖?shù)據(jù)庫（任何 TDataSet 后繼，不需要 BDE）；

• 多表或者查詢?nèi)魏谓M織成 "star" 或者 "snowflake" 模式的數(shù)據(jù)庫（任何 TDataSet 后繼，不需要 BDE）。

• 支持一組集合函數(shù)，如 Sum, Count, Distinct Count, Min, Max, 無偏差或者有偏差，中值等。支持自定義集合函數(shù)。

• 支持把數(shù)字、字符串以及日期當(dāng)作測量值。

• 支持度量分組。

• 支持 Enterprise OLAP servers 中的所有立方體結(jié)構(gòu)元素（維數(shù)、層次、層次級(jí)別以及它們的關(guān)系）。你可以在 Desktop OLAP 中構(gòu)建立方體， 然后，當(dāng)增加表的大小時(shí)，把 Desktop cube 輸出到 MS Analysis cube, 在 MS Analysis cube 中，仍然不會(huì)改變立方體的邏輯結(jié)構(gòu)。

• 支持三種類型的層次：
  

• 主節(jié)點(diǎn)-子節(jié)點(diǎn)；

• 多級(jí)層次；

• 以上類型的混和。

• 能夠基于真實(shí)表行以及通過外碼與之關(guān)聯(lián)的所有維度表行中的數(shù)據(jù)，創(chuàng)建適當(dāng)?shù)亩攘俊⒕S數(shù)、層次以及層次級(jí)別。

• 能夠通過真實(shí)表以及集合立方體單元格值的信息，創(chuàng)建附加的計(jì)算度量。

• 支持維數(shù)或者層次的合適成員。

• 支持存儲(chǔ)了維數(shù)或者層次成員附加信息的維數(shù)或者層次屬性。

• 當(dāng)一個(gè)立方體單元格中存儲(chǔ)了真實(shí)表中的兩個(gè)或者多個(gè)值時(shí)，支持過度飽和立方體。

關(guān)鍵特征：數(shù)據(jù)視覺化

• 支持 Unicode.

• 在 Grid 同步時(shí)，能夠顯示多個(gè)度量。

• 對每個(gè)單元格，交互式 drill-down 分別支持所有層次類型。

• 在 OLAP 分析時(shí)，支持 "Undo" 以及 "Redo".

• 支持保存以及修復(fù)當(dāng)前 OLAP 片斷。

• 在不改變層次級(jí)別結(jié)構(gòu)的基礎(chǔ)上，支持任何層次級(jí)別上的成員分組。

• 支持任何層次或者維數(shù)級(jí)別上的單獨(dú)排序。能夠重載任何排序函數(shù)。

• 能夠依據(jù) OLAP 網(wǎng)格中的列值進(jìn)行升序或者降序排序。

• 在 OLAP 計(jì)算中，應(yīng)用或者不應(yīng)用過濾器，都支持過濾任何層次成員組。

• 根據(jù)網(wǎng)格中的值，自動(dòng)過濾層次成員。能夠根據(jù)成員的級(jí)別或者僅根據(jù)理論，來選擇一些主要/次要成員。

• 在網(wǎng)格中，不僅能夠顯示度量值，而且還能顯示總計(jì)百分比、小計(jì)百分比或者主要部分總計(jì)的百分比。能夠創(chuàng)建自己的用于顯示度量的上下文相關(guān)規(guī)則（例如：測量值對時(shí)間維的累積和）。

• 依據(jù)程序員指定的參數(shù)，能夠在任何網(wǎng)格中自動(dòng)制圖，以及對網(wǎng)格中的圖片定位。

• 完全的數(shù)據(jù)輸出控制，能夠在網(wǎng)格中任意繪圖。

• 在網(wǎng)格中，支持自定義繪圖。

• 在網(wǎng)格中，支持自定義彈出菜單。

• 在網(wǎng)格中，支持拖放度量或者層次成員。

• 依據(jù)單元格的寬度，自動(dòng)封裝其內(nèi)容。對于網(wǎng)格中過長的單元格，能夠自動(dòng)調(diào)整具有自動(dòng)封裝的列寬。

• 能夠直接在網(wǎng)格中編輯 OLAP 數(shù)據(jù)（支持 "writeback"）。

• 允許把當(dāng)前片斷顯示為圖表（任何 TChart 后繼）。在圖表中，支持 Drill-down 操作。可免費(fèi)獲得制圖組件的源碼。

• 允許把選定的網(wǎng)格區(qū)域拷貝到剪貼板中。支持所有公共的 office 剪貼板格式。

• 允許把網(wǎng)格數(shù)據(jù)導(dǎo)出到多種格式：MS Excel (使用 OLE 或者直接導(dǎo)出到 XLS-file), HTML, PDF, WMF, RTF, TXT, BMP, XML. 很快也可以導(dǎo)出到 RaveReport, ReportBuilder, FastReport. 它還支持在 printer Canvas 中直接繪圖。

• 易于本地化。還能夠局部化試用版。

Key features: Cube definition

• Support of the following data sources:
  • A single table or query of any database (any TDataSet successor, no BDE required);
  • Several tables or queries of any database organized into the "star" or "snowflake" schema (any TDataSet successors, no BDE required);
• Support a set of aggregation functions, such as Sum, Count, Distinct Count, Min, Max, biased or unbiased variance, median and so on. Supports custom aggregation functions.
• Support of numbers, strings and dates as measure values.
• Support of measure grouping.
• Support of all cube structure elements of Enterprise OLAP servers (dimensions, hierarchies, hierarchy levels and their relations). You can build the cube in the Desktop OLAP, and then, when increasing the size of tables, to port the Desktop cube into the MS Analysis cube, at that the logical structure of the cube will remain unchanged.
• Support of hierarchies of three types:
  • Parent-child hierarchies;
  • Multilevel hierarchies;
  • Mixed from both previous types.
• An ability to create calculated measures, dimensions, hierarchies and hierarchy levels based on the data both as the fact table rows and all dimension tables rows related to it with the foreign keys.
• An ability to create additional calculated measures, using both the information from the fact table and values of the aggregated cube cells.
• Support of calculated members of dimensions or hierarchies.
• Support of dimension or hierarchy attributes which store additional information about dimension or hierarchy members.
• Support of supersaturated cubes when one cube cell holds two or more values from the fact table.

Key features: Data visualization

• Unicode support.
• An ability to display many measures in the Grid simultaneously.
• Interactive drill-down support of all types of hierarchies separately for every grid cell.
• Support of "Undo" and "Redo" actions during the OLAP analysis.
• Support of saving and restoring the current OLAP slice.
• Support of member grouping on any hierarchy level without changing the hierarchy levels structure.
• Support of sorting on any level of hierarchy or dimension separately. Ability of overriding any sorting method.
• Support of ascending or descending sorting based on any column value in the OLAP grid.
• Support of filtering any set of hierarchy members with or without applying these filters in the OLAP calculations.
• Support of the auto filtering of the hierarchy members depending on their values in the grid. An ability for selection some major/minor members, either according to their rank or on the Pareto principle.
• An ability to display in the grid not only the values of the measures but a percent value regarding totals, subtotals, or grand totals. An ability to create your own context-sensitive rules on measure display (for example, a cumulative sum of measure values for time dimensions, and just its value for all other cases).
• The auto image drawing in any grid cell, the auto picture positioning in a cell, depending on the parameters assigned by a programmer.
• A complete data output control, a feature for the arbitrary drawing in the grid cells.
• Support of the custom drawing on the grid cells.
• Support of the custom popup menus in the grid.
• Support of the drag-n-drop of measures or hierarchy members within the grid.
• Auto wrapping of the cell contents depending on its width. Auto sizing of the column width with auto wrapping for the very "long" cells of the grid.
• An ability to edit OLAP data directly in the grid ("writeback" support).
• Allows to display the current slice as a diagram (any TChart successor). Support of Drill-down actions in the chart. The source code of the charting component comes for free.
• Allows to copy the selected grid area into the clipboard. Support all common office clipboard formats.
• Allows to export grid data to many formats: MS Excel (using OLE or directly to XLS-file), HTML, PDF, WMF, RTF, TXT, BMP, XML. Exports to the RaveReport, ReportBuilder, FastReport are coming soon. Also supports direct drawing on printer Canvas.
• Easy localization. It is possible to localize the evaluation version as well.