Is it possible to view MDX for MyViews from ProClarity sqldatabase? Because some user views are corrupted, we need to correct it. Any suggestions please...
Check out the XMLData column in the BookElements table in the ProClarity DB. The Libraries table has a FAVORITES hidden library that should help you determine which Books from the Books table and BookElements are the user's My Views.