SAP BW .... Basic ...2

Q.What are the data types allowed for key figures?Ans:-Amount, number, integer,date and time.
Q.What is the difference between amount/quantity and number?
Ans:-Amount/quantity always comes withunits; for example sales will be amount and inventory quantity.

Q.what are the aggregation options for key figures?Ans:- If you are defining prices then you may want to set “no aggregation” or you can define max, min, sum; you can also define exception aggregation like first, last etc., this helpful in getting headcount; for example if you a monthly inventory count key figure you want the count as of last day of the month.

Q.What is the maximum number of key figures you can have in an info cube?Ans. 233.

Q.What is the maximum number of characteristics you can have per dimension?Ans. 248.

Q. what are the nine decision points of data warehousing?Ans:- a. Identify fact table.
b. Identify dimension tables
c. Define attributes of entities
d. define granularity of the fact table( how often)
e. Pre calculated key figures
f. Slowly changing dimensions
g. Aggregates
h. How long data can be kept
i. How often data is extracted

Q.How many dimensions in a cube?Ans :-total 16 out of which 3 are predefined time, unit and request; customer is left with 13 dimensions.

Q.What is a SID table and advantages?Ans:-the SID(surrogate ID) table is the interface between master data and dimension tables;
Advantages:-
a. Uses numeric as indexes for faster access
b. master data independent of info cubes
c. language support
d. slowly changing dimension support

Q.what are the other tables created for master data?Ans.
a. P Table-Time independent master data attributes
b. Q table- time dependent master data attributes
c. M Table- Combines P and Q
d. X Table- Interface between master data SIDs and
time independent navigational attributes SIDs ( P is
linked to the X table)
e. Y Table- interface between master data SIDs and
time independent navigationsal attributes SIDs ( Q
is linked to the Y table)

Q. what is the transfer routine of the info object?Ans. it is like a start routine; it is independent of the data source and valid for all transfer routine; you can use this to define global data and global checks.

Q. what is the DIM ID?Ans. DIM ID links dimensions to the fact table.

Q.what is the table partition?Ans. SAP is using fact table partitioning to improve performance, you can partition only on 0CALMONTH OR
0FISCPER;

Q.How many extra partitions are created and how?Ans. Usually 2 extra partitions are created to accommodate data before the begin date and after the end date.

Q.Can you partition acube which already has data?Ans.No. the cube must be empty to do this. One work around is to make a copy of the cube A to cube B; export data from A to B using export data source; empty cube A;
Create partition on A; re-import data from B and delete cube B.

Q.What is the transaction for Administrator work bench?Ans. RSA1.

Q.What is a source system?Ans. Any system that is sending data to BW like R/3, flat file, oracle database or external systems.

Q.what is a data source?Ans. The source which is sending data to a particular info source on BW; for example we have a 0CUSTOMER_AFTER data source to supply attributes to 0CUSTOMER from R/3.
Q.What is an info source?Ans. Group of logically related objects; for example 0 customer info source will contain data related to the customer and attributes like customer number, address,
Phone number etc.,