First,let's create an ODS object.
Step 1. Right-click InfoArea—demo,and then select Create ODS object….
Step 2. Enter a name and a description,and then click to create the named ODS object.
Step 3. Select the BEx Reporting option,allowing us to create queries on the ODS object from BEx Analyzer.
Note:We leave other options open so we have opportunities later to manually complete these tasks. It helps us to understand the data load process.
Next,click to get the necessary InfoObjects.
Step 4. Select IOC_DEMO_CH,which was created in Section. Click to continue.
Step 5. Drag IO_ORD (Order number),IO_CUST (Customer ID),IO_SREG (Sales region),IO_SOFF (Sales office),IO_SREPN2 (Sales representative ID – new 2),and IO_MAT (Material number) from the left panel into the right panel and place them under the Key fields folder. Here IO_ORD is a newly created characteristic for sales orders.
Step 6. Repeat Steps 3–5 to add IO_QUAN and IO_PRC to the ODS object. Be sure to add them to the Data fields folder.
Step 7. Repeat Steps 3–5 to add 0CALDAY (Calendar day) to the ODS object. Be sure to add it to the Key fields folder.
Step 8. Click. A new InfoObject,0RECORDMODE,is added. In Section,we will learn how to use it in delta data loads.Click to activate the ODS object.
You have created an ODS object that includes a new InfoObject,IO_ORD,for sales orders.
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.