You have the following customer dimensions;
You need to create a % of total (by region) calculation by customer in you aggregate storage
database for Net_Revenue. Select the best syntax for member formula so that the % Total
calculation works at all levels of customer dimension.
A.
(Net_Revenue]) / (Parent. [Net_Revenue])
B.
(customer.CurrentMember, [Net_Revenue]) / (customer. CurrentMember,Parent,
[Net_Revenue]);
C.
(customer.CurrentMember, [Net_Revenue]) / (customer. CurrentMember,Parent,
[Net_Revenue])
D.
(customer.CurrentMember, [Net_Revenue]) / (customer. [Net_Revenue]);
E.
(customer.CurrentMember, [Net_Revenue]) / (customer. [Net_Revenue], Products,
YearTotal);
c