How to revert back the dimensions/measures if deleted once?
I know that we can always hide and unhide the dimensions/measures but how about the delete options
Aish, in the data window fields (measures and dimensions) can be hidden, but they can't be deleted. You would have to go to your underlying data source to delete a field. So I can't say I completely understand your question.
Retrieving data ...