Welcome back to our informative series on Excel by Steve Hughes! In his first post, he conquered the Quick Explore feature. In this post, Steve will delve into the Show Explore feature. Join Steve as he shows you how you can drill into details using the Show Explore feature once you've connected your SSAS cube to Excel.
So, you have connected Excel to your SSAS cube. You really wish you could easily drill to details using Excel. You can do this in Excel 2013 by double clicking the cell or right clicking the cell to get the shortcut menu which includes the option as well.
It is really cool that you can just double-click the cell and get there directly. By default, it returns the first thousand rows of detail from the underlying cube data.
You can change this in the connection options for your SSAS connection.
One “gotcha” on this is that It doesn’t work on a calculated cell, but it works fine on standard measures. If you use a lot of calculated members, you will get the error in both cases. So if this option is important for the users of a specific calculation, you may need to get it into cube as a standard, not calculated, measure.
Have questions about Excel? Submit your questions in the section below and Steve will be more than happy to answer them!