Grouping Rules
- Becky Weinberg (Unlicensed)
- Pamela Totas (Deactivated)
Grouping Rules determine how data in a report is organized. The way in which data is organized determines the subtotals that are presented in a report. There are four different types of grouping rules described in this section: Simple, Range, Filters, and Classification. You can mix and match these rules, but you can only have one classification rule at a time.
Simple Grouping Rules
Simple grouping rules organize data based on one or more fields, usually character fields. For example, use a simple grouping rule to subtotal by state, country, or investment type. The list of available simple grouping rules is the list of available fields for a report. You can add multiple levels of grouping rules. You create simple grouping rules in the context of a report in Build Reports Mode, or a report rule in Build Components Mode. Unlike other grouping rules they are not stand-alone rules.
Complete the following procedure to add a simple grouping level to a report.
Select the New Group menu in the workspace.
Click Expand next to the Simple folder to view the available field attributes you can use as simple grouping levels. Use the filter to display all field attributes, or just the field attributes that you own.
You see the Simple Grouping Rule Options.Select the field attributes you want to use as simple grouping levels.
Range Grouping Rules
Use range grouping rules to organize data based on ranges in a particular field. The interval of each range is considered a group. A range group is used with numeric or date fields. For example, you can define coupon ranges as Low (0–6) Medium (6–9) and High (above 9).
You create range grouping rules in the workspace as part of a report or report rule, or on the Rule tab when working in Build Components Mode. The following procedure describes how to create a transaction report that groups a year’s transactions by month. You can also group by year or by month and year.
Open the New Range Grouping Rule dialog box.
You see the New Range Grouping Rules dialog box.Complete the options on the New Range Grouping Rule dialog box.
Click OK to save your changes.
Securities that do not fit into any of the range categories are placed in an Unknown bucket. For example, Regression Sec000001 Security does not have a value for Coupon and is grouped as Unknown.
Classification Rules
Classifications (Dictionaries) organize data by placing multiple values into a single group. Instead of organizing the data based on each value in a particular field, a classification places several selected values together to create a category. Use classifications to categorize information into groups that you define. For example, to classify securities based on the region in which the company is offering them, you could classify the securities by continent.
Classifications require codes with the source of Eagle PACE. In the following example, a code is created called Region with code values of North America, South America, Europe, Africa, Asia, and Australia for the long descriptions. The short description must be numerical. You must create the classifications under the Dictionaries module.
Once you have created a classification, you can add it to a report or a report rule via the workspace.
Classifications have some limits. For example, if you have a sort criteria in the grouping rule, you cannot sort on classifications. With classifications, an ascending sort is done for all the levels based on the DICTIONARY_ITEM_ID from the dictionary Detail table in the Rules database. Classification fields allow you to group the report on these fields instead of the entire dictionary and set a sort order for each of the levels.
You can create classifications from both the Maintenance Module and from General Reporting. In the General Reporting module, Define Classification is located in the Grouping Rule component. Creating and editing dictionaries in the Client Reporting module allows you to use the system more efficiently when creating dictionaries while configuring a grouping rule.
Filter Rules
A filter organizes data so that only the values that meet a specified criteria are displayed. You apply a filter at runtime to a report or report rule. You can use any field attributes with filter rules. You create filter rules from the workspace of a report or report rule, or on the Components tab as a stand-alone rule. You create new filters on the New Filter Grouping Rule dialog box.
The following example shows example specifies that only entities with Market Value > 20,000 be displayed in the report.
Use Filters to Compare Database Fields
You can create a filter on the Editing Filter Grouping Rules dialog box that compares two database fields. For example, you can create a filter that shows holdings where Effective Date < Update Date.
Complete the fields on this dialog box as follows:
Option | Description |
Name | Enter a name for the filter. |
Title | Enter a description of what the filter does. |
Formula | Insert the formula used in the filter to compare database fields. |
Grouping Options
There are five grouping options you can apply to grouping levels. Access the grouping options by using the arrow button on the workspace. Click the button to open and close the grouping.
Grouping options include:
Sort. Sorts the grouping levels in ascending, descending, or default order.
Override Source. Overrides the grouping sources for price and analytic grouping fields.
Percent. Allows you to choose at what level the percentages in a report totals 100Â percent. In the example in Figure 72, Market Value Sum could be totaled to 100Â percent at either the coupon or the investment type level. The highlighted cell corresponds to the percentage calculation being performed at the coupon level. Highlight the appropriate cell and click Add Percent to add a percentage calculations at that level. This option can only be applied to percent rollup fields.
Ranking Filter. Use the ranking filter to designate selection criteria for a report. This selection criteria determines which securities to include in your report based on values in a chosen field. You can choose to view a specific number of securities, or a certain percentage of the total number of securities. For example, you can choose to display the top 3 securities in each fund based on market value, or the top 10 percent of the securities. Apply this filter to the entire report. Applies the filter to the entire report across all entities. If it is not selected, the filter is applied separately for each entity.
Recalculate rollups after filtering. Recalculates any rollup fields in your report to display new totals that represent which securities are displayed in the report. If you do not select this value, the original rollup values is displayed in the report even if these values have changed.
Hide Filter. This option is only available if a filter rule is included in the report rule. Normally, when a filter is added to a report, the title that describes the filter is also displayed. The title can help you understand the grouping schema added to the report. Hide Filter hides the description of the filter at runtime. You can opt to hide the title, but still apply the filter, by selecting Hide Guideline.