When filtering with Date.Fiscal Date using the data does not show for the OLAP excel report.
We are currently evaluating this issue for a fix in a future service pack.
Steps to Duplicate
1. Click Analysis tab 2. Click OLAP Excel reports 3. Select Designation Analysis 4. Click create workbook 5. Add a PivotTable Field for Revenue Amount FYOY 6. Click on the Date.Fiscal Date and filter 7. The data goes blank