Types of data marts

Analysis/Model data marts

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:

• Rename columns using more appropriate labels.
• Display only the statistics of interest.
• Define table indexes to speed up data access.
• Grant access to selected database users or roles.

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

• By a Materializer Task that creates and populates a table with the results of the specified analysis or model. You can schedule this task.
• By using the Analysis/Model data mart to create a SQL-based data mart and materializing the SQL based data mart. When the SQL-based data mart is materialized, the data from associated Analysis/Model Data Marts is also loaded and, if necessary, materialized.

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.

SQL-based data marts

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:

• Rename columns using more appropriate labels
• Select only the data series, metrics, and statistics of interest
• Group results
• Grant access to the data warehouse to an external reporting tool

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

  

• Build a Capacity View in TrueSight console

  Workflow for using SQL-based data mart to build a custom view in the TrueSight console

  

• Build an advanced report template and a Capacity View in TrueSight console

A SQL-based data mart can be populated:

• On-the-fly when the query is performed, which is the standard behavior.
• By a SQL-based data mart Materializer Task that creates a table and populates it with the content of the SQL data mart (hence called Materialized SQL data mart); the task runs according to a specific schedule.