Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 63 Insurance
- 536.4K On-Premises Infrastructure
- 138.3K Analytics Software
- 38.6K Application Development Software
- 5.8K Cloud Platform
- 109.5K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71.1K Infrastructure Software
- 105.3K Integration
- 41.6K Security Software
Variable in Business Rules
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;
"NetBSalary" = "Hours" * "NoCat"->"NoEntity"->"NoEmp"->"HrlyRate"->BegBalance* ("NoCat"->xfer->"NoEmp"->"PercentageFactor"->BegBalance);
Answers
-
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
-
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
-
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
-
Where is the variable created? Is that an Essbase variable? Did you try using &XFER
Regards
CK
-
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