Hi all

I am using the Microsoft.AnalysisServices DLL to access my Cubes KPIs. From here I can set a Value, Goal etc.

What I am trying to do now is apply a filter to the KPI, for example all values for the year 2004 and the manufacturer 'Good Year'.

From BIDS I can do this from the browser screen from within the KPI tab.

How can I achieve this from C#? the KPI object doesn't appear to have any filtering properties or methods.

Thanks in advance.

Graham

Submitted via EggHeadCafe - Software Developer Portal of Choice
AJAX Web Service Driven Customers Table With Customer Details
http://www.eggheadcafe.com/tutorials...r-details.aspx

Hi, you can execute simple MDX query that uses KPIGoal, KPIValue
functions to retrieve value and goal of KPI. In such query you can add
where clause that filters data. It would look like this:

SELECT KPIValue("your kpi") on columns
FROM YourCube
WHERE ([Date].[Year].[Year].&[2010])

Hope this helps,

Piotr