Idea Exchange - My Ideas Posted in MSTR Community - Better Support for Exporting from Document Cache

2) Better Support for Exporting from Document cache:

MSTR Community Link:

https://community.microstrategy.com/t5/Idea-Exchange/Better-Support-for-Exporting-from-Document-Cache/idi-p/292068

Note: Microstrategy considers our ideas based on the votes. Please cast your vote which will help to get this as a new feature in the future MSTR release

The main purpose and important reason why we create\recommend document cache is to get better performance which gives better user experience. Microstrategy do supports document cache with different output mode but still I feel few improvements needed in the way it handles the data export from the cached document. 

Improvements needed: 

1. Options to export a single grid or graph (Not a whole document or a panel or a layout) in a document from the cache – Without re-executing the document in the background
2. If possible connect different cache output modes. Ex: Use excel cache when user tries to export a graph from flash mode (Use\connect excel cache from flash cache) 

Let’s take some example to understand this behavior in a better way, 

We have a heavy weight document which usually executes in 20 mins. We usually creates cache in all possible output modes to give better user experience to our customers. 

Let’s consider, 

• Document is cached in all output modes and now we are executing the document in flash mode (deprecated flash mode in MSTR 10)
• We are getting results quickly – Very good
• Document is having lots of different panels with different visuals and grid. User likes to export one piece of grid\graph into excel for different business reason – sounds very valid & day to day business case
• User tries to export a particular grid into an excel – here starts the problem

• In order to export a small piece of grid or a graph from a heavyweight document, it has to execute the complete document and then it exports that particular grid – here it gives very bad user experience and purpose of my document cache is not served completely. MSTR 10 handles this even worst

• We may have different workarounds or other options to deal with this problem in Microstrategy but most of them are asking a compromise from the user experience which is not good
  • Few options are
    • If you want to export into Excel, then create Excel cache and instead of executing the document in a flash mode, go with direct export to excel option – yes, one way it solve my problem but still I can’t export a piece of graph in the whole document. We can only export the whole document
    • Same approach for PDF. Create a PDF cache and export the whole document in PDF
    • Here for each export options customer has to run a document in different mode – All are not in one place