Database Reference
In-Depth Information
Figure 2-61.
The Process Database and Process Progress windows
2.
Click Run. visual Studio will tell SSAS to start processing data from the data
warehouse into your SSAS objects. visual Studio will display a Process Progress
dialog window.
3.
when the processing completes, a status message of Process Succeeded will
appear. Click the Close button to exit the Process Progress dialog window, and click
Close again to exit the Process Cube dialog window.
in this exercise, you added an Analysis Server project to your existing visual Studio solution and then built,
deployed, and processed the SSAS database. Since the SSAS database now has data, you can create reports
based on it. The next step of a Bi solution is to create a report and verify that the data is clean, consistent
and useful.
Creating Reports
Both the cube and the data warehouse now have data, so let's create some reports. Microsoft has a number of
reporting tools that can be used, but we take a look at its server-based reporting tool, SQL Server Reporting
Services (SSRS).
