Time for action – viewing the cube in the browser
After creating the cube, you can view it in the cube browser. There are two ways to open the cube browser: through SQL Server Management Studio and through the built-in cube browser in the SSDT. The SSMS cube browser will be useful when we deploy the cube to an SSAS Server (for details on deployment, refer to the Deploying and processing section of this chapter). For this example, we use the SSDT cube browser.
To browse the cube, processing is required. Processing is the process of extracting data from a data warehouse, applying the cube's calculations and structures to it, and loading it into the OLAP cube's structure. Perform the following steps to view the cube:
- In Solution Explorer, right-click ...
Get Microsoft SQL Server 2014 Business Intelligence Development: Beginner’s Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
