Analyze Your Reporting Requirements
Anchor |
---|
| _Analyzing_Your_Reporting |
---|
| _Analyzing_Your_Reporting |
---|
|
Anchor |
---|
| RTF38363732363a204865616469 |
---|
| RTF38363732363a204865616469 |
---|
|
Anchor |
---|
| _Toc534679117 |
---|
| _Toc534679117 |
---|
|
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 ModelsGroup, 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 |
---|
| RTF34303033383a204669677572 |
---|
| RTF34303033383a204669677572 |
---|
|
Anchor |
---|
| _Toc534679119 |
---|
| _Toc534679119 |
---|
|
Group ModelsGroup 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 ModelsThe 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 ModelsDetail 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 ModelsWhen 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:
...
Since OLAP reports are specialized by field type, such as position, performance, or transaction, it may take four or more OLAP reports to provide the necessary fields for a fund level or group level table. You have the option of defining table extensions for the Fund Summary and Detail models. A table extension stores a subset of the model's fields in a separate physical table that has a key structure identical to the main table, but is populated by its own OLAP reports.
Anchor |
---|
| _Creating_Snapshots_of |
---|
| _Creating_Snapshots_of |
---|
|
Anchor |
---|
| RTF35323638373a204865616469 |
---|
| RTF35323638373a204865616469 |
---|
|
Anchor |
---|
| _Toc534679123 |
---|
| _Toc534679123 |
---|
|
Create Snapshots of Your DataBy default, Data Mart builds one daily version of your business information according to a single data source hierarchy known as a source rule in PACE. With Data Mart's snapshot feature, you can build and save your information more than once per day, and use more than once source rule in the build process. For example, suppose your organization runs a pension fund, and you maintain both a custodian source and a manager source of the same accounting data.
You can create one snapshot that looks at fund activity from a custodian's view point and another snapshot that looks at fund activity from a manager's view point. You can also use snapshots to report on the same portfolios in different accounting bases. Separate snapshots can also save separate builds done at different times of the day, allowing you to make intra-day comparisons of data values.
Anchor |
---|
| _Viewing_Processing_Logs |
---|
| _Viewing_Processing_Logs |
---|
|
Anchor |
---|
| RTF35333032343a204865616469 |
---|
| RTF35333032343a204865616469 |
---|
|
Anchor |
---|
| _Toc534679124 |
---|
| _Toc534679124 |
---|
|
View Process LogsExecution logs provide information on scheduled and ad hoc (manual) model submissions.
...
The PACE Application Server Log provides information about the application server on which Data Mart processes are executed.
Anchor |
---|
| _Viewing_Data_in |
---|
| _Viewing_Data_in |
---|
|
Anchor |
---|
| RTF38323038353a204865616469 |
---|
| RTF38323038353a204865616469 |
---|
|
Anchor |
---|
| _Toc534679125 |
---|
| _Toc534679125 |
---|
|
View Data in the Data MartYou can also view the contents of Data Mart tables, refresh data changes, explode group levels, and export, print, and configure data columns on a number of windows.
...