Variable in Business Rules

Nirmal Shrestha

Hi,

We are trying to create a variable in a BusinessRule and then trying to call the variable in formula, but it does not work for us.

Basically, in this example, we have created a variblab XFER.

We then try to call the XFER variable inside the formula. However, it throws validation error: "ERROR COMPILING FORMULA.... EXPECTED TYPE (MEMBER) FOUND.. XFER in function.

Here is the syntax that we have.:

xfer = "TransferTraining"->"Unit1"->"TransferFrom"->Dec;

@ISMBR("TransferTraining")

                "NetBSalary" = "Hours" * "NoCat"->"NoEntity"->"NoEmp"->"HrlyRate"->BegBalance* ("NoCat"->xfer->"NoEmp"->"PercentageFactor"->BegBalance);

Sree Menon-Oracle

I am not sure what you are trying to do here.

xfer = "TransferTraining"->"Unit1"->"TransferFrom"->Dec;

I hope xfer is declared as VAR xfer, right? It will only hold the numeric value and cannot be used in a cross dim syntax. ESSBASE expects the member name not a numeric value.

-Sree Menon

Nirmal Shrestha

Sree,

Yes XFER is the variable here.

We are trying to call the variable in CROSS-DIMENSIONAL SYNTAX.

So you mean to say Essbase does not allow Variables in cross dimensional syntax? but only in formula say if I had to multiply the variable that would be good?

Thanks

Nirmal

Sree Menon-Oracle

ESSBASE calc script is not like C or Java where you can declare variables to hold string values and use them in your script at a later point.

if you are using calc manager rules, you should use RTP to do that job for you.

-Sree

Celvin Kattookaran

Where is the variable created? Is that an Essbase variable? Did you try using &XFER

Regards

CK

Celvin Kattookaran

I've Essbase sub vars with calc scripts in it and it works fine. So interesting in knowing how are setting this up.

Regards

CK