To load data into the ODS object,we need to create an InfoSource,transfer rules,and update rules. After loading the data into the ODS object,we will aggregate the data from the ODS object and load them into an InfoCube.
A new InfoCube has been created that will accept the data from the ODS object. Screen shows its data model.
Step 1. Repeat the procedure outlined in Section to create an InfoSource,IS_ODS_DEMO,and then create transfer rules.
Step 2. Repeat the procedure outlined to create update rules. The InfoSource is IS_ODS_DEMO. Screen shows the active update rules.
Let's check the update type for ODS data fields. To display the update type for Sales quantity, select Sales quantity and then click.
Step 3. Screen shows one of the differences between ODS objects and InfoCubes: The default update type for an ODS object is Overwrite,and the default update type for an InfoCube is Addition.
Step 4. Repeat the procedure outlined to create update rules for the InfoCube. In this case,use the ODS object ODS_DEMO as the DataSource instead of the InfoSource as shown in Screen. Click to continue.
Step 5. After proposing update rules,BW finds out that one or more InfoCube key figures cannot have one-to-one mappings with the key figures in the ODS object. It therefore decides the update type for these key figures should be set to "no update."
In Screen,we will find out which InfoCube key figures do not have the one-to-one mappings with the key figures in the ODS object. Click to continue.
Step 6. Screen shows that the key figure Sales revenue does not have a one-to-one mapping with a key figure in the ODS object. Let's create an update rule for it. Select Sales revenue,and then click.
Step 7. Click to create an update rule.
Step 8. Enter a description,and then click to open the ABAP editor.
Step 9. Enter RESULT = COMM_ STRUCTURE-/BIC/IO_QUAN * COMM_ STRUCTURE-/BIC/IO_PRC. as shown on line 21,and then click to check the routine. If it is valid,click to save it and go back.
Step 10. Click to continue.
Step 11. Click to check the update rules. If they are valid,click to activate them.
Screen shows you have achieved a data flow path from the flat file source system all the way to the InfoCube.
SAP BW Related Interview Questions
|SAP BI Interview Questions||SAP WM Interview Questions|
|SAP BO Interview Questions||SAP Netweaver Interview Questions|
|SAP BODS Interview Questions||SAP Webi Interview Questions|
|SAP Web Dynpro Interview Questions||SAP BDC Interview Questions|
|SAP BW on HANA Interview Questions|
Sap Bw Tutorial
Business Scenario And Sap Bw
Creating An Infocube
Loading Data Into The Infocube
Checking Data Quality
Creating Queries And Workbooks
Managing User Authorization
Aggregates And Multi-cubes
Operational Data Store (ods)
Generic R/3 Data Extraction
All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd
Wisdomjobs.com is one of the best job search sites in India.