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
- 4139 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 are the steps to create DB connect?
What are the monitor settings?
Hi friends gm to all , i had done bi with integrating planning. and I have full knowledge on integrating planing, but I don't faced any interview's in ip now, So friends have we any interview questions like Integrating planning, pls send my mail ID.
What is the difference between ods and infocube and multiprovider?
How will you debug errors with SAP GUI?
What is an open hub service?
How does delta update mechanism work in ods?
What is the procedure to implement structural authorization in BW?
Explain return tables.
my intermediate is mpc and my graduation is bcom and pg is mba. learnt sap bw and abap. tell me the interview questions for the same?
How do perform real-time data acquisition in a bw system?
What are the mathematical functions?
When a query is run with a loop, what does it generate? A) Cartesian product b)An incompatible combination of objects c) An SQL statement generation error d)Results returning too many rows e)Results returning too few rows
What are the added features in 3.x for multi provider?
What is a constant selection?
