This will help you re-create essbase substitution variables from essbase.sec file
Read this post on ckattookaran-hyperion.blogspot.com