Excel 2007 : OLAP pivot table automatic filter

Hi, i have a question about how to change an OLAP pivot table's date filter automatically. See the attachment, i have a pivot table generated from an OLAP service (that means i can't see the database, i can only make pivot tables) and i wanna see the numbers up-to-date everyday, i mean when i open the file on the 3rd of june the pivot table automatically filters the table as of 3rd of june. Is it possible? The important point again is i cant see the database (i mean in the sample attachment i cant see the sheet2, i can only see pivot table)
thanks