You can import data directly into MicroStrategy Web, for use in creating
and reports. You can import data
from many different data sources, such as Excel files, databases, or Salesforce.com
reports, or by using the results of custom database queries. You import
the data into MicroStrategy with minimum project design requirements.
Some common uses for this quick import feature include:
integrating data into MicroStrategy as part of a proof-of-concept
building dashboards, documents, and reports without having to "model"
the data source
and reporting on personalized data from various data sources
and analyzing personalized data with your project data
the data in your data source, then republishing the data to quickly
update your dashboards, documents, and reports
A dataset is a set of data that can be displayed in a dashboard or document.
The data can be displayed in objects such as visualizations, filters,
text fields, and so on. You can import data into a new dataset or add
the data to an existing dataset. You can select multiple tables to create
a single, multi-table dataset.
You can combine different types of data sources in a single dataset.
For example, you can import an Excel spreadsheet and then import a table
from a relational database, and combine them into a single dataset.
Data sources can access data directly or from memory. Direct data access
means that MicroStrategy Web connects to the data source. If the in-memory
data access is used, MicroStrategy Web retrieves the dataset results from
the data sources and stores them in memory. For more details about the
difference, and steps to change how a dataset accesses data, see Determining
how a dataset accesses its data.
Depending on your MicroStrategy
privileges, you may not have access to all of the data source import options.
and save data in a folder location. You can use this data immediately
to create a dashboard, document,
as described above, or create dashboards, documents, or reports using
the data at a later time.
For steps to import data from a specific data source, see the appropriate
Dashboards can be exported and saved as MicroStrategy files in MicroStrategy
Desktop. You can then import the
dashboard file into MicroStrategy Web. Importing dashboards allows you
to migrate data from Desktop to Web, and share it
with other Web users. For steps to import a dashboard, see Importing
If you add multiple datasets
to a dashboard, you must link the attributes that are shared in common
across multiple datasets. Linking the common attributes allows the data
in one dataset to relate to the data in other datasets. For steps to link
attributes that are shared in common, see Linking data shared across multiple
You can perform the following additional tasks to update, edit, and
share imported data:
(republish) imported data using data from the same type of data source
originally used to import the data. For steps, see Republishing
When you import data into MicroStrategy Web, the data is imported as
an Intelligent Cube, meaning that it will affect the overall administration
and sizing considerations of Intelligent Cubes for a project. For example,
once you publish an Intelligent Cube, the Intelligent Cube is stored on
the Intelligence Server and takes up memory, which can impact performance.
The amount of memory used is displayed at the bottom of the Select
a Data Source page. To view more details about the Intelligent Cubes,
such as name and memory, and manage the Intelligent Cubes, click the memory
used information. The Data Storage page opens. For descriptions of the
available information and options, see Data
Web Administrator Help for steps
to define or edit a database connection in Web. For general information
about defining a database connection, see the Configuring
and Connecting Intelligence Server chapter in the Installation and Configuration Guide
Did you find this helpful?
Thanks for taking the time to give us some feedback.
Sorry about that
Why wasn't this helpful? (check all that apply)
Thanks for your feedback.
Want to tell us more? Send us an email to leave your feedback.