11. Which two functions can produce a report that includes only Elimination entities?
Ans. two functions which can produce a report that includes only Elimination entities are a Fixed Name List and Dynamic Name List.
12. Explain Dense and Sparse Dimensions?
Ans. Dense dimension is a dimension in which most data exists for every combination of dimension members whereas sparse dimensions are the dimensions which has low probability that data will exist for every combination of dimension members.
13. What are the three primary build methods for building dimensions?
Ans. The following are the three primary build methods for building dimensions :-
1) Generation references
2) Level references
3) Parent-Child references.
14. Differentiate between ASO & BSO?
Ans. 1) We cannot write back in ASO although we can write back in BSO.
2) Most dimensions in ASO are sparse whereas in BSO most of them are dense.
3) We cannot create more than 1 database in ASO but we can create more than 1 db per application. If we have more than 10 dimensions then we should opt for ASO.
15. Explain attributes?
Ans. Classification of a member in a dimension is known as an attribute. We can do selection of group members based on their associated attributes. We can also specify an attribute while performing calculations and along with we can use calculation functions. As example, the db in Sample Basic with product dimension has some attributes like package type, size, and flavor. We can add attributes to the dimensions and can retrieve data. For example, to retrieve “coke with 8 Oz with bottles”.
Ans. two functions which can produce a report that includes only Elimination entities are a Fixed Name List and Dynamic Name List.
12. Explain Dense and Sparse Dimensions?
Ans. Dense dimension is a dimension in which most data exists for every combination of dimension members whereas sparse dimensions are the dimensions which has low probability that data will exist for every combination of dimension members.
13. What are the three primary build methods for building dimensions?
Ans. The following are the three primary build methods for building dimensions :-
1) Generation references
2) Level references
3) Parent-Child references.
14. Differentiate between ASO & BSO?
Ans. 1) We cannot write back in ASO although we can write back in BSO.
2) Most dimensions in ASO are sparse whereas in BSO most of them are dense.
3) We cannot create more than 1 database in ASO but we can create more than 1 db per application. If we have more than 10 dimensions then we should opt for ASO.
15. Explain attributes?
Ans. Classification of a member in a dimension is known as an attribute. We can do selection of group members based on their associated attributes. We can also specify an attribute while performing calculations and along with we can use calculation functions. As example, the db in Sample Basic with product dimension has some attributes like package type, size, and flavor. We can add attributes to the dimensions and can retrieve data. For example, to retrieve “coke with 8 Oz with bottles”.
No comments:
Post a Comment