Set Up Ledger Metadata
- Kavitha Thangaswamy (Unlicensed)
- Pamela Totas (Deactivated)
You can set up field attributes against the GL Detail Posting table using the Ledger Activity field attribute type. You can then build rollup, detail calculation, and inference fields against your Ledger Activity field attributes.
Set Up Ledger Activity Type Filters
First, you have to set up filters of the Ledger Activity type. For ledger based group level Data Mart models, access Grouping Rules in PACE Reporting and set up filters of the Ledger Activity type.
Use a single filter to define a single grouping of COA accounts that you can combine with other groupings to determine a level of grouping covering all COA accounts. For example, a very aggregate grouping level includes filters against COA accounts defining Assets, Liabilities, Capital, Income, and Expenses. You can then set up other filters to provide a second level of grouping more detailed than the first. You can set up more than one such grouping scheme.
The field GLAC_asset_liab_desc contains a COA group name such as "Asset" that you can use to build filters more quickly and easily than building them by listing all eligible COA accounts.
Set Up Ledger based Group Level Models
After building all the filters you need to group COA accounts for reporting purposes, you are ready to set up one or more group level Data Mart models to build ledger data in the Mart.
Because ledger reports concentrate on presenting activity and balance data grouped by ledger accounts, there is no need to support non-ledger data in group models containing ledger fields. You source report fields such as entity ID and entity name from the Fund Summary table. If you display ledger data alongside group level data of other types, you source that data from other group level tables and join the two in a report query.
You set up grouping level or levels for a group level model in the Grouping tab of the model. Use the Filters option on this tab to handle grouping by general ledger filters.
In general, you use filters to restrict data according to criteria. Each filter is defined independently, so it up to you to avoid unintended duplication of ledger accounts between filters.
The following example shows a filter that restricts ledger accounts to those against securities whose local currency is US dollar. This filter can serve as a top level grouping to support reporting of a subset of all ledger data, in this case data for dollar assets. The Data Mart's ability to support this granularity in data selection is based upon the fact that there is granularity in the GL Detail Posting table down to the security level. Note, however, that security level ledger data is still an aggregation of the original individual ledger postings.
Finished Level 1 Filter based on US Currency shows the selected filter as a first grouping level based on ledger filters. The system names all filter groupings as Level N Filter, where N is the level number.
Choosing Several Filters as a Second-level Grouping shows a set of filters built for a more typical ledger grouping level. When you select filters for a new filter grouping, the filters you used for any prior grouping are not available for selection.
The set of filters in Choosing Several Filters as a Second-level Grouping use a field attribute against the GLAC_asset_liab_desc field in the GL Detail Posting table to subdivide all COA accounts into a mutually exclusive set.
Finished Level 2 Filter, Plus Third Level Based on Simple Field shows this selected set of filters as a second level of grouping.
You can supplement filter based ledger groupings by additional levels of grouping based on Simple Fields (ledger or security type) and/or Range Rules. However, one or two levels of filters is generally enough for the majority of ledger reporting requirements.
Other aspects of model setup are similar to other types of group level model. You can filter data under the Filters/Mappings tab. Note that while the filter-based ledger groupings define membership of ledger accounts in groups, the filters you set up in Filters/Mappings exist to eliminate selected ledger accounts from reporting altogether, based upon their characteristics or characteristics of the securities whose activity and balances they record.
After you build a model that contains filter based groups, you can view the underlying filters, but you can no longer change your choice of filters.