Searching Dimension Properties from Excel

SQL Analysis Server Cubes allow for properties to be assigned to members. This is a noce feature but it doesn't seem to be exposed by many applications. Natively Excel is one of these apps, however by using the pivot tables extensions for excel addin this is now possible. Here is a link to the Addin: http://olappivottableextend.codeplex.com/ 

After downloading and installing this addin you will now be able to search these descriptions, here is how I tested it. First I added the description through SSAS

After connecting to the cube you can now right click on the pivot table and select the OLAP PivotTable Extensions

Once the Dialog box pops up you can click the Search Tab and type in you search description and it will find it

Now you can click it and add to Pivot Table and your all set