Database Reference
In-Depth Information
[DimStores].[Store].AllMembers
,[DimTitles].[Title].AllMembers
) )
} On Rows
From [CubePubsSales]
Where( [Measures].[NumberOfSales] ); -- Not the default measure ([Measures].[SalesQuantity])
Using Your Code in Reporting Applications
At this point, you probably have had enough of MDX to last for quite a while. While there are plenty of other
functions and statements that we could talk about, it is not necessary to memorize them all, or even any of
them. Early on, Microsoft realized that very few developers in the industry can program in MDX. As such, most
of its reporting applications do not require you to do so. For example, as you will see in Chapter 15, you can use
Microsoft's Excel pivot table tools to create cube-based reports without ever typing in any MDX code.
Another application that will generate MDX code for you is Microsoft's reporting server, SSRS. As we will see
in Chapter 17, this can be easily accomplished using a query designer that looks remarkably similar to the cube
browser found on the Browse tab of the cube designer.
You can even generate MDX code using the 2012 version of the cube browser in either Visual Studio or
SQL Server Management Studio (SSMS). We have already seen the Visual Studio option in previous chapters;
therefore, we use SSMS to demonstrate this feature. But both tools work the same. Let's try this in the next
exercise!
exerCise 14-3. Creating MDx with the Cube browser
in this exercise, you generate MDX code using the cube browser that comes with ssAs 2012. You then copy
the code to a new MDX code window, review the code, and remove nonuseful clauses and properties.
Note:
if you have closed sQL server Management studio since the previous exercise, please open it. You can
do so by clicking the start button, navigating to All Programs ➤ Microsoft sQL server 2012 ➤ sQL server
Management studio, and clicking this menu item.
opening the Cube browser
1.
with a connection to the ssAs server established, use the object Explorer window to
locate the CubePubssales cube (Figure
14-34
).
2.
Right-click the cube's icon, and select Browse from the context menu (Figure
14-34
).
This will launch the cube browser.
