How to browse the record from SSAS on the basis of quarterly and yearly using EnteredDate Column

See more:

ASP.NET

SSAS

SQL-Server-2008R2

In my project requirement is some thing like this.

Database Name - NewData TableName - Policy

PolicyAID PolicyNo. ClaimNo EnteredDate
---------------------------------------------
1 MNS123 138317 12/02/2013
2 MNS123 138318 13/02/2013
3 MNS456 138319 14/02/2014
4 MNS789 138320 15/04/2014

Here one PolicyNo can contain more than 1 claim no. with different or same date.I want to show data by this way by using EnteredDate column.

1. No. of Claims per quarter
2. No. of Claims By year

If the record comes in SSAS browser like that then I want to show this record in my asp.net project with drag and drop filter functionality like pivot table and also want to show in chart.