Let's Reconnect, thank you for making 2022 our best year yet.

Look Back
Calculation Script @XWrite Error 1024009 Member specified for External Ref formula Does not exist — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Calculation Script @XWrite Error 1024009 Member specified for External Ref formula Does not exist

Received Response
20
Views
1
Comments
edited Aug 2, 2018 2:36AM in Essbase 1 comment

Summary

Calculation Script @XWrite Error 1024009 Member specified for External Ref formula Does not exist

Content

My Calculation Script @XWrite Error 1024009 "VRC0000000000." Member specified for External Ref formula Does not exist....

@RELATIVE ("Enterprise",-1), @RELATIVE ("Client", -1), @RELATIVE ("Corporate", -1) All these members from Organization Dimension, I need level 1 data from organization dimension and copy to Level 0 member "Organization" Dimension in Target database. I am getting above error. Member names are similar.

"VRC0000000000." is level zero member in Organization dimension Insource database.

I am having issue with member list

Script:

FIX ( "Year Total","Level","Employees","Current","FY18","Budget", @RELATIVE ("Enterprise",-1),

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!