SAP BW Basics... 5

Q. Give examples of data sources that support remote cubes?
Ans. 0FI_AP_3-vendor line items, 0FI_AR_3-customer line items.

Q.What is a multiprovider?Ans.Using multiprovider you can access data from different data sources like cube, ODS, infosets, master data.

Q.what are the added features in 3.x for multiprovider?Ans.Prior to 3.x only multi cubes were available; you can not combine ODS and cube for example.

Q.what is an info set?Ans. An info provider giving data by joing data from different sources like ODS, master data etc.,

Q.What is the difference between infoset and multi provider?Ans.Multiprovider is a union , where as infoset is a “join”(intersect).

Q.Can you create an infoset with info cube?Ans.No. only ODS and master data are allowed.

Q.what is a line item(or degenerate dimension)?Ans.If the size of the dimensionof a cube is more than the normal(more than 20%) of the fact table, you define that dimension as a line item dimension; for example if you store sales document number in one dimension in a sales cube, usually the dimension size and the fact table size will be the same; when you add the overhead of lookups for DIMID/SIDs the performance will be very slow; by flagging it as a line item dimension, the system puts the SID in the fact table instead ofDIMID for thesales document number; this avoids one look up in to dimension table.

Q.What are the limitation for line item dimension?Ans. only one characteristics are allowed per line item dimension.

Q.What is transactional info cube?Ans.These cubes are used for both read and write; standard cubes are optimized for only read; the transactional cubes are used in SEM.

Q.What is the cache monitoring transaction?Ans.RSRCACHE

Q.What are the profilw parameters for cache?Ans.rdsb/esm/buffersize_kb (max. size of cache) and rdsb/esm/max_objects(maximum number of entries in cache).

Q.Can you disable cache?Ans.Yes. either globally or using query debug tool RSRT.

Q. Can you restart conversion?Ans. yes

Q.When should you do the Alpha conversion?Ans. if you are upgrading you must do it before PREPARE stage of upgrade.

Q.What are the control parameters for data transfer?Ans.This defines the maximum size of packet, max. number of records per packet, the number of parallel processes ,etc.,

Q.What is the number range object?Ans. This defines the characteristic attributes; for example the object MATERIALNR defines the attributes of material master like length etc.,

Q. How do you set up the permitted characters?Ans. Using transaction RSKC.

Q. What is aggregate realignment run maintenance?Ans.Defines the level of percentage change for realignment run will cause a reconstruction of aggregates.

Q.What is update mode for master data?Ans.defines whether the master data is added automatically for non existing master data when you load transaction data.

Q.What is the ODS objects settings?Ans.Defines number of parallel processors in activation, min number of data records and wait times.

Q.What are settings for flat files?Ans. Defines thousand separator, decimal pointer, field separator(default is), field delimiter (default).

Q.Which transaction defines the background user in source system?
Ans.RSCUSTV3.