1 person found this helpful
You could create a copy of the application then write an MDX clear script to clear the data you are not interested in.
Then in the original cube create another MDX clear script.
More information at Clearing Data from Specific Regions of Aggregate Storage Databases
Also take a full backup before making any changes though.
Thanks John.. i am trying in development and will share the output.
It worked. thanks alot