Ad

How Can You Cascade Filter The Attributes Of More Dimensions In A SSAS Cube, Viewed In Excel 2007

How can you cascade filter the attributes of more dimensions in a SSAS cube, viewed in Excel 2007.

For example, if we have a cube Sales with the dimension Time and dimension Client, once the dimension Time is filtered to show only the sales from a particular date, if "Client.ClientName" is chosen as a filter in the filter area, how can the list of clients be filtered so that only the clients that have sales in the particular date, be shown.

Ad

Answer

Take a look at www.clicksoft.ro

The product named QuickCubeFiltrator is a wizard like addin for excel 2007 that does cascade filtering. Might be what you need.

Ad
source: stackoverflow.com
Ad