I have deleted all contents of my basic cube by deleting all requests. I have confirmed that deletion was succesful but when I checked the F-fact table I've found out that its enties have not deleted. Is this possible?(I thought deletion of all contents also means deletion of all entries in F table.) If not, please tell me what possible reason for this error.
Your response would be greatly appreciated.
Thanks in advance,
Not sure this helps.. but still, Let me share my view..
1) It looks like you have many requests in the cube and the display may be set to view only this month requests and you have deleted the requests by selecting one by one.. So can you check the display month on the bottom of the manage option and keep changing it to very old date??
Also you can use right click->delete data option to remove fact and dim table data completely.. Please ignore this reply if you had tried this earlier..
By the by Welcome to Forum.. Even though above is not the reason, I am sure you will get a good answer in this nice forum..
All the best!!