Mashup - Filter Hypercube on Dimension at Creation
I am creating a hypercube then using its data to create a table. I would like to pull limited data sets then pull specific data sets after a user has selected something. Where in the create cube statement can I put in the filter?
Ex. - Hypercube consists of cities and 20 measures for each city. I would like it to just contain information for one city then once a user inputs a city re-run the hyper cube for just that city, thus avoiding unnecessary pulls and the 10000 cell limit.