posted 5/12/2010 by MikeMollenhour - Views: [1442]
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