Strategy One

Convert a Report Into a Datamart Object

A data mart is a data repository where you store the results of a report as a relational table in a data warehouse. After creating a data mart, you can use it as a source table in your projects, and execute reports against it. You can use data marts for the following applications:

  • Create aggregate fact tables to improve the performance of reports that have summarized data.

  • Create tables for use by other applications, such as Microsoft Access.

  • Create tables for off-line analysis using direct SQL queries.

Before you can create a data mart table, you need to create a data mart report. You can convert an existing report, as described below, or use Admin & Modeling to create a new datamart from scratch.

  1. In Library, edit the report to convert into a datamart object.

  2. In the upper-right corner of the Report Editor, click Create Datamart to convert the report into a datamart object.

  3. At the prompt, click Yes to automatically create the datamart. The following steps are taken:

    • The view template and view filter are cleared.

    • Sorting, drill map, thresholds, subtotals, and derived elements are cleared from the data template.

    • All attributes are moved to the report rows.

    • All metrics are moved to the report columns.

    • A local copy of the stand-alone template is created.

    A new Object Editor displays for the datamart with all attributes and metrics transferred from the original report. The datamart is automatically named ReportName-datamart. The Object Editor opens in a new browser tab in Admin & Modeling.

  4. Define the data mart, including the datamart properties such as evaluation order and table generation settings. For details, see Create a Datamart Object.

  5. Click Save .