Resolving Essbase Error(0): Error Executing Formula
Validation of business rules during the development phase may display the Cannot calculate. Essbase Error(0): Error executing formula for [xxxxx]:status code [1200397] in function [@SXCOMBINE]
error if incorrect parameters are used in a function, commonly in @SUMRANGE
. If you are using @SUMRANGE
, review the documentation to ensure that you are using the correct syntax, which is @SUMRANGE (mbrName [,XrangeList])
. Additionally, usage has to be accurate, for example, mbrName
cannot contain cross dimensional operators (->).