Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

@HspNumToString - error in Calc Manager Script

EggyJul 29 2023 — edited Jul 30 2023

Dear All,

I have read the previous post:@HspNumToString - error in Calc Manager Script, but I am on EPBCS now.

I have ticked “create from members”, and my rule is as follows:
SET UPDATECALC OFF;

FIX("No Department",@Relative("Type",0),Forecast,FY23,@Relative("CostCentre",0),"Jan":"Dec",@Relative("Employee Type",0),"Salary","BaseData")
"Working"(

IF(@ISMBR(@MEMBER(@CONCATENATE("HSP_ID_",@HspNumToString("StartMonth"->"BegBalance"))):Dec)) @xwrite("Salary"->"BegBalance"*"TP_Days"->"No Department"->"No CostCentre"->"No_Type"->"No_ET"/"TP_Days"->"No Department"->"No CostCentre"->"No_Type"->"No_ET"->"YearTotal",@loopback,"Working");

ENDIF
)

ENDFIX
It threw the following error when I launched the business rule(it still get validated):

Cannot calculate. Essbase Error(0): Error executing formula for [Working, at or after line: [" @xwrite("Salary"->"BegBalance"*"TP_Days"->"No Department"->"No CostCentre"->"No_Type"->"No_ET"/"TP_Days"->"No Department"->"No CostCentre"->"No_Type"->"No_ET"->"YearTotal",@loopback,"Working");"]] (line 9): invalid argument in function [@_BPROC]
What is the error code “@_BPOC”?
Can someone please help with this? Your help is much appreciated:)

Comments