You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

MDX format for power(raise to) in custom calculation

Received Response


Hi All,

I want to build below formula,

[Adjustment]:=([input][account])*(1+([input][mark up]))^3

  • What is the format for MDX format for power function (raise to) in custom calculation?

From the documents, I got below format and tried with just numbers and dimension members, but both are giving error "Missing resource: com.essbase.api.base.EssException: Cannot Perform Custom Calc. Essbase Error(1300056): The expression is invalid"

Syntax: Power ( numeric_value_expression, power )

             Power(9, 2.5) returns 243

  • How to give power value also a dimension member?

[Adjustment]:=([input][account])*(1+([input][mark up]))^([input],[dynamic power factor]);

Content (required):

Version (include the version you are using, if applicable):

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!