Creating a summary data mart for a custom view or report

Using the new Summary Data Mart wizard, you can build a custom data mart to retrieve the data according to your requirements. This simple and easy-to-use wizard allows you to create data marts using the necessary metrics without requiring a knowledge of SQLs. This custom data mart can then be used in a custom view or report.

The Data Mart wizard guides you through the creation of a data mart:

• Select the type of content to be displayed by the data mart
• Select the primary entity of the data mart
• Select the required metrics
• Configure the time filter to be displayed 

For example, using the Add Summary Data Mart wizard, you can create a data mart that retrieves all the clusters that belong to your infrastructure. You can include the capacity metrics, such as CPU, memory, and storage utilization to have an idea of the status of the infrastructure capacity. You can also add a time filter to check the data utilization for a specific period. 

To understand the concept of data marts, how they can be useful, and for information on creating SQL-based data marts, see Managing-data-marts-for-custom-views-reports-and-report-templates.

Creating a summary data mart

1. Log on to the TrueSight console.
2. In the navigation pane, select Capacity > Views > Custom Views.
3. Access any custom view, click , and select Add Summary Data Mart. The Add Summary Data Mart wizard is displayed in a new page. 
   Alternatively, you can click Add Data Mart while creating a custom view using the Summary table template.
   
   
4. Select the type of content that you want to be displayed by the data mart. By default, System is selected.
   • Select Systems to list system types in the Select Entity Types page. 
   • Select Business Drivers to list business drivers types in the Select Entity Types page. 
5. Select the entity type to filter a list of metrics in the Metrics page corresponding to the selected entity type. If you select multiple entity types, metrics corresponding to all entity types are displayed.
6. Select the required metrics using which you want the data mart to be created. You can select the List the metrics from all Entity Types option to display all metrics irrespective of the entity types selected in the previous page. 

7. Select the time filter on which the data will be filtered.  You can select the time filter from the following available options:

   • Last 1 day / 7 days/ 30 days: Displays data for either last 1 day, 7 days, or 30 days excluding today.
   • Last time period: Enables you to define a custom time period. The data will be displayed according to this custom period. 
   • Global Time Filter: Displays a list of predefined time ranges that you can select from. For example, Last 180 days, Last 30 days, and so on.
   • Date range: Enables you to define a custom time range. Use the calendar to select the start and end dates for your custom time period. 
     
     

   
   
   

8. Specify a name and an optional description for your data mart. 

9. In the summary page, the following fields are displayed: 

   1. Data Mart Definition pane: Displays the preview of all options selected in the previous pages. You can choose to modify these values by clicking Back to Wizard. 
   2. Materialization Task pane: Displays the default materialization task of the data mart. If required, you can select another materialization task to change the frequency of materialization of the data mart in the associated view or report. 
   3. A table listing the data mart columns based on your selections in the Add Data Mart wizard. These columns will be displayed in the summary table of the associated view or report. The table provides the default values of labels, descriptions, and statistics for the columns. If required, you can edit these values by clicking the  icon. 

   

10. Click Finish. The message indicating that the data mart is created successfully is displayed. 
    The new data mart is added to the Data marts page in the TrueSight Capacity Optimization console. For details, see Managing-data-marts-for-custom-views-reports-and-report-templates.
    
    

You can now use this data mart while creating a custom view or creating a report in TrueSight Smart Reporting. For details on integrating with TrueSight Smart Reporting, see Integrating-with-TrueSight-Smart-Reporting.