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.
To import data on MicroStrategy Web 10, follow these steps:
- Click on the
Add External Data
icon that appears once the user logs in to the project:
- 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 an Intelligent Cube. The cube can be refreshed and scheduled as a normal cube and used to build documents and dashboards.
- Prepare...