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
- 4066 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
Without taking downtime how to fill logistics extractors (2lis types)
What is bp master data.
Is the user exit common for all data sources?
What are the steps to configure third party (BAPI)?
What are the load process and processing?
What are the steps to do the extractig data from r/3.
What are the steps within sap bi to create classes for bw?
as you said you have worked on cubes and ods, which one is better suited for reporting? Explain and what are the drawbacks and benefits of each one?
what is the component?
what is compatable and incompaltable bojects? plz ssend to my mail noorsoft143@gmail.com i need a declinations and example thanks in advance..............
Explain the architecture of the sap bw system?
I created process chain 1st day it taking 10 min after that 1st week it taking 1 hour after that next time it taking 1 day with a same loads what happen how can u reduce the time of loading
What is an event chain?
What is data ware-housing hierarchy?
Which transaction on R/3 shows the transactions with pending processes for update?
