SAP BW ...PROCESS CHAINS

Q.What is a process chain?Ans. Process chain is a utility to schedule batch jobs on BW like SM37; it offers good monitoring features and error handling.
Q. What is the transaction for process chain?
Ans. RSPC

Q.what are the load processing and past processing?
a.Info package
b.Read PSA and update data target
c.save hierarchy
d.update ODS data object
e.Data export(open hub)
f.Delete overlapping request- useful if you do a full load everyday for the current fiscal year period and delete the data from the previous day.

Q.What are the data target administration task?a.delete index
b. generate index
c. construct database statistics
d.initial fill of a new aggregates
e.roll up of filled aggregates
g.activate ODS
h. complete deletion of a data target

Q.what are the reporting agent tasks?a. exception reporting
b.print in the background
c.pre calculation of web templates
d.Precalculation value sets

Q.What are the other BW processes?Ans.
a. attribute change run
b. adjustment of time dependent attributes
c. deletion of requests from PSA
d. recognize attributes and texts for master data

Q.What are the scheduling options for start process?Ans. direct scheduling or start from metachain(parent chain)/or API; use the second option for your child process chains.

Q.What is a process chain?Ans. Process chain is a utility to schedule batch jobs on BW like SM37; it offers good monitoring features and error handling.
Q. What is the transaction for process chain?
Ans. RSPC

Q.what are the load processing and past processing?a.Info package
b.Read PSA and update data target
c.save hierarchy
d.update ODS data object
e.Data export(open hub)
f.Delete overlapping request- useful if you do a full load everyday for the current fiscal year period and delete the data from the previous day.

Q.What are the data target administration task?a.delete index
b. generate index
c. construct database statistics
d.initial fill of a new aggregates
e.roll up of filled aggregates
g.activate ODS
h. complete deletion of a data target

Q.what are the reporting agent tasks?a. exception reporting
b.print in the background
c.pre calculation of web templates
d.Precalculation value sets

Q.What are the other BW processes?Ans.
a. attribute change run
b. adjustment of time dependent attributes
c. deletion of requests from PSA
d. recognize attributes and texts for master data

Q.What are the scheduling options for start process?Ans. direct scheduling or start from metachain(parent chain)/or API; use the second option for your child process chains.

Q.What are the parallel processes that could have locking problems?Ans.
a. hierarchy attribute change run
b. loading the master data for same info object; for example avoid loading master data from different source systems at the same time.
c. rolling up for same info cube
d. selecting deletion of info cube/ ODS and parallel loading
e. activation or deletion of ODS when loading parallel

Q.By default all newly created process chains are assigned to “unassigned node”; how would you reassign to proper component?Ans. Process chain→ attributes →display components.

Q.What are the views available for process chain?Ans.planning view, checking view, log view and job overview.
Q. How would you send an email when a peocess is completed?Ans. Right click on the process you want to monitor ( for example load info package) →select create message→ select when you want to send a message(success, fail, or always)→create a variant for the mail.

Q.How would you convert a info package to a process chain?Ans. double click on the info package group, click on the “process chain Maint”, button and type in the name and description; the individual info packages are inserted automatically.Ans.
a. hierarchy attribute change run
b. loading the master data for same info object; for example avoid loading master data from different source systems at the same time.
c. rolling up for same info cube
d. selecting deletion of info cube/ ODS and parallel loading
e. activation or deletion of ODS when loading parallel

Q.By default all newly created process chains are assigned to “unassigned node”; how would you reassign to proper component?Ans. Process chain→ attributes →display components.

Q.What are the views available for process chain?Ans.planning view, checking view, log view and job overview.
Q. How would you send an email when a peocess is completed?Ans. Right click on the process you want to monitor ( for example load info package) →select create message→ select when you want to send a message(success, fail, or always)→create a variant for the mail.

Q.How would you convert a info package to a process chain?Ans. double click on the info package group, click on the “process chain Maint”, button and type in the name and description; the individual info packages are inserted automatically.