Report/Dataset :
- Once you execute the report in MicroStrategy Web – go to “Tools” to “Report Options”
By this way, you can easily run your report/dataset within MicroStrategy by default as “Excel” execution
- Select “Run By Default” as whichever format you’re interested to (& here – we are going to select as “Excel with formatting”
For Document:
- Once you execute the document, go for “Tools” to “Document Properties”
- Choose “Run by default as” under “Document” category & select “Export to Excel” (but you can export to PDF as well if needed)
- Post that, anytime you execute the document on web would export to excel automatically
Enjoy Reading!!