Oracle Exam 1Z0-533 Topic 1 Question 82 Discussion

Actual exam question for Oracle's 1Z0-533 exam

Question #: 82
Topic #: 1

You need to create an allocation Business Rule that allocates marketing expense from corporate

down to each region based on FYIO actuals for the Budget scenario. What is the correct formula

assuming this syntax is used in an enhanced calc script?

AFIX (Budget, 0LEVMBRS (Market,0))
'Marketing expense' = 'Marketing expense '->Corporate * ('Marketing expense'
Actual / 'Marketing expense' -> Actual -> TotalMarket);
ENDFIX

BFIX (Budget, (3LEVMBRS (Market, 0) ) )
'Marketing expense' = 'Marketing expense'->Corporate * ('Marketing
expense'/'Marketing expense' -> TotalMarket) ;
ENDFIX

CFIX (Budget, (3LEVMBRS (Market, 0) )
--- 'Marketing expense' = 'Marketing expense'->Corporate * ('Marketing expense
Actual ->FY10 / 'Marketing expense' -> Actual ->FY10 TotalMarket);
ENDFIX

DFIX (OLEVMBRS (Market, 0) )
'Marketing expense' = 'Marketing expense'~>Corporate * (^Marketing expense
Actual ->FY10 / 'Marketing expense' -> Actual ->FY10 TotalMarlket);
ENDFIX

Show Suggested Answer

Suggested Answer: A, D

by Lakeesha at Dec 05, 2024, 04:50 PM

Limited Time Offer

25%

Off

Get Premium 1Z0-533 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Jaleesa

17 hours ago

I'm pretty sure the answer is B, but I'm a little confused about the syntax. What's the difference between 3LEVMBRS and 0LEVMBRS? And why do we need to divide by the total market actual instead of just using the region's actual?

upvoted 0 times

...

27 days ago

I think the correct formula is A) FIX (Budget, 0LEVMBRS (Market,0))...

upvoted 0 times

...