SAP BW ...NON CUMULATIVE KEY FIGURES ?

Q.What are non cumulative key figures?Ans. these kinds of key figures are not summarized ( unlike sales etc), for example head count, inventory amount, these are always in relation to a point in time; for example we will ask how many employees we had as of last quarter. We don,t add up to the head count.

Q. what is standard and exception aggregation?Ans. Standard aggregation specifies how a key figure is compressed using all characteristics except time.
Exception aggregation specifies how a key figure is compressed using time characteristics.

Q.What is inflow and outflow?Ans. these are non cumulative changes used to get the right quantity.

Q.What is a market?Ans. Non-cumulatives are stored using a ‘Market’ for the current period.

Q.what is a time reference characteristics?Ans.It is a time characteristic which determines all other time characteristics. 0CALDAY, 0CALMONTH,0CALWEEK, OFISCPER.

Q.Give example data sources supporting this?Ans. 2LIS_03_BF and 2LIS_03_UM

Q. What is the opening balance?Ans.when you start loading inventory data from R/3 you start with a certain point in time; this is what is called opening balance. Assume that you have inventory since jan2002; you are loading data on Jan,2003 and the opening balance for the product is 200; the data before Jan,2003 is ‘Historic data’ . any data loaded after jan,2003 is ‘delta load’.

Q.What is “No Marker update”?Ans. If you choose this option when compressing Non-cumulative cube, the reference point is not updated, but the request are moved to request 0 (usual compression); you must do this for compressing historical data.

Q.How does the query calculated?Ans. Qty= Ref point in time Qty – Non compressed delta qtys – deltas for backward qty

Q.What is a validity determining characteristic?Ans. that determine validity period for non-cumulative cube; example plants opening and closing different time periods.

Q.What are do’s and don’ts?Ans.
a. use few validity objects
b.compress the cube ASAP.