Database Reference
In-Depth Information
Adding data from other data sources
As described earlier, you have the ability to add data from other types of data sources
when working with Analysis Services in the tabular mode. In the next two steps you
will first add data from a text file and then from a report. To add data from a file per-
form the following steps:
1. First of all you need to create the file. Open up
SQL Server Management
Studio
and connect to the instance containing the
AdventureWorksDW2012
database.
2. Type the following query:
select * from
AdventureWorksDW2012..DimProductSubcategory
3. Press
Ctrl
+
E
on the keyboard to execute the statement.
4. Right-click on the
Results
grid and select to save the results as a comma-
separated file:
5. Save the file as
ProductSubcategory.txt
.
6. Open the file in Notepad and add the column names on the first row.
7. Save the file in the UTF-8 format from Notepad.
Search WWH ::
Custom Search