Oracle
1Z0-531 · Question #24
1Z0-531 Question #24: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-531 to reveal the answer and full explanation for question #24. The question stem and answer options stay visible for context.
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);
Unlock 1Z0-531 to see the answer
You've previewed enough free 1Z0-531 questions. Unlock 1Z0-531 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.