Need Help to Automate Export Process!

[DCBBB]

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

 

[reisw]

D,

One thing you might try is to instead of downloading the reports into access make the reports datamarts and then use access to read the tables themselves from your database into Access. The importing of the data should be much faster and then you can also write a macro that would load them all automatically.

 

[nlim]

D, in addition to reisw's suggestion, you can also set up the datamart to be your specific Access database. You will need to create a new database instance.

 

[nlim]

out of curiosity, why do your reports take a few hours to run? Are there lots of analysis or are you just table scanning a large fact table? Seems like long running reports...

 

[DCBBB]

The reports I am running are at the lowest levels of data - down to the SKU/store level and over time. Not everyone has Microstrategy access here so until they do, I need to extract this data to feed the old reports which are still in Access. The datamart solution sounds viable and I will have to start tinkering with it. Thanks for the info!
D