Hi Below is my code it gets validated but while running it give essbase error - Cannot calculate. Essbase Error(1200370): Calculating in serial . This means it is getting null member in crossdim.
It is a PBCS environment.
FIX(@Relative("III_CON",0),@Relative("Total Employees",0),@Relative("Total Designation",0),@Relative("Total Department",0),@Relative("Total Division",0),"Working", "Budget", "FY18", BegBalance")
"Air Ticket Cost"
(
IF ("Joining Date" != #Missing and "Company Type" !=2)
IF("BegBalance"->"Air Ticket Grade" == 1) /* Economy*/
IF("NA_Division"->"NA_Cost Center/Department"->"NA_Category/Designation"->"NA_LineDetails/Employee"->"BegBalance"->"Economy"->@MEMBER( @CONCATENATE("HSP_ID_", @HspNumToString("BegBalance"->"Employee Country"))) != #Missing)
"Air Ticket Cost" = "NA_Division"->"NA_Cost Center/Department"->"NA_Category/Designation"->"NA_LineDetails/Employee"->"BegBalance"->"Economy"->@MEMBER( @CONCATENATE( ""HSP_ID_", @HspNumToString("BegBalance"->"Employee Country")));
ELSE
"Air Ticket Cost" = "NA_Division"->"NA_Cost Center/Department"->"NA_Category/Designation"->"NA_LineDetails/Employee"->"BegBalance"->"Economy"->@MEMBER( @CONCATENATE( ""HSP_ID_", @HspNumToString("BegBalance"->"Employee Country")));
ENDIF
ELSEIF("BegBalance"->"Air Ticket Grade" == 2)/* Bussiness */
IF ("NA_Division"->"NA_Cost Center/Department"->"NA_Category/Designation"->"NA_LineDetails/Employee"->"BegBalance"->"Economy"->@MEMBER( @CONCATENATE( ""HSP_ID_", @HspNumToString("BegBalance"->"Employee Country"))) != #Missing)
"Air Ticket Cost" = "NA_Division"->"NA_Cost Center/Department"->"NA_Category/Designation"->"NA_LineDetails/Employee"->"BegBalance"->"Economy"->@MEMBER( @CONCATENATE( ""HSP_ID_", @HspNumToString("BegBalance"->"Employee Country")));
ELSE
"Air Ticket Cost" = "NA_Division"->"NA_Cost Center/Department"->"NA_Category/Designation"->"NA_LineDetails/Employee"->"BegBalance"->"Economy"->@MEMBER( @CONCATENATE( ""HSP_ID_", @HspNumToString("BegBalance"->"Employee Country")));
ENDIF
ENDIF;
ENDIF
)
ENDFIX
please let me know if anybody used in this manner before.