MicroStrategy ONE

Troubleshooting Data Imported from a File

You can use MicroStrategy Web to import data from a file, such as a text file, CSV file, or Excel spreadsheet. The imported data is stored in an Intelligent Cube. For more information about importing data, including instructions, see the Project Design Help.

  • When importing a large file, make sure that sufficient memory is available on both the client and server machines:
    • On the client machine, that is, the machine from which the user initiates the import, the web browser may require an amount of memory up to five times the size of the file being imported. For example, if you are importing a 50 MB Excel file, the web browser may use up to 250 MB of RAM.
    • On the Intelligence Server machine, Intelligence Server may require an amount of memory up to four times the size of the file being imported. For example, if you are importing a 50 MB Excel file, Intelligence Server may use up to 200 MB of RAM.
  • On the Intelligence Server machine, ensure that the Java Virtual Machine's memory limit is set to 800 MB. For instructions, see the documentation provided for the Java Virtual Machine.
  • You may need to increase the timeout settings for your network, web browser, or web server.