Can anyone let me know how [XMLDATA] column of MDstore table gets updated?
As per my understanding this field contains details of cube information and updated when user save any report in my view.
When we create new report in my view, XMLData of MDstore table gets update with for CUID of new report.
For one of user we want to clear the [XMLDATA] column;but we dont want to do this from backend.
It will be great help if some one let me know the procedure to clear the field from Front end.
We have done some change in cube structure (Hide some of Time Hierarchy attributes) and after this change when user opens proclarity report saved in my view starts to get missing data wizard. Some of user not able to find the exact replcament and clicked on check box not found replacement to fix this issue.
After that when user try to open any report from My View getting error Page is disabled because item from multiple Dimention are mapped to single Dimension [Even they are able to create new report but after saving it they are not able to open it.]
To resolve this issue, we have delete all report save in my view section but no luck.
For one user after deleting all report from My view section ,[xmldata] field of MDsore table become empty (except header and footer section of XML data) and afterward issue got resolved .but this is not happing for other users. So we want to know the procedure to clear this field or any alternative to solve this issue.