Reporting Toolkit: Operation

Owned by Pamela Totas (Deactivated), created
Last updated: Jan 10, 2024
2 min read

Daily Operation

The daily operation for the Reporting Toolkit involves the following phases:

  • Daily Data Load

  • Daily Data Mart Build

Details of each phase follow:

Daily Data Load

  1. When using Eagle Performance for portfolio calculations, you have returns committed for every business day. The Calculation Toolkit describes this configuration. If you are not using Eagle Performance for portfolio returns, you need to load those portfolio returns every day.

  2. Index data must be loaded every business day to support benchmark relative analysis and reporting. The Index Toolkit describes this configuration.

  3. FX rates are required for analysis in alternate currencies, so daily FX Rates need to be loaded as well.

  4. Use the Data Steward Event Details windows and Message Center Console to see data load errors.

Daily Data Mart Build

  1. The Daily Data Mart workflows scheduled during the setup process run for every business day.

  2. Use the Data Steward Event Queue windows and Data Mart Execution Log to see errors.

  3. After the Data Mart builds are completed, all daily presentation reports and Portal queries should be available for Portal users.

Monthly Operation

The monthly operation for the Reporting Toolkit involves the following phases:

  • Monthly Data Load

  • Monthly Data Mart Build

Details of each phase follow:

Monthly Data Load

  1. When using Eagle Performance for portfolio calculations, you have returns committed for every calendar month end. The Calculation Toolkit describes this configuration. If you are not using Eagle Performance for portfolio returns, you need to load those portfolio returns every calendar month end.

  2. Index data must be loaded every month end to support benchmark relative analysis and reporting. The Index Toolkit describes this configuration.

  3. FX rates are required for analysis in alternate currencies, so calendar month end FX Rates need to be loaded as well.

  4. Use the Data Steward Event Details windows and Message Center Console to see data load errors.

 Monthly Data Mart Build

  1. The Daily Data Mart workflows scheduled during the setup process runs for every calendar month end.

  2. Use the Data Steward Event Queue windows and Data Mart Execution Log to see errors.

After the Data Mart builds are completed, all monthly presentation reports and Portal queries should be available for Portal users.