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. |