The steps are:
- RSA5 Select the DataSources
- LBWE Maintain DataSources and Activate Extract Structures
- LBWG Delete Setup Tables
- 0LI*BW Setup tables
- RSA3 Check extraction and the data in Setup tables
- LBWQ Check the extraction queue
- LBWF Log for LO Extract Structures
- RSA7 BW Delta Queue Monitor
How to create a connection with LIS InfoStructures?
LBW0 Connecting LIS InfoStructures
to BW
What is the difference between ODS and InfoCube and MultiProvider?
- ODS:
Provides granular data, allows overwrite and data is in transparent tables, ideal for drilldown and RRI.
- CUBE:
Follows the star schema, we can only append data, ideal for primary reporting.
d- MultiProvider:
Does not have physical data. It
allows to access data from different InfoProviders (Cube, ODS, InfoObject).
It is also preferred for reporting.
What are Start routines, Transfer routines and Update routines?
Start Routines:
The start routine is run for each DataPackage after the data has been written to the PSA and before the transfer rules have been executed. It allows complex computations for a key figure or a characteristic. It has no return value. Its purpose is to execute preliminary calculations and to store them in global DataStructures. This structure or table can be accessed in the other routines. The entire DataPackage in the transfer structure format is used as a parameter for the routine.
Transfer / Update Routines:
They are defined at the InfoObject
level. It is like the Start Routine. It is independent of the DataSource.
We can use this to define Global Data and Global Checks.
What is the difference between start routine and update routine, when, how and why are they called?
Start routine can be used to access
InfoPackage while update routines are used while updating the Data Targets.
What is the table that is used in start routines?
Always the table structure will
be the structure of an ODS or InfoCube. For example if it is an ODS then
active table structure will be the table.
Explain how you used Start routines in your project.
Start routines are used for mass
processing of records. In start routine all the records of DataPackage
is available for processing. So we can process all these records together
in start routine. In one of scenario, we wanted to apply size % to the
forecast data. For example if material M1 is forecasted to say 100 in May.
Then after applying size %(Small 20%, Medium 40%, Large 20%, Extra Large
20%), we wanted to have 4 records against one single record that is coming
in the info package. This is achieved in start routine.
What are Return Tables?
When we want to return multiple
records, instead of single value, we use the return table in the Update
Routine. Example: If we have total telephone expense for a Cost Center,
using a return table we can get expense per employee.
How do start routine and return table synchronize with each other?
Return table is used to return the
Value following the execution of start routine
What is the difference between V1, V2 and V3 updates?
V1 Update:
It is a Synchronous update. Here the Statistics update is carried out at the same time as the document update (in the application tables).
V2 Update:
It is an Asynchronous update. Statistics update and the Document update take place as different tasks.
V1 & V2 don’t need scheduling.
Serialized V3 Update:
The V3 collective update must be scheduled as a job (via LBWE). Here, document data is collected in the order it was created and transferred into the BW as a batch job. The transfer sequence may not be the same as the order in which the data was created in all scenarios. V3 update only processes the update data that is successfully processed with the V2 update.
