What is the correct variance formula for an ASO database that recognizes Expense and Non expense accounts?

What is the correct variance formula for an ASO database that recognizes Expense and Non
expense accounts?

What is the correct variance formula for an ASO database that recognizes Expense and Non
expense accounts?

A.
@Var(Actual, Budget);

B.
@Var([Actual],[Budget])

C.
[Actual] – [Budget]

D.
[Budget] -[ Actual]

E.
IIF (IsUda([Measures.currentmember], “Expense”), [Budget]-[Actual], [Actual]-[Budget])

Explanation:
http://www.oracledatabase12g.com/wpcontent/uploads/book/Oracle%20Essbase%20&%20Oracle%20OLAP.pdfPage 435

Show Hint

Leave a Reply 1

Your email address will not be published. Required fields are marked *

Hassane

Hassane

A is incorrect for two reasons :
1-in ASO we don’t use the ; in the end of a formula
2- the formula is applied on a expense and non expense accounts!
so the right answer is E

Reply