MDX query to filter the cube

[sourav.dhar]

I have to populate a pivot table using VSTO. I am using source of the pivot
table as an analysis cube. I am using

pivotCache.CommandText = "<name of the cube>";

pivotCache.CommandType = Microsoft.Office.Interop.Excel.XlCmdType.xlCmdCube;

but my requirement is to show a filtered cube.

I think an MDX query as commandText can do this. But I am not being able to
write the correct MDX that can give a filtered cube which I can use to
populate pivot table?

I have used MDX query as "select from <cube name> where <filter
condition(s)>" . But it is showing that no column found that excel can use.

Plese help me to prepare the MDX query.