Maintenance outage for upgrade on Sunday, September 22

This site, docs.bmc.com, will be inaccessible for two hours starting at 9 AM CDT, Sunday, September 22, for a platform upgrade.

    Page tree
    Skip to end of metadata
    Go to start of metadata

    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

    For more details, see Types of data marts.

    You can configure SQL statements as SQL Data marts.

    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 use the custom data mart for existing views without editing the data mart.

    This topic explains:

    To view data marts

    Select Administration > ADVANCED REPORTING > Data marts.
    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 or delete 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.
    Physical nameIndicates the physical name of the data mart.
    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.

    To edit or delete a custom data mart

    You can edit or delete a custom data mart. You cannot modify or delete an out-of-the-box 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.

    1. In the TrueSight Capacity Optimization Console, select Administration > ADVANCED REPORTING > Data marts > datamartName.
      The datamartName page is displayed.
    2. 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.