MDX query to filter the cube
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. |
All times are GMT +1. The time now is 02:12 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com