Q: Where are CDF/macro definitions stored on server?

A: They are stored in a XML file at the location below…
<HYPERION_HOME>\products\Essbase\EssbaseServer\java\essfunc.xml