Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Owner of queries

Hi All,

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.

Siandari

replied

Hi,

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.

Regards

Mr Kapadia

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question