Q&A : Multidimensional Data Model in BW 3.5

Questions

1) How many hierarchies can be created for a key figure?

     a) 10

     b) 2

     c) 5

     d) 98

     e) More than one

     f) Only one

2) In a query a navigational attribute behaves like which of the following?

     a) Attributes

     b) Filters

     c) Characteristics

     d) Variables

     e) None of the above

3) Hierarchy can be which of the following?

a)   Time dependent

b)   Version dependent

c)   With intervals

d)   Time dependent structure

e)   None of the above

4) Which of the following refers to Info Objects?

a)   Characteristics

b)   Key figures

c)   Queries

d)   Attributes

    e) None of the above

5) Which of the following are examples of characteristics?

a)   Monthly sales

b)   Products

c)   Cost centres

d)   Company codes

e)   Sales person

6) What is the central tool in SAP BW?

AWB

7) What are the functions available in the AWB? 

Modeling, scheduling, monitoring

8) How many types of Info Objects are available?

   Characteristics & key figures

                                                                       

9) What are the data types of characteristic Info Objects?

Char, numeric

10) What is an “Attribute only” characteristic Info Object?

11) What is the prerequisite for attaching documents to a characteristic

InfoObject?

12) What types of data can be associated to a characteristic Info Object?

13) What is the difference between a Display and a Navigational attribute?

14) What is the use of compounding an Info Object with another?

15) How many data types are available for key figure Info Objects?

16) What are additional requisites for Amount/Quantity key figure Info Objects?

   Currency/unit

17) What is the requisite for using Exceptional Aggregation?

18) What are non cumulative key figures?