Strategy ONE

Import Data from a BI Source

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.
  1. Create a document or open an existing one.
  2. Choose Data > Add Dataset.
  3. Click Add External Data.
  4. Click BI Tools.
  5. Click Add . The Data Source dialog appears.

  6. Select a data source from the BI Sources drop-down.:

  7. Select Edit connection string to edit the connection string.
  8. Enter your credentials.
  9. Click Save.
  10. Enter the URL for the report or query in your data source that has been made available as a web service in the Enter URL field.
  11. Click Add.
  12. Click Finish.