Remodelling Concept In Bi 7 Pdf
Concept of Re-evaluate agents for. Remodeling in SAP NW-BI 7.0 is applicable. Activating & restarts of the process chains once the remodelling is.
Author: Sourav Banerjee Author Bio: Sourav is currently working as a SAP BI consultant in IBM India Pvt Ltd. He has worked in different BI support/enhancement projects throughout his career. Why Remodeling?
Remodeling is a concept using which new characters and/or key figures can be added to cube. This concept however is not valid for the DSO/master data. The reason which necessitates remodeling is the requirement of historical data change without a data reload. Info cubes are like set of data base tables (F/E table, dimension tables and SID tables) grouped together.
Unlike DSO, cube stores a more summery level overview as there is no specific primary key. All characters in the dimension can be treated as key fields meaning that the records can be treated as unique entry as request ID becomes a key field (like change log table of a DSO). Presuming that a cube which stores millions of entries in a SAP landscape requires an addition of character. The normal way of doing it is to edit the cube and add the character to the dimension of your choice, this would however add the character with empty values for all historical data. If it is required to load that field’s value for all the historical data then we need to delete the entire content of the cube and then upload the data again assuming that the new data loading logic is already in place (inside transformation/update rule). Question is why would someone load all the dimension tables (i.e., loading the entire cube) when there is change in only one dimension (where the character is added).
This is where remodeling comes into picture which will convert only the dimension in question and all the dimension/fact tables will be remained as it was. While doing the remodeling the following operations are carried out by the system – 1. Deactivate the cube. Deactivate all the dependent BI objects like transformation, multiprovider, DTP etc. Convertire da youtube a mp3.
- Hi all,hope every body r doing well. Der is new concept call remodelling in the bi 7 version. Can any body send the advantages n step to folow in that processThanks KK.
- Export to PDF Community. Remodeling Tool in BI 7.0. Skip to end of metadata. I'm going to deal what are Features of the Remodeling Tool, Concept of.
This step is often referred as Impact. Run the remodeling rule – Add/remove the character/key figure to the specific dimension or to the key figure part. Run the rule to fill the dimension table (either direct or constant or exit). A database commit to update the field’s value to the dimension table i.e, altering the table. Activate the cube.
Please note that the remodeling process will not activate the transformation, multiprovider and DTP. The reason is that, when we add a new character to the cube, the rule in the transformation remains empty unless manually added. This is why SAP gives us a chance to review and update the transformation,MP etc rather than activating the dependent objects directly.
Caution: Whenever a new remodeling rule is created, it directly impacts the SAP report to update that cube. It is often found that while using remodeling if it fails, corrupts the backend program and therefore further remodeling on the same dimension becomes impossible.
The only way left then to reimport the cube from some other environment. Another common problem is that if the remodeling rule is created with a customer exit, there is no standard way to debug the code at runtime. Therefore we can only check the syntax but runtime analysis is not possible unless the actual remodeling rule is run. This is why very careful testing required prior to deploying the rule to the production environment. It is already recommended to test the rule in a copy cube prior to the execution of the rule in the actual cube. Please note that while doing remodeling using customer exit, we can’t use the value of a field which is not inside the same dimension. Meaning that if you are planning to add posting year to dimension ‘X’, you can’t use 0CALMONTH value as an input (because this character is in the time dimension).
You can however use the values of all the other characters from dimension ‘X’. Also note that once your code starts running, it updates the dimension table in loop; no mass update is possible. Remodeling Steps: For understanding purpose first let us take a look at the remodeling screen. It can be navigated from any cube. Please note that one remodeling rule is unique for one info cube which means that remodeling rule is not reusable.
Step1: Navigate to the cube where remodeling is needed. Right click and select Additional Function - Remodeling. Step2: Give Technical name of the remodeling rule and press create. The enter description and press transfer. Step3: Click on the + sign to create a new rule. Please find the explanations of all the above options – 1.
Add Characteristic: This option is default in the remodeling rule. This will add a new character to a dimension of choice. Delete Characteristics: Using this option we can delete any existing character from the cube. Please note that if we select this option, we don’t need to specify the rule or the dimension details.
Only input needed will be the character technical name. Replace Characteristics: Using this option, we can replace any existing character with a new character. In the option ‘Replace character’, F4 values would be the available characters in the cube whereas the option ‘With’ would include all the available characters in the system.
In this case also the characters from the same dimensions can only be used as input. Add Key figure: Using this option you could add a key figure to the cube. The following options are available: Constant or User exit. While using customer exit, only the F table or E table can be used as input. Delete Key figure: Using this option, an existing key figure can be deleted from the cube.
All you need to specify is the key figure’s technical name. Replace Key figure: With this option, an existing key figure can be replaced by another key figure. Please note that the only rule available here is customer exit. Constant: Constant values can be updated. Attribute of Characteristics: With this option, the value of the new field can be mapped from any attributes from any character of the same dimension.
Please note that the master data should be available in the same dimension. 1:1 Mapping: With this option the mapping from another characteristic in the same dimension can be done. Customer exit: If all the above options are not sufficient to achieve the requirement then one should go for customer exit.
Step4: Give the new character which needs to be added, the dimension name where the addition is required and the class name used for the customer exit (in this case ZCLADDYEAR). Unlike other exits, in this case there is no standard place to write the customer exit code. There is one standard interface available called IFRSCNVEXIT which needs to be added to the class. Apparently the implementation of this interface to be done inside the custom class of your choice.
The Method EXIT inside the interface can be used for this purpose. Important parameters inside the interface method which are needed for the logic is given below – IROLD (Importing): Reference point to the entire row of the dimension table (old structure before remodeling) CRNEWFIELD (Changing): Reference point to the new field in the dimension table (new structure) Step5: Create a new class in SE24 name it as ZCLADDYEAR.
Add the interface IFRSCNVEXIT to the interface tab. Press Enter, then the method exit would be available in the Method tab. Step6: Pseudo Logic to be written inside the method is given below –. Get the actual row (data) from the dimension table from the reference IROLD. Get the SID of End date (a field from the same dimension) from the above row. Convert it to value. Get year from date.
Convert the date to corresponding SID. Assign to CRNEWFIELD. Actual code is written below – METHOD ifrscnvexit exit. FIELD-SYMBOLS: TYPE ANY, TYPE ANY, TYPE ANY.
DATA: lchavl TYPE rschavl, lchavl1 TYPE rschavl. Assign parameter IROLD (Structure of the table before remodeling).
Assign result/value of the new field to the paramter CRNEWFIELD. If you want to use the same customer exit for more than one remodeling rule. make use of parmater ICNVTABNM. ASSIGN crnewfield -. TO. ASSIGN irold -.
Hi Rita, In this case first DS in R/3 need to be enhanced and infocube needs to be remodelled with new fields. Data for the new fields will come from R/3 through deltas but for these new fields data for old records will not be available. To get data for new fields for old records in the cube we need to stop delta loads and design an ODS and do a full load from R/3 to ODS, now from ods load the data for new fields for old records.
Tung Chu Dai Bi 7 Bien
Once we have data for new fields we can remove ods and restore the delta loads. Regards, Prerna 0 Likes 0.