Managing data marts for custom views, reports, and report templates



A data mart is a subset of the data warehouse that is usually oriented to a specific business line or team. Data marts can be used to prepare data for a custom view or report. They 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.

TrueSight Capacity Optimization provides the following types of data marts:

  • Analysis/Models data marts
  • SQL-based data marts

You can configure SQL statements as SQL Data marts.

To access the Data marts page, click Administration > ADVANCED REPORTING > Data marts. The Data marts page is displayed.

The Data mart page lists the Out-of-the box and custom data marts and data mart templates available in the system. You can filter the data marts according to the type of data mart. In addition, you can add or edit custom data marts, or materialize data marts from this page.

Data marts table

FieldDescription
IdIndicates the ID of the data mart.
Name

Indicates the name of either one of the following:

  • Data mart: Click to view the datamartName page, which shows the SQL code of the SQL data mart. You can edit, delete, or export the data mart from this page.
  • Data mart template: Click to access the datamartemplateName page, which shows the dynamic SQL code of the template. You can edit or delete the data mart template from this page.
Identifier

Indicates the unique identifier associated with the data mart. This identifier can be used in the SQL query while creating dependent data marts.  

This field is available only when you apply Service Pack 1 (11.5.01) of TrueSight Capacity Optimization 11.5.

DescriptionIndicates the description of the data mart.
TypeIndicates the type of the data mart.
Creation DateIndicates the creation date of the data mart.
PackageIndicates whether the data mart is out-of-the-box or custom.

Note

  • Many of the OOTB views in the TrueSight Capacity Optimization define their own Data marts. These Data marts are subject to change; you should not depend on them for custom views and reports. You can copy the SQL statements and reuse them.
  • If you were using custom data mart, edit the custom data mart after you upgrade to use that data mart for building a new custom view or an new advanced report template. You can continue to use the custom data mart for existing views without editing the data mart.

To add a custom data mart

You can create custom data marts that are SQL-based and analysis and model data marts.

  1. Log in to the TrueSight Capacity Optimization console.
  2. Select Administration > ADVANCED REPORTING > Data marts. The Data marts page is displayed. 
  3. To create a data mart, see the following topics:

To edit or delete a custom data mart

You can edit or delete a custom data mart only if your user role is assigned the activity to modify a data mart. For more details, see Adding and managing roles.

You cannot modify or delete an out-of-the-box data mart. 

  1. Log in to the TrueSight Capacity Optimization console.
  2. Select Administration > ADVANCED REPORTING > Data marts > datamartName.
  3. The datamartName page is displayed. It displays the name, type, identifier, and description of the data mart. It also displays parent or dependent data marts, if any.
  4. Click or to edit or delete the required data mart.
    Steps for editing a data mart are same as the steps for adding a data mart. For more details about editing data marts, see the following topics:

To materialize a SQL-based data mart

You can materialize a data mart. The frequency of materialization of the data mart depends on the associated task. For more details, see Configuring the Data Mart Materializer task. You can materialize a data mart only if your user role is assigned the activity to materialize a data mart. For more details, see Adding and managing roles.

Note

You cannot materialize SQL data mart templates.

  1. In the TrueSight Capacity Optimization Console, select Administration > ADVANCED REPORTING > Data marts > datamartName.
    The datamartName page is displayed.
  2. Click .
    OR
    Click the name of data mart, and on the data mart details page, click Materialize now.

To export and import custom data marts

You can export and import custom data marts and reuse them in multiple environments of TrueSight Capacity Optimization, without having to recreate them. For example, if you have created a custom data mart in the development or test environment and after confirming that the results are accurate, you can export this data mart as a data mart package file. This package file can then be imported in the production environment. 

The option to export and import custom data marts are available only when you apply Service Pack 1 (11.5.01) of TrueSight Capacity Optimization 11.5.

If the selected data mart is using any data marts or being used in other data marts, all these data marts, that is, the entire hierarchy tree gets exported and hence can be imported in the destination environment. 

You can not export or import out-of-the-box data marts. 

To export a data mart

  1. Log in to the TrueSight Capacity Optimization console.
  2. Select Administration > ADVANCED REPORTING > Data marts. The Data marts page is displayed. 
  3. Click the required custom data mart, and click Export. Select the location to save the exported data mart. 
    The data mart is exported as the data mart package file. The file extension for the package file is .dpkg. 

To import a data mart

  1. Log in to the TrueSight Capacity Optimization console.
  2. Select Administration > ADVANCED REPORTING > Data marts. The Data marts page is displayed. 
  3. Click Import data mart package. The Import data mart package page is displayed. 
  4. Click Browse to select the data mart package file (.dpkg) that you want to import. 
  5. Click Upload

If your destination environment includes any data marts with the same identifier as one of the data marts being imported, the existing data marts are updated by the imported data marts. A message is displayed indicating the same. You can choose to Proceed or Cancel the import. 
All imported data marts are listed in the Data marts table. 

Example that shows the export/import flow

Consider that you have exported the VMware systems data mart with identifier as ER_V_VMWARE_SYS. This data mart has a related data mart as VMware hosts.

The destination environment contains the VMware VMs data mart with the identifier as ER_V_VMWARE_SYS.

After you import, the the VMware systems data mart overwrites the VMware VMs data mart as both have same identifiers. The related data mart, VMware hosts is linked to the VMware systems data mart.

In the following diagram, red text indicates data mart names and blue text indicates identifiers. 

Was this page helpful? Yes No Submitting... Thank you

Comments