Q) As we use Sbwnn, sbiw1, sbiw2 for delta update in LIS then what
is the procedure in LO-COCKPIT?
is the procedure in LO-COCKPIT?
A: No LIS in LO cockpit. We will have datasources and can be maintained
(append fields).
Refer white paper on LO-Cockpit extractions.
Q) Why we delete the setup tables (LBWG) & fill them (OLI*BW)?
A: Initially we don't delete the setup tables but when we do change in extract structure we go for it. We r changing the extract structure right, that means there are some newly added fields in that which r not before. So to get the required data ( i.e.; the data which is required is taken and to avoid redundancy) we delete n then fill the setup tables.
To refresh the statistical data. The extraction set up reads the dataset that you want to process such as, customers orders with the tables like VBAK, VBAP) & fills the relevant communication structure with the data. The data is stored in cluster tables from where it is read when the initialization is run. It is important that during initialization phase, no one generates or modifies application data, at least until the tables can be set up.
Q) SIGNIFICANCE of ODS?
Q) Why we delete the setup tables (LBWG) & fill them (OLI*BW)?
A: Initially we don't delete the setup tables but when we do change in extract structure we go for it. We r changing the extract structure right, that means there are some newly added fields in that which r not before. So to get the required data ( i.e.; the data which is required is taken and to avoid redundancy) we delete n then fill the setup tables.
To refresh the statistical data. The extraction set up reads the dataset that you want to process such as, customers orders with the tables like VBAK, VBAP) & fills the relevant communication structure with the data. The data is stored in cluster tables from where it is read when the initialization is run. It is important that during initialization phase, no one generates or modifies application data, at least until the tables can be set up.
Q) SIGNIFICANCE of ODS?
A: It holds granular data (detailed level).
Q) WHERE THE PSA DATA IS STORED?
A: In PSA table.
Q) WHAT IS DATA SIZE?
Q) WHAT IS DATA SIZE?
A: The volume of data one data target holds (in no. of records)
Q) Different types of INFOCUBES.
A: Basic, Virtual (remote, sap remote and multi)
Virtual Cube is used for example, if you consider railways reservation all the information has to be updated online. For designing the Virtual cube you have to write the function module that is linking to table, Virtual cube it is like a the structure, when ever the table is updated the virtual cube will fetch the data from table and display report Online... FYI.. you will get the information : https://www.sdn.sap.com/sdn /index.sdn and search for Designing Virtual Cube and you will get a good material designing the Function Module
Q) INFOSET QUERY.
A: Can be made of ODS's and Characteristic InfoObjects with masterdata.
Q) IF THERE ARE 2 DATASOURCES HOW MANY TRANSFER STRUCTURES
ARE THERE.
Q) IF THERE ARE 2 DATASOURCES HOW MANY TRANSFER STRUCTURES
ARE THERE.
A: In R/3 or in BW? 2 in R/3 and 2 in BW
Q) ROUTINES?
Q) ROUTINES?
A: Exist in the InfoObject, transfer routines, update routines and start routine
Q) BRIEF SOME STRUCTURES USED IN BEX.
Q) BRIEF SOME STRUCTURES USED IN BEX.
A: Rows and Columns, you can create structures.
Q) WHAT ARE THE DIFFERENT VARIABLES USED IN BEX?
Q) WHAT ARE THE DIFFERENT VARIABLES USED IN BEX?
A: Different Variable's are: Texts, Formulas, Hierarchies, Hierarchy nodes &
Characteristic values.
Variable Types are :Manual entry /default value
Replacement path
SAP exit
Customer exit
Authorization
Q) HOW MANY LEVELS YOU CAN GO IN REPORTING?
Characteristic values.
Variable Types are :Manual entry /default value
Replacement path
SAP exit
Customer exit
Authorization
Q) HOW MANY LEVELS YOU CAN GO IN REPORTING?
A: You can drill down to any level by using Navigational attributes and jump
targets.
Q) WHAT ARE INDEXES?
targets.
Q) WHAT ARE INDEXES?
A: Indexes are data base indexes, which help in retrieving data fastly.
Q) IS IT NESSESARY TO INITIALIZE EACH TIME THE DELTA UPDATE IS
USED?
Q) IS IT NESSESARY TO INITIALIZE EACH TIME THE DELTA UPDATE IS
USED?
A: No.
Q) WHAT IS THE SIGNIFICANCE OF KPI'S?
Q) WHAT IS THE SIGNIFICANCE OF KPI'S?
A: KPI's indicate the performance of a company. These are key figures
Q) AFTER THE DATA EXTRACTION WHAT IS THE IMAGE POSITION.
Q) AFTER THE DATA EXTRACTION WHAT IS THE IMAGE POSITION.
A: After image (correct me if I am wrong)
Q) TOOLS USED FOR PERFORMANCE TUNING.
Q) TOOLS USED FOR PERFORMANCE TUNING.
A: ST22, Number ranges, delete indexes before load. Etc
No comments:
Post a Comment