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?
Answer / 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 |
What is SUMCT?
What are the steps to configure third party (BAPI)?
What are the settings for flat files?
Are there any limitations for bex analyzer?
What is a star schema?
Explain business blueprint stage.
Define the Lis data flow?
What is Open Hub (OH)?
explain return tables. How do start routine and return table synchronize with each other?
How to get the recordmode D or A in changelog table when we delete or add records in DSO?
Can any 1 plz tell me How to identify the missing delta's to run the repair full request,and vat are the extractors used in lo cockpit,if i use filter on condition which 1 will execute first?,
how to create info package from ods to ods then to infocube for process chain