SAP BW .... Basics...4

Q.What is the conversion routine for units and currencies in the update rule?Ans.Using this option you can write ABAP code for unit/currency conversion; if you enable this flag, then unit of key figure appears in the ABAP code as an additional parameter; for example you can use this to convert quantityin pounds to kilograms.

Q.How do you add an entry in the monitorlog from the update rules?Ans:-This is added in the internal table MONITOR; the following fields describe the monitor structure
a. MONITOR – MSGID → gives an ID
b. MONITOR - MSGTY→ message type
c. MONITOR- MSGNO→ message number
d. MONITOR- MSGV1→monitor message 1
e. MONITOR- MSGV2→monitor message 2
f. Append it to the MONITOR table; this will show up in the monitor

Q.What is a data mart?Ans.The BW system can be a source to another BW system or to itself; the ODS/cube/info provider which provide data to another system are called data marts.

Q.What is the myself datamart?Ans.The BW system feeding data to itself called the myself datamart; this is created automatically; uses Ale for data transfer.

Q.How do you create a data mart?Ans.
a.right click and create the export datasource for the ODS/cube
b.in the target system replicate the data source
c.create transfer rules and update rules
d.create info package to load

Q. Can you make multi providers and master data as data marts?Ans. Yes

Q.What are the benefits of data mart?Ans.
a.simple to use
b.Hub and spoke usage
c.Distributed data
d.Performance improvement in some cases.

Q.What are the events and how you use it in BW?Ans:-Events are background signals to tell the system that certain status has been reached; you can use events in batch jobs; for example after you load data to the cube you can trigger an event which will start another job to run the reporting agent. Use SM62 to create and maintain events.


Q. What is an event chain?Ans.This is a group of events which complete independently of one another; use this to check the successful status of multiple events; for example you can trigger a chain event if all loads are successful.

Q. How do you create event chains?Ans. AWB→ Tools → Event collector

Q. What is PSA?Ans. Persistent Staging area- is based on the transfer structure and source system dependent.

Q.what are the options available for upgrades to data targets?.
a.PSA and data targets in parallel – improves performance
b. PSA and data target in sequence
c. PSA only; you have to manually load data and data tagets
d. data targets only – No PSA

Q.Why if one request fails, all the subsequent requests will turn to ‘red’?Ans. This is to avoid inconsistency and make sure that only verified data is entered in to the system.

Q.What are the two fact tables?Ans. There are two fact tables for each info cube; it is the E-table and F-table.

Q.what is compression or collapse?Ans.This is the process by which we will delete the request IDs; this saves space; all the regular requests are stored in the F table; When you compress the request ID is deleted and the data is transferred from the F table to the E Table; this saves the space and improves the performance; but the disadvantage is that you can not delete the compressed request individually.

Q. what is reconstruction?Ans. this is the process by which you load the data in to the same cube or in to the different cube.
66

Q. What is a remote cube?Ans. remote cube is a logical cube, where the data is extracted from an external source; usually it is used to report the real time data from an R/3 system instead of drilling down from BW to R/3

Q. What is the virtual info cube with services?Ans. in this case the user defined function module is used as data source.

Q.What are the restrictions/recommendations for using remote cube?Ans. These are used for small volume of data with few users; no master data allowed.