FDMEE Essbase Default Calc Script issue in Data Load Rule Process
Problem Description
---------------------------------------------------
In FDMEE, when I execute a data load rule to load data to Essbase, it is running a Default Calculation:
2020-07-07 08:33:20,450 INFO [AIF]: ***** Consolidation Initialization - BEGIN *****
2020-07-07 08:33:20,450 DEBUG [AIF]: Connection established to FDMEE database.
2020-07-07 08:33:20,482 INFO [AIF]: ***** Consolidation Initialization - END *****
2020-07-07 08:33:20,482 INFO [AIF]: ******** Consolidation Execution - BEGIN ********
2020-07-07 08:33:21,013 INFO [AIF]: ------------------- Consolidation for Entity : A&A - BEGIN -------------------
2020-07-07 08:33:21,013 INFO [AIF]: Default Calculation Script: Fix("FY21","Jun",@IDescendants("A&A"))
CALC Dim("Customers", "Years", "Versions", "Scenarios", "Accounts");
ENDFIX
Fix("FY21")
@IDescendants("A&A");
ENDFIX
2020-07-07 08:33:21,029 ERROR [AIF]: Cannot calculate. Essbase Error(1012017): Cannot calculate dimension [Years] with restricted member [FY21]