Exit 1Z0-531 Oracle Essbase
Question 1 of 5
0% complete
Q1 Single choice

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);

Previous Next