O'Reilly logo

Microsoft SQL Server 2014 Unleashed by Paul Bertucci, Alex T. Silverstein, Chris Gallelli, Ray Rankins

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required