MicroStrategy ONE

Display and Hide Data Sources and Databases for Data Import

If you arrived here from Workstation, see the Workstation Document Authoring Help.

You decide which data sources to make available on the Data Sources dialog. You can choose to display only the data sources that you use regularly, to help simplify the data import process.

After experimenting with the MicroStrategy sample files, you may no longer want to see it appear as an option. You can hide Sample Files as data source, so that it does not appear as an option.

You can select which databases to display in the drop-down for the Hadoop option, eliminating the ones you do not use.

To show or hide data sources for import

  1. Create a blank dashboard or open an existing one.

  2. Choose Add Data > New Data to import data into a new dataset.

    or

    In the Datasets panel, click More next to the dataset name and choose Edit Dataset to add data to the dataset. The Preview Dialog opens. Click Add a new table.

    The Data Sources dialog opens.

  1. Click Customize Shortcuts at the top of the dialog. The Resources and Databases buttons appear and the dialog is split into the Commonly Used and Not Commonly Used areas.
  2. Click Resources.
  3. In the Commonly Used area, click for a database to remove it. The database moves to the Not Commonly Used area and no longer appears in the Data Sources dialog when you import data.
  4. In the Not Commonly Used area, click on a data source to restore it to the Commonly Used area. The data source appears in the Data Sources dialog when you import data.
  5. Click Databases.

  6. In the Commonly Used For drop-down, select Hadoop to work with Hadoop databases.

    or

    Select Database to work with all other databases.

  7. In the Commonly Used For area, click for a data source to remove it. The database moves to the Not Commonly Used area. The database no longer appears in the Data Sources dialog when you import data.
  8. In the Not Commonly Used area, click on a database to restore it to the Commonly Used For area. The database appears in the Data Sources dialog when you import data.
  9. Click Save.

Related Topics

Import Data