Process results differences

The following differences affect process-output storage, aggregation, financial elements, time buckets, and instrument-level output.

Table 11-4 Process results differences

Category ALM 8.x behavior ALM Cloud Service behavior
Aggregation Output is aggregated by Product, Product-Currency, or Product-Currency-Org Unit. Static Deterministic Process output is aggregated by multiple dimensions configured by the user. Dynamic Deterministic Process output is aggregated by members of the MDBSS configured by the user.
Result tables Separate tables are created for every process, for example RES_DTL_xxxxxx. A single table is used for all processes. Process ID is a column in the result table.
Result tables Separate tables are used for base currency, for example RES_DTL_xxxxxx, and reporting currency, for example CONS_DTL_xxxxxx. A single table stores both base currency, Consolidation flag = N, and reporting currency, Consolidation flag = Y, output.
Result tables The same table, for example RES_DTL_xxxxxx, stores output for Income Simulation, Repricing Gap, and Liquidity Gap. Separate tables are used for Income Simulation, Repricing Gap, and Liquidity Gap.
Result tables Only the latest execution output is stored in RES_DTL_xxxxxx and CONS_DTL_xxxxxx. Output from all executions and multiple As-of Dates is stored.
Financial elements Output is identified by financial element number in RES_DTL_xxxxxx and CONS_DTL_xxxxxx. Financial elements are stored in individual columns of the result table.
Time buckets RES_DTL_xxxxxx and CONS_DTL_xxxxxx have fixed 240 columns for time buckets. Each time bucket is stored as a row.
Instrument-level output Market Value, Yield, Duration, Modified Duration, DV01, and Effective Interest Rate of the first scenario are updated in instrument tables. Instrument tables are not updated with output. Instrument level results are stored in ALM Account Summary for all scenarios.
Forecast Balance - new business Detailed cash flow is not available. New business instruments and their cash flows, including Transaction Strategy, are stored when process output preferences are configured.