Database Reference
In-Depth Information
Now you can connect to your cube using Excel and try the new drillthrough action.
You can access this by right-clicking on a cell within a PivotTable that is accessing
the Fact Internet Sales measure group.
When you execute the action, a new sheet will open in Excel with the result of the
query. A drillthrough action automatically filters the result based on what cell you
are clicking on. This means that the drillthrough defined in the preceding screenshot
will get the transactions for Mountain Bikes Sales in 2005, as shown in the following
screenshot:
Search WWH ::




Custom Search