Versions Compared

Key

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

By default, Data Mart stores a single point in time snapshot of your business data based on a single source rule. This data is periodically refreshed from Eagle's data warehouse during the submit process. See Submit a Model Models as Ad Hoc for details.

You can create multiple snapshots of your Mart data, each one using data sources that are relevant to one or more business purposes. For example, suppose your organization runs a pension fund. You can create a 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 basis. These different perspectives must exist as different data sources in your data warehouse.

...

  1. In Reporting Center, from the left navigation, select Reporting Tools  >  Datamart  >  Manage Marts  >   Data Mart. 
    You see the Data Mart windowworkspace.
  2. Click Snapshots.
    You see the Snapshots dialog box. 
  3. Click Add Snapshot.
    You see the Snapshot Definition dialog box as shown in the following figure.
  4. In the Name box, provide the name up to 10 characters for the snapshot. This name appears in the FUND_MASTER table as the Snapshot ID after you build data for the snapshot.
  5. In the Description box, provide a description about the snapshot.
  6. Click Source Rule dropdown to determine the source rule to use.
    Select <default> if you want to use the source rule set up in the Configuration tab. If you want to use a different source rule to support another perspective on your data, choose another source rule from the list.
  7. Click Business Calendar dropdown to determine the business calendar to use when you submit the Business Dates model for this snapshot to update the Business Dates table.
  8. In the Comments box, provide a descriptive comments about the snapshot, if any.
  9. Complete the fields on the Snapshot Definition dialog box and click OK to save your changes.