BI Tips: Importing External Datasets

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.