Owner of queries
In Our project,the user only can change and execute their own queries ($user in Role) and they created their queries on Cube. Because some of problem related to data (too many data), we split the cube by year and all reporting become on multiprovider.
We copy all queries from cube to multiprovider (use the same name) and afterthat we change the owner manually in table RSRREPDIR and RSZCOMPDIR. but it's still show no authorization.
Please give the advise what should we do so the user can have autho. again.
Thanks in advance.
NimeshKumar Kapadia replied
May be you need to update following tables aswell..
RSZELTATTR Attribute selection per dimension element
RSZELTDIR Directory of the reporting component eleme
RSZELTPRIO Priorities with element collisions
RSZELTPROP Element properties (settings)
RSZELTTXT Texts of reporting component elements
RSZELTTXT_MULTI Multiline Texts from Reporting Components
RSZELTXREF Directory of query element references
Hope that helps.