ou can include dimensions and measures from external data sources in your analyses. The external data is loaded to the database, but is not part of the BI metadata catalog. You can create an analysis that include only data from an external source, or you can blend dimensions and measures from the external data source with dimensions and measures defined in the BI metadata catalog. The external data must be stored in a Microsoft Excel format spreadsheet file. You import the data from the spreadsheet file into the BI EE database as an external data source. You then add columns from the external data source to your analyses. When the data in spreadsheet file changes, you can refresh the BI EE database with the changes.