MicroStrategy ONE

Import Data from a BI Source

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

After you have made the report or query available as a web service and obtained the URL of the query, you can import the data into MicroStrategy Workstation.

  • Create a web service to connect to the report or query in SAP BO, Oracle, or IBM Cognos. You must have the URL of the report or query.
  • A SAP BO query cannot include prompts.
  • If an IBM Cognos report contains multiple tables, only the first table is extracted.

To import data from a BI source

  1. Open a new or existing dashboard.
  2. To import data into a new dataset, click Add Data > New Data.

    or

    To add data to a dataset, click the drop-down arrow next to the dataset name in the Datasets panel and choose Edit Dataset. The Preview Dialog opens. Click Add a New Table.

    The Data Sources dialog opens.

  3. Click BI Tools. The BI Sources dialog opens.
  4. Click Add . The Data Source Dialog opens.
  5. Select a data source of SAP BO, OBIEE, or Cognos from the BI Sources drop-down.
  6. Select Show connection string to view the string for connecting to the data source.
  7. Select the Edit connection string checkbox to edit the connection string in the text box.
  8. Enter the user name and password to access the data source in User and Password.
  9. Enter a new name for the data source in Data Source Name.
  10. Click OK.
  11. You can import multiple reports and queries at the same time. Each report or query create an individual table in a cube. Enter the URL for the report or query in SAP BO, Oracle, or IBM Cognos that has been made available as a web service in the Enter URL field. Then, click Add to add the URL to the list of queries.
  12. If you want to preview and modify your data before importing, click Prepare Data.
  13. Click Finish. The data is imported into a new dataset or updated in an existing dataset.

Related Topics

Import Data

Best Practices for Importing Data from a File

Create a Dashboard