This topic describes the types of data marts available in the TrueSight Capacity Optimization product.
Analysis/Model data marts can be used to prepare data for the capacity views or other external tools. In particular, you can use them to:
An Analysis/Model data mart is a data mart that contains data generated by an analysis or model. You can access this page by navigating to Administration > Advanced Reporting > Data marts > data marts Name from the TrueSight Capacity Optimization Console.
You can use an Analysis /Model data mart to create a SQL-based data mart. For more details, see SQL-based data marts.
Workflow for using an Analysis/Model data mart to build a SQL-based data mart
In addition, you can define the validity of Analysis/Model data marts, that is the time span during which the data mart will not be materialized again, regardless of how many times it is requested. For example, you can set the validity to one day. You can set the validity parameter to zero, to materialize the data mart every time the Analysis/Model View is requested.
A SQL-based data mart is a standard SQL data mart statement, managed by TrueSight Capacity Optimization in terms of creation and materialization.
A SQL-based data mart enables you to manipulate data. Using a SQL-based data mart, you can complete the following tasks:
In TrueSight Capacity Optimization, you can use the SQL-based data mart to perform the following tasks:
Build an advanced report template Workflow for using SQL-based data mart to build an advanced report template
Workflow for using SQL-based data mart to build an advanced report template
Build a Capacity View in TrueSight console Workflow for using SQL-based data mart to build a custom view in the TrueSight console
Workflow for using SQL-based data mart to build a custom view in the TrueSight console
A SQL-based data mart can be populated: