Try doing the same using some batch script by just calling the macro through batch script.
and see if this works !!! I believe you have given your connection information etc in macro from which you are pulling Essbase Data.
Alex, Smart View doesn't support that. I tried long time back the same thing, however it won't work if the work book is not open.
EXCEL Add-in works fine.