Analyze Your Reporting Requirements

A well-built Data Mart starts with an analysis of your reporting requirements. This means taking a complete inventory of the data you want in your Data Mart at the group, fund, and detail portfolio levels.

Anchor
_Creating_Models _Creating_Models

Anchor
RTF33383432393a204865616469 RTF33383432393a204865616469

Anchor
_Toc534679118 _Toc534679118

Create Models

Group, Fund Summary, and Detail models define how to populate the group, fund, and detail level tables in Data Mart for reporting purposes. The following figure illustrates how Data Mart displays data stored at the group, fund, and detail portfolio levels.

Anchor
_Toc534679119 _Toc534679119

Group Models

Group models define group level data, such as the Technology and Energy sectors and the partially aggregated fund totals for each sector as shown in the previous figure.

...

Data Mart stores group level data in the group tables in the Data Mart schema. Table names are user assigned.

Anchor
_Toc534679120 _Toc534679120

Fund Summary Models

The Fund Summary model defines fund level (entity) data, such as the fund name, manager name, and fully aggregated fund totals as shown in previous figure.

...

Data Mart stores fund level data in the Fund Summary table in a mart schema.

Anchor
_Toc534679121 _Toc534679121

Detail Models

Detail models define detail level data, such as the name of each security, book value, and market value shown in the previous figure. Data Mart provides the following Detail models:

...

A Data Mart schema also contains the Fund Master table, which defines the Entity and Effective Date of each table row. The system identifies the unique combination of Entity ID and Effective Date as the Data Mart Fund ID.

Anchor
_Submitting_Models _Submitting_Models

Anchor
RTF31323839313a204865616469 RTF31323839313a204865616469

Anchor
_Toc534679122 _Toc534679122

Submit Models

When you submit a model, the Data Mart engines launch one or more OLAP (online analytical processing) processes based on the type of fields in the model. For example, if you submit a model that contains performance fields, the Data Mart engines would generate a performance analysis OLAP process that provided a number of field values, such as the following:

...