Importing Data

There are times when developers and analysts need a fast and reliable way to leverage a data source to satisfy an immediate reporting need. However, they don't always have access to the enterprise database or data warehouse. It is possible, then, to use MicroStrategy Web to import data into an Intelligent Cube and then use it to build a dashboard or document.

It is necessary to have a 4-Tier environment configured to import data from MicroStrategy Web.

To import data on MicroStrategy Web 10, follow these steps:

1. Click on the Add External Data icon that appears once the user logs in to the project:

2. Select the source:

Selecting the source

MicroStrategy connects to a variety of data sources, from files, such as Excel or CSV, to relational databases and nonrelational sources, such as data from a web page. Once the data is imported, MicroStrategy saves it as...