Microsoft® SQL Server 2012 Unleashed

Browsing Data in the Cube

You’re ready to browse some cube data now. There are several ways to view data in a multidimensional cube. OLE DB for OLAP and ADO MD expose interfaces to do this kind of data browsing, and many leading vendors have used these interfaces to build front-end analysis tools and ActiveX controls. These tools should prove useful for developers of user interfaces in data warehousing and data mart projects. You can also easily browse a cube’s data from either Visual Studio or SSMS or via any tool or facility that uses the multidimensional extensions of SQL (that is, SQL with DMX and MDX extensions).

To browse your newly created cube from SSMS, you fire up SSMS and connect to the SSAS server (Analysis Services server type) on ...