Retail Resources

BI Tips: Importing External Datasets

May 03, 2015 — Ashia Coleman
importing_external_databases.jpg

In Report Builder, you can use the import tool to use datasets that you’ve previously created! This can save you lots of time when creating similar reports. No need to re-invent the wheel when you can import the wheel.  :)

bitipsreportingexternaldatasets.jpg

Steps:

If you’re using one of our Report Builder Templates:

  1. Choose the template you would like to use, and select “Edit in Report Builder” from the drop-down menu.
  2. Right-click on the dataset “Main” > Dataset Properties.
  3. Click on “Import” in the bottom-right corner (Image 1).
  4. Select the report that contains the dataset you would like to reuse (Image 1).
  5. Choose the dataset you would like to import and click “Import” (Image 2).
  6. From here, you can either click “OK” if you’re done or on “Query Designer” if you’d like to make further edits to the query.

bitipsreportingexternaldatasets2.jpg

If you’re starting from a blank report:

  1. In Report Builder, right-click on the “Datasets” folder > Add Dataset.
  2. Click on “Import” in the bottom-right corner (Image 1).
  3. Select the report that contains the dataset you would like to reuse (Image 1).
  4. Choose the dataset you would like to import and click “Import” (Image 2).
  5. From here, you can either click “OK” if you’re done or on “Query Designer” if you’d like to make further edits to the query.

If you have any questions about this feature or BI in general, please contact your Account Manager directly.

Topics: Business Intelligence

Recent News

Comments