Block creation issue Essbase 11.1.2.4
Summary
Block creation issue Essbase 11.1.2.4Content
Hello Team,
I have a following code its giving block creation issue for 1st forecast month. I tried @CreateBlock, CREATEBLKEQ On and SET NONMISSGBLK ON. Nothing worked SET NONMISSINGBLK ON taking for ever since I am using XREF in member formulas. Can some one please help me to fix this code.
FIX(@RELATIVE("Total Departments",0),{Version}, "Forecast",&FcstYr,&FcstMth)
FIX(@RELATIVE("Total Entity",0),"Local Currency","USD")
"Beg Inv"
(
IF("No Entity"->"No Department"->"No Ledger"->"No currency"->"END_AP_Input"->"BegBalance"->"No Year"->"No Version"->"No Scenario" == 1)
0