SAP-BW interview questions part-VI

What is the maximum no. of dimensions in info cube?
16(3 are sap defines and 13 are customer defined)

What are the minimum no of dimensions in info cube?
4(3 Sap defined and 1 customer defined).

What are the 3SAP defined dimensions?
The 3 SAP defined dimensions are…..
1. Data packet dimension (P)…..it contains 3characteristics.
a) request Id
(b) Record type
(c) Change run id
2. Time dimension (T)….it contains time characteristics such as 0calmonth, 0calday etc
3. Unit Dimension (U)…it contains basically amount and quantity related units.

What is the maximum no. of key figures?
233

What is the maximum no. of characteristics?
248

What is the model of the info cube?
Info cube model is extended star schema.

What are the data types for the characteristic info object?
There are 4types:
1. CHAR
2. NUMC
3. DATS
4. TIMS

How you’ll write date in BW?
YYYYMMDD