Interested to Buy Any Domain ? << Click Here >> for more details...
I have Two cubes one is SD cube and one is customized cube.There are 2 Data sources called SD Data Source and Billing Data Source.I want to Load SD Data to SD Cube and Billing Data to Billing Cube.I want to Look up some Data from SD Cube to Billing Cube.How do i Look up the data?
- 1 Answers
- 4146 Views
- Bosch, I also Faced
- E-Mail Answers
Answer Posted / jai
Lookup defination SAP BW:
· Concept of Lookup is same in SAP BW as other Data warehousing tools .
For performing lookup a key column with the source BW table and lookup table must match.
· Lookup table can be any SAP BW infoproviders (like, DSO , MD table,Fact table etc.)
· If the key columns in source or result package are matched with the lookup table key column then those corresponding rows will only be passed to output Target. Others can be taken in reject.
We need to pass a key column from source table and we will get the required data once the key column matches
Technique to use lookup concept in BW:
Lookup normally we can do in Start routine, Field level Routine and in End routine.
In this document we will explain
· lookup through Start and Field routine
· Lookup through END routine
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What does the VARIABLE_SCREEN URL parameter do?
What is the Bex options for characteristics like F4 help for query definition and execution?
What is delete table before extraction option?
Extraction in mm and SD and FI? What is the requirement and name them?
When coding the ABAP transfer rule, what are the important variables you make
You want to see the log of transport connection. What t-code would you use? List the steps.
What is the source for FIAP extractor?
How do you debug user exit?
What are Process Chains?
Where do you find which table is currently being populated (BIW1 or BIW2)?
Describe your experience with the design and implementation of standard & custom infocubes.
Give some examples of old LIS and new equivalent LO?
How is ?:? useful as an authorization value?
What are the restrictions DB connect?
Can you tell something about the multi-provider in the sap and how it is useful for the users?
