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&%20
Oracle%20OLAP.pdfPage 435