Database Reference
In-Depth Information
Figure 15-12.
The Excel Save As dialog window
2.
navigate to the
C:\BISolutions\PublicationsIndustries
folder (figure
15-12
).
3.
Click the “new folder” button at the top of the save As dialog window to create a new
folder named
ExcelReports
(figure
15-12
).
4.
select the
ExcelReports
folder and save the Excel report file as
SalesReport.xlsx
(figure
15-12
).
now that you have created a report based on a sQl view, we will move on to creating ssAs cube-based
reports, so please leave Excel open for now.
Changing Connection Properties
If Excel forced you to use a single SQL view per spreadsheet, it would be unreasonably restrictive, because each
view may have only some of the data you need. Luckily, you can either add another report to the same Excel
spreadsheet or reconfigure your existing report.
To add a different report to the spreadsheet, restart the wizard and select another view. You can then use the
data in the view to make another report on the same or separate worksheet tab.
To change an existing pivot table report, reconfigure the connection property to point to a different view
within the data warehouse.
