Sampling data with the Excel 2007 data mining add in

 have used the sample tool in the Excel 2007 before but I never thought that I could do this directly on a data source, only on an Excel 2007 table, but you can. I am using SSAS 2008, as the data source, and the Excel 2007 data mining tools for SSAS 2008.  This can be useful evenn if you do not want to use the data mining add ins and only collect data for a pivot table. You cannot join tables in this tool, only select single tables or views.