ALM Report Parameters

You can adjust parameters for Asset Liability Management (ALM) reports. Some parameters are report-specific while others apply to all reports.

As you work through the parameters, earlier selections sometimes determine which parameters are available later.

The parameters that appear with an ALM report can include:

Accounts

Select the accounts that appear in the report. Select All to show the full account list. Then, use Expand to expand the subtotal lists so that you can select specific groups of accounts. Use Collapse to collapse the subtotal lists.

Account Templates

Select a template from the list to select accounts automatically. Select Setup to modify the selected template.

Data

Select Contractual or Forecasted to determine the type of data to use in the report.

Data Value

Select whether the report data is Cumulative, YTD, or MTD. The available options depend on the report that you are creating.

Layout and Formatting

Select options in this section to customize the look and feel of your reports. Customizations include page and row formatting, suppressing zeros, amount and decimal place formatting, and font size.

Organization

Select the check boxes for the organizations that you want to include in the report. Only those organizations that you are permitted to access appear in the list.

Recipients

Select the names of the users who can receive a copy of the report from the provided Recipients list. You can send the current report to other users of the application via email.

Note: You cannot clear the name of the active user.

Report File Type

Select the output format for the report. For most reports, the choices are Excel and PDF. Some reports also offer delimited options such as Comma Delimited, Semicolon Delimited, or Fixed Column Width.

Save as Favorite

Select the check box and provide a name for the favorite if you want to generate the same report again without redefining the parameters.

Scenario

Select a scenario to run the report data against.

Share With

Select each user that you want to share the report with, and indicate whether the users have Read Only or Editable access to the shared favorite report. This parameter appears when you select the Save as Favorite check box.

Show Value As

Select whether the report data is shown as Actual, Change From Flat, or % Change From Flat.

Time Frame

Select the Time Frame field to open a calendar showing the months that you can select for the current report. Each time frame is assigned a color:

• = Historical Month
• = Current Month
• = Forecast Month

You can also specify whether the selected months are Floating or Fixed depending on the report. By default, the current month appears as a Floating time frame.

What If Model

Select the What If Model that the report data is pulled from.

After defining all the report parameters, you are ready to generate the report. You can generate the current standard report now, if needed. You can also save the selected parameters, and then generate the report as a favorite.