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.