Selective deletions in Infocube and DSO
I have a requirement where our Basis is performing Re-org in BW.
For this I have to delete the data which is older than 13 months from all the data models( Cubes, DSO's) which I have list of.
Now when I delete the contents from DSO with selective deletions in fiscal year period it would delete from active data table.
I need to delete the same consistently in all the tables Change log and new data table as well.
How can I achieve this.
Selective deletion from Infocubes.
When I do selective deletion from cube it would delete from fact table. How would it delete the same selections from Dimensions.
I need to delete the same all the dimension tables and fact table and if view needs to be deleted as well.
Please advise so that I have consistent deletion.