Develop Reports

The Mart offers efficiencies in report development:

• Data Mart simplifies the process of building SQL code for bringing your data together in a report.  Data Mart places data fields of multiple types (position, performance, transaction, etc.) on the same line of a data source table at the group and fund levels of aggregation, which saves you the effort of creating multiple OLAP report rules and profiles and then joining their results in SQL that you must develop.

• If you report data in a time-series fashion, you can do so for some performance fields using the Performance Query Tool.  For other types of data, OLAP processes will be limiting.  Through regular daily or monthly builds, Data Mart establishes a history of all data, making time series reporting easy.

• Data Mart encourages standardization of field definitions and helps reduce the unintended duplication of field attributes that sometimes accompanies OLAP report development.