Can we have different target values based on the filter

I am pulling the analysis services KPIs in MOSS. I have a analysis filter connected to the KPI web part.

I am filtering the KPI actual values using a dimention by the means of filter webpart.

The question here :

1. Is it possible to have different target values based on the filter value selected.

2. If yes, where do I need to save the target value and dimension name mapping?

Please help me understand this as I am new to both sharepoint and analysis services.

Regards,

Sahil

[540 byte] By [Sahil] at [2008-2-21]

«« Where to Store Code?
»» HOW TO: Loop Through a DataGrid and send it to a SQL database

# 1

Hi Sahil
While creating KPIs in SSAS, you are giving the Goal Expression and Value Expression. By default both are filtered as per the dimension attributes and hierarchies. Lets say there is a KPI for Revenue and Units Sold. If you want different target values, you need to have a separate table say FactTarget containing targets for Revenue and Units Sold for say a particular product,time , category..other dimensions. Your Goal Expression will be a measure from the FactTarget table containing sales details for the product with category, time...dimensions and the value expression will be from say FactSales table. When you are passing filter values from dimension tables, the KPI Goal and Value Expressions will be filtered by default. So if you select say for year 2006 for Revenue KPI, the Goal Expression will be the Revenue measure from FactTarget table where as the Value Expression will be the Revenue measure from the FactSales table and both these will get filtered for the year 2006.

Thanks
Guruprasad Karnik

gpk2005 at 2007-9-13 >