I decided a cube and using Office Web Component - PivotTable to display the
value.
and I would like to select the latest date information or the date has
greatest value.

How can I set it up the filter in OWC - PivotTable?

I do it like this, in my case the date selected should be of yesterday; so i
create the uniquename as per my time dimension and set the includedmembers =
the unique name.

refer the code below; hope this helps you out.

Dim strUniqueName
strUniqueName = "[Time].[" & Year(Date-1) & "].[Quarter " &
DatePart("Q", Date - 1) & "].[" & MonthName(Month(Date-1)) & "].[" & Day(Date
- 1) & "]"
'msgbox strUniqueName

PivotTable1.ActiveView.FieldSets("[time]").Fields("Month").IncludedMembers =
Array("")
PivotTable1.ActiveView.FieldSets("[time]").Fields("Day").IncludedMembers
= Array(strUniqueName)

Regards,
Yash


"Kam" wrote: