SSAS CUBE-How to maintain the deleted table records in SSAS CUBE

We created sample testing cube in ssas,the scenario is maintain the deleted table records in cube.

example:

   Table A

id        Number  Name

1         1001      A

2         1002       B

i processed the cube,records are available in cube,if i deleted the above table records at the time i need to maintain that records into Cube?

please  revert ur reply!!

Clean way to implement would be to have a new column to indicated deleted row in your table .. So instead of hard deleting you do soft delete on the records.

   Table A

id        Number  Name Is_deleted

1         1001      A       1

2         1002       B      0

Then you can create a dimension table (delete status ) with two records

id   Name

1   Deleted

0  Not deleted

You can then slice and dice the records and use the  delete status dimension for your queries.