Versions Compared

Old Version 2

changes.mady.by.user Pamela Totas

Saved on

compared with

New Version 3

changes.mady.by.user Pamela Totas

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

3. Configure Models to Populate Data Mart Entities. Edit the Data Mart models in the Default Mart to populate the models with entities, as follows

Data Mart ModelEdit Model to Assign Entities

Fund Summary

Select both the equity and fixed income LIST entities.

Performance Details

Select both the equity and fixed income LIST entities.

Perf By Asset Class MTD

Select both the equity and fixed income LIST entities.

Perf By Currency MTD

Select both the equity and fixed income LIST entities.

Perf By Long Short MTD

Select both the equity and fixed income LIST entities.

Perf By Region/Country MTD

Select both the equity and fixed income LIST entities.

Perf By GICS Sector/IndustryGroup/Industry/SubIndustry MTD

Select the equity LIST entity only.

Perf By Aggregate Bond L1/L2/L3/L4 MTD

Select the fixed income LIST entity only.

Fund Hierarchy By Plan/Composite/Entity

If using the Plan Performance Summary Report, edit the Fund Hierarchy By Plan/Composite/Entity Data Mart model and select the plan composite ACOM entity only.

4. Create Data Mart Schedules. Create the following Data Mart schedules from within Data Mart.

...

5. Configure Data Mart Schedules for Data Mart Models. Edit the Data Mart models to configure the Data Mart schedules, as described in the following table.

Data Mart ModelEdit Model to Configure Data Mart Schedule

Fund Summary

Enable the Daily Build Schedule and Monthly Build Schedule.

Select all the fields from the Fund Summary Extension for the Daily Build Schedule and Monthly Build Schedule.

Select all the fields from the Perf Total Summary Extension for the Daily Build Schedule and Monthly Build Schedule.

Select all the fields from the Perf Total Extended Extension for the Monthly Build Schedule only.

Performance Details

Enable the Daily Build Schedule and Monthly Build Schedule.

Select all the fields from the Performance Details Extension for the Daily Build Schedule and Monthly Build Schedule.

Select all the fields from the Perf Details MTD BF Extension for the Monthly Build Schedule only.

Security Details

Enable the Daily Build Schedule and Monthly Build Schedule.

Select all the fields from the model for the Daily Build Schedule and Monthly Build Schedule.

Perf By Asset Class MTD

Enable the Daily Build Schedule and Monthly Build Schedule.

Select all the fields from the model for the Daily Build Schedule and Monthly Build Schedule.

Perf By Currency MTD

Enable the Daily Build Schedule and Monthly Build Schedule.

Select all the fields from the model for the Daily Build Schedule and Monthly Build Schedule.

Perf By Long Short MTD

Enable the Daily Build Schedule and Monthly Build Schedule.

Select all the fields from the model for the Daily Build Schedule and Monthly Build Schedule.

Perf By Region/Country MTD

Enable the Daily Build Schedule and Monthly Build Schedule.

Select all the fields from the model for the Daily Build Schedule and Monthly Build Schedule.

Perf By GICS Sector/IndustryGroup/Industry/SubIndustry MTD

Enable the Daily Equity Build Schedule and Monthly Equity Build Schedule.

Select all the fields from the model for the Daily Equity Build Schedule and Monthly Equity Build Schedule.

Perf By Aggregate Bond L1/L2/L3/L4 MTD

Enable the Daily Fixed Income Build Schedule and Monthly Fixed Income Build Schedule.

Select all the fields from the model for the Daily Fixed Income Build Schedule and Monthly Fixed Income Build Schedule.

Fund Hierarchy By Plan/Composite/Entity

Enable the Monthly Build Schedule.

Select all the fields from the Fund Hierarchy By Plan/Composite/Entity model for the Monthly Build Schedule.

When you edit the Fund Summary and Performance Details models, be aware that you can sort by extension to group similar fields together.

6. Configure Data Mart Workflows. Complete the following tasks in Process Manager:

Create the following workflows:

  • Daily DM Workflow
  • Daily DM Equity Workflow
  • Daily DM Fixed Income Workflow
  • Monthly DM Workflow
  • Monthly DM Equity Workflow
  • Monthly DM Fixed Income Workflow

For each daily workflow:

In the Workflow Definition tab, when you set up date rules for each daily workflow, ensure that your date range is set to pass the current business day through to the profile if run for a non business date. Eagle recommends that you select a (first) date rule, select the Adjust Effective Dates using the Date Rule check box, and select a (second) adjuster date rule to apply the business calendar to both start and end dates.

...