SAP Netweaver Business Intelligence BI / BW

Symptom

See the collective note 1404885

Solution

Balance Processing
Merge scenario
1. In the IMG activity Bank Analyzer -> Balance Analyzer -> Before Generation -> Objects -> Balance Object -> Edit Characteristics and Key Figures, assign the characteristic /BA1/C69FVLEVL to the BSO types of BSO category OTHER_2 subject to the fair value disclosures.2. In the IMG activity Bank Analyzer -> Balance Analyzer -> Before Generation -> Objects -> Balance Object -> Edit Characteristics and Key Figures, assign the characteristic representing the types of movement in the fair value reconciliation report (movement type) to the BSO types for BSO category CURR subject to the fair value disclosures. These types of movement can either be depicted by adding new values to an existing characteristic representing the movements, or by introducing a new characteristic.3. If a new characteristic is introduced for the type of movement, you also need to make sure that this is included in the posting rules customizing for movement types4. In the IMG activity Bank Analyzer -> Balance Analyzer -> Before Generation -> Objects -> Start Generation, start the balance object generation.5. In the IMG activity Bank Analyzer -> Balance Analyzer -> Before Generation -> Balance Processing -> Characteristic Structure of Financial Statement Items -> Edit Characteristic Structures for Financial Statement Items, add the characteristics mentioned in the first two items to the relevant BSO types and activate the characteristic structure.6. In the IMG activity Bank Analyzer -> Balance Analyzer -> Financial Statement Items -> Determination of Financial Statement Items -> Edit Transfer Rules, create a new transfer rule for the inclusion of the two characteristics mentioned above in the financial statement item data.7. In the IMG activity Bank Analyzer -> Balance Analyzer -> After Generation -> Balance Processing -> Transfer of Balances -> Edit Secondary Data Source for Balance Transfer, retrieve the level information for the relevant products from the generic market data (see note 1412058). To do this, include the fair value key figure
&69FVLEV and the fair value characteristic /BA1/C69FVLEVL as output fields in the relevant environment version. For the relevant modules, insert a step to access the primary data source for the generic market data in the step sequence. Introduce a condition with IF and ELSEIF substeps to query the key figure value of the key figure characteristic value &69FVLEV (eg [O]/BA1/K69FVLEV = ‘1′). For each IF, ELSEIF statement, introduce a constant to map the key figure value to the equivalent characteristic value of the characteristic /BA1/C69FVLEVL.8. In the IMG activity Bank Analyzer -> Balance Analyzer -> Before Generation -> Balance Processing -> Data Retrieval for Reporting -> Activate Transport Structure, reactivate your transport structure for the balance processing data extraction

Subledger Scenario

9. In the IMG activity Bank Analyzer -> Analytics -> Financial Statement Preparation -> Balance Objects Manager -> Edit Characteristics and Key Figures, assign the characteristic /BA1/C69FVLEVL to the BSO types of BSO category OTHER_2 subject to the fair value disclosures.10. In the IMG activity Bank Analyzer -> Analytics -> Financial Statement Preparation -> Aggregated Transactions -> Edit Characteristics, add the characteristic for the fair value level and if required, the new characteristic for the type of movement to the Characteristics for Aggregated Transactions, and start the generation of AT Customizing11. In the IMG activity Bank Analyzer -> Infrastructure -> Communication and Worklist Services -> Data Sources -> Primary Data Sources, select the primary data source relevant for the aggregated transactions and assign the two characteristics mentioned above to it. Activate your primary data source.12. In the IMG activity Bank Analyzer -> Analytics -> Financial Statement Preparation -> After Generation -> Balance Processing -> Transfer of Balances -> Balance Transfer from the SDL -> Balance Transfer from the SDL, retrieve the level information for the relevant products from the generic market data (see note 1412058). To do this, include the fair value key figure
&69FVLEV and the fair value characteristic /BA1/C69FVLEVL as output fields in the relevant environment version. For the relevant modules, insert a step to access the primary data source for the generic market data in the step sequence. Introduce a condition with IF and ELSEIF substeps to query the key figure value of the key figure characteristic value &69FVLEV (eg [O]/BA1/K69FVLEV = ‘1′). For each IF, ELSEIF statement, introduce a constant to map the key figure value to the equivalent characteristic value of the characteristic /BA1/C69FVLEVL.13. In the IMG activity Bank Analyzer -> Infrastructure -> Communication and Worklist Services -> Data Sources -> Primary Data Sources, select the primary data source relevant for the extraction of the aggregated tranactions and assign the two characteristics mentioned above to it. Activate your primary data source.14. In the IMG activity Bank Analyzer -> Infrastructure -> Extraction and Reporting Services -> Generic BI Data Extraction -> Edit Generic BI Data Extraction, regenerate the datasource related to the extraction of the aggregated transactions

BW and Reporting.
IFRS 7.27b requires a disclosure of level transfers presented in tabular format.
The level transfers are to be presented in the Notes to show
- Transfers from level 1 – 2
- Transfers into and out of level 3 (Reconciliation of level 3)
The level transfers are determined in BW based on the Fair Value 32 financial statement item.
For this there is no content delivered in BW, but in the following we describe how one might proceed
As the financial statment item does not contains information of the level transfers this has to be determined and persisted in BW by period.
In the Cube “BA Notes” (0BA_FDC02) the following new Info Objects have to be added:
Delivered by the data source (*_BA1_B2_S_TRANS):
/BA1/C69FVLEVL
Key figures to store level transfers (e.g.):
XBA_LEV1
XBA_LEV2
XBA_LEV3
The determination then can be done in the “End Routine” of the transformation between the cube “BA Notes” (0BA_FDC02) and the data source which delivers the level information (*_BA1_B2_S_TRANS).
In the “End Routine” the level information of the previous period can be read with the function module “RSDRI_INFOPROV_READ”. See an example of calling this function module in the report “RSDRI_INFOPROV_READ_DEMO”.
If case of level transfer into level 1 (/BA1/C69FVLEVL) the level key figure (0BA_1KFSBIL) is added to XBA_LEV1 and subtracted depending on the level of the previous period for XBA_LEV2 or XBA_LEV3. A positive value could represent a level transfer into a level and a negative value could represent a level transfer out of a level.
For transfers into level 2 and level 3 the similar procedure is to be used. The level transfers for the period then contains the level changes compared to the previous period.
To build a query containing fields from the cubes “Balance Sheet and Profit and Loss Statement” (0BA_FDC01) and “BA Notes” (0BA_FDC02), a new multiprovider should be implemented on which the query should be defined.
To show the level transfers in the query the following two steps are to be done.
E.g. for level 1:
” First step is to define two calculated key figures for deciding if a transfer is into and out of a level. For a transfer into a level the formula for the calculated key figure would be e.g.: XBA_LEV1_IN ~ “XBA_LEV1 > 0″ and out of a level the formula would be : XBA_LEV1_OUT ~ “XBA_LEV1 < 0″.
” In the second step two new calculated key figures also are defined containing “transfer into” and “transfers out of” for this level (here level 1). These key figures use the first ones in their formula to calculate “transfer into”: XBA_LEV1 * XBA_LEV1_IN and for “transfer out of”: XBA_LEV1 * XBA_LEV1_OUT.
In the same manner key figures for level 2 and level 3 can be defined.
To show the movements (Purchases, issues ect.) within the reconciliation report (see the example for the sub ledger scenario in the attachment of the collective note) a restricted key figure can be defined on the key figure 0BA_1KFSOBJ with the desired restriction of the characteristic 0BA_1MOVT (BA Flow Type) or a similar characteristic used by the bank for this purpose.