Hello.

First of all, sorry for my poor english.

I am developing a scorecard with two types of KPIs. 6 of them are sliced by OrderDate and 4 are sliced by ShipDate. I need to create a dashboard with only a date filter and it must work like this example

DateFilter: Jan-2013

* OrderDate based KPIs: show the number of orders, etc. made in Jan-2013

* ShipDate based KPIs: show the number of orders, etc. shipped in Jan-2013

All the KPIs are based in the same Fact Table.

I think the solution is to use a ConnectionFormula + LinkMember MDX function between the filter and the scorecard but i don't know how to implement this funcion based on each KPI.

Thanks for all