Book Image

Microsoft SQL Server 2014 Business Intelligence Development Beginner's Guide

By : Abolfazl Radgoudarzi, Reza Rad
Book Image

Microsoft SQL Server 2014 Business Intelligence Development Beginner's Guide

By: Abolfazl Radgoudarzi, Reza Rad

Overview of this book

Table of Contents (19 chapters)
Microsoft SQL Server 2014 Business Intelligence Development Beginner's Guide
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
Index

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:

  1. In Solution Explorer, right-click on the project Chapter 02 SSAS Multidimensional and choose Process.

  2. You will see a dialog box stating The Server contents appears to be out of date. Would you like to build and deploy the project first?. Answer it by clicking on Yes.

  3. In the Process...