You need to calculate average units sold by the customer dimension within an ASO
database. The member formula should calculate correctly regardless of level within the
customer dimension. Identify the correct syntax for the member formula.
A.
@AVG (SKIPBOTH, “Units_Sold”);
B.
Avg(Customer.CurrentMember.Children, [Units_Sold])
C.
Avg([Customer].Children, [Units_Sold]);
D.
Avg(Customer.CurrentMember.Children, [Units_Sold]);
E.
Avg(Customer.Children, [Units.Sold]);
Explanation:
http://download.oracle.com/docs/cd/E12032_01/doc/epm.921/html_techref/techref.htm#calc/
calcover.htm
http://www.oracledatabase12g.com/wpcontent/uploads/book/Oracle%20Essbase%20&%20
Oracle%20OLAP.pdf
C