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 ...
Get Microsoft SQL Server 2014 Unleashed 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.
