Oracle
1Z0-531 · Question #24
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…
The correct answer is B. (customer.CurrentMember, [Net_Revenue]) / (customer.CurrentMember.Parent, [Net_Revenue]). We need to use the methods .CurrentMember and CurrentMember.Parent to get the correct % throughout all level of the customer dimension.
Calculations and Formulas
Question
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.
Exhibit
Options
- 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);
How the community answered
(14 responses)- A7% (1)
- B71% (10)
- C7% (1)
- D14% (2)
Explanation
We need to use the methods .CurrentMember and CurrentMember.Parent to get the correct % throughout all level of the customer dimension.
Topics
#MDX#ASO member formula#CurrentMember#percent of total
Community Discussion
No community discussion yet for this question.