×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Need Help to Automate Export Process!

Need Help to Automate Export Process!

Need Help to Automate Export Process!

(OP)
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

RE: Need Help to Automate Export Process!

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.

RE: Need Help to Automate Export Process!

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.

RE: Need Help to Automate Export Process!

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...

RE: Need Help to Automate Export Process!

(OP)
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

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

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.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close