I'm creating an SSAS cube (SQL 2012), one of the purposes of which is to expose data to a .NET UI which contains a number of filters/search features, allowing users to query the data. In the existing SQL Server DB, we make use of Full Text Search to help with text-based filters/searches.
I've looked around for more information about implementing FTS on an SSAS cube, specifically to search Dimension members and filter by Measure values but it seems to be very thin on the ground.
Can FTS be implemented on an SSAS cube? If so, is it recommended or is there a better way of achieving this result?
There is no out-of-the-box support for Full Text Search in the sense that dimension members and measure values are indexed to support FTS. Generally speaking, filters are applied at query time. There are several ways to do this with MDX with varying degrees of impact on performance.