Using Integration Studio to create data marts
As explained in Creating custom reports, data marts can be used to prepare data for a report.
A view can be a Structured Query Language (SQL) query or a materialized table. For information about how to create data marts using SQL code, see SQL-based data marts.
Data marts rely on a basic set of views that hide the TrueSight Capacity Optimization data model and expose a more report-oriented view over data, known as public views. All the data that can be extracted from TrueSight Capacity Optimization is available through public views. BMC recommends you to use public views to access TrueSight Capacity Optimization data instead of relying on underlying tables, that can change across versions of the product, and Analysis/Model data marts are also available.
To learn more about designing and implementing advanced data marts, see: