I am trying to automate a file download process using Microstrategy (v.7.2.1) and Access (v.97). I have multiple reports set up which run fine, but do take several hours. I currently schedule them to run overnight so that they are waiting for me in the morning. However, to export the results to Access, it appears that I need to open each report, then export manually and this takes forever. Ideally, I would like the downloading to occur automatically into Access after the report runs, where I would then kick off a macro that would perform further data manipulations not possible in Microstrategy. Has anyone else tried this and is it possible? TIA! D
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.