.
Contents
About Data Mart
Analyze Your Reporting Requirements
Create Models
Group Models
Fund Summary Models
Detail Models
Submit Models
Create Snapshots of Your Data
View Process Logs
View Data in the Data Mart
Navigate Data Mart
Access Data Mart
Work with Manage Mart Window
Configure Data Mart
Before You Begin
Configure the Data Mart Environment
Select Configuration Options
Work with Security and Entity History
Using Entity History
Build Security Information
Run Diagnostics
Select Diagnostics Options
Create and Edit Model
Add a Group Model
Add a Group to a Group Model
Add Fields to a Group Model
Define Performance Report Options
Delete a Group Model
Configure the Fund Summary Model
Configure the Detail Model
Edit Group, Fund Summary, and Detail Model
Work with Table Column Changes
Work with Mart Model
About Model Extensions
Add an Extension
Add Extensions to Existing Tables
Create Multiple Snapshots of Your Data
Add a Snapshot
Submit a Model as Ad Hoc
Select Options in Data Mart Model Submission Dialog
Work with the Fields Selection Dialog Box
Prevent Deadlocks in SQL Server Databases
About Date Rules
About Build Selective Fields
Build and Use Business Dates Tables
Business Dates Table Fields
About Business Dates Table
Set Up the Business Dates Table
Build the Business Dates Table
Execution Logs and the Business Dates Table
View Mart Data for the Business Dates Table
Schedule Model Submissions
Add a Schedule
Copy a Schedule
Select Fields for a Schedule
Assign Models to a Build All Schedule
Clear a Data Mart Job
Kill a Data Mart Date Range Submission
Cancel a Data Mart Job in Automation Center
Populate the Data Mart using Eagle Process Manager
Migrate Models and Extensions
Check Migrated Components
Exceptions when Migrating Model Elements
About Migrating Data Mart Field IDs
Migrate a Model
Migrate a Model with Firewalls
Migrate a Model with Extensions
Audit Changes to Mart Data
Archive Data Mart Tables
Work with the Execution and PACE AppServer Logs
Work with Execution Logs
About Execution History Tab
About Execution Status
View Log Details at the Model Manager Engine Level
View Log Details at the Concentration Engine Level
Refresh the Execution Log
Filter the Execution Log List
Purge Execution Logs
Download Execution Log Files
Data Mart Manager Engine Log
Model Manager Engine Log
OLAP Report Process Log
OLAP Process Results
Work with the Show Errors Window
Work with Application Server Log Files
View the Server Logs
Download All of the Server Log
Download Part of the Server Log
Email the Server Log File
View Content in Data Mart
Work with the View Mart Data Window
View Data
Refresh Data
Explode Data for All Groups
Export Data
Print Data***
Configure the Data on the View Mart Data Window
Manage Mart Data Status
Add External Data to the Mart
Build a Query for Mart Data
Build a Query for Data Viewed in the Data Mart
Build a Query for Data Not Viewed in the View Data Mart
Access Mart Data from PACE Advanced Reports
Multiple Data Marts
Work with Multiple Data Marts
Should You use Multiple Marts?
Advantages of Multiple Marts
Additional Mart Types
Set Up a New Mart Instance
Setup for Remote Marts Running from Solaris or Linux to SQL Server
Multiple Mart Specific Features
Register a New Instance
Register the Database Connection of the New Instance
Register a Mart Instance
User Access to Setup New Mart Instances
Manage Multiple Marts
One Field Attribute per Mart Column Name
Schedules and Event Packages
Migrate Mart Instances
Usage Option and Multiple Marts
Internal Mart Instance: EAGLEMART
How an Internal Mart Works
Understand Copy Model
Run Copy Model
Rules to Copy Fields
Table Name
Field Attribute ID
Copy a New Group-Level Model
Modify Field and Copy Model
Migration Wizard
What does Migration Wizard Migrate?
Migration Best Practices
Consistency of Model, Extension and Field IDs
Migrate to Add New Content to Existing Models
Migrate in Environments with Multiple Marts
Run Migration Wizard for Data Mart
Start Migration in the Data Mart
Outbound Migration
Inbound Migration
Migration Conflicts
Duplications
Grouping Field Column Names
Inconsistencies
Conflicts beyond Online Correction
Data Mart and Multilingual
Build Multilingual Data in the Mart
Load Local-Language Data for Use by Data Mart
Languages Table
Load Entity Data
Load Security Data
Load Meta Data Text and Code Values
Field Attributes for Multilingual Text
Data Mart Multilingual Configuration
Enable a Mart Schema for Local Languages
Language Selection in Models
Convert an Existing Data Mart
Guidelines to Configure Models
Define Groups
Valid Field Type and Group Combinations
Select Fields
Time Series Fields
Classification Field attribute
Aggregation Level
Data Type
Supported Performance Fields
Fields Supported with Restrictions
Look through Grouping Fields
Unsupported Fields
Character Fields
Select Performance Dictionaries for the Fund Summary and Detail Models
Support One Performance Dictionary per Fund Summary Extension
Roll Up Performance Data in Reporting Tools
Filter Data Using Screening Rules
Select Security Rollup Fields
Composite Entities
Reporting Ledger Data from Eagle Accounting
Ledger Data Sourced from STAR
Ledger Data Requirements for Data Mart
Set Up Ledger Metadata
Set Up Ledger Activity Type Filters
Set Up Ledger based Group Level Models
Look Through Analysis in Data Mart
How does Look Through Work?
Look Through Processing Notes
Look Through Before V11.0
Data Mart Look Through
Set Up Look Through for the Mart
Map Securities
Load Data to POSITION_DETAIL Table
Set Up Holdings Field Attributes with Look through Property
Position Look Through Details Model
Group Level Look Through Model
Performance Fields in Data Mart Group Models
Look Through in the Data Mart Fund Summary Model
Building Data for Issuers and Counterparties
[ |_Toc534679311]
How Issuer Data Worked Pre V11.0
Mart Issuer Details in the Pre V11.0 Issuer Data Model
Build a Field Attribute to Navigate Multiple Rows
Simplify Reporting of Issuer Data Services
Minimize the Number of Issuer Detail Rows
Display Multiple Issuer Roles as Issuer Details Model Columns
About Role Type Field Attributes
Counterparty Exposure Reporting in Data Mart
Peer Group Reporting
Peer Group Data and Data Relationships
Fund Ratings
Fund Analytics
Peer Group Analytics
Fund Peer Group Rankings
Peer Group Internal Codes
Entity Maintenance
Set Up a Peer Group Entity****
Fund - Peer Group Association
OLAP Support - Entity Analytics Source Rule***
Entity Analytics Field Attributes ***
Create a New Entity Membership Field Attribute****
Create an OLAP Report
Peer Group Data in Data Mart
Migration Wizard Support
Entity Analytics Fields for Other Uses
0 Comments