Owner of queries

[Former Member]

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

[Former Member · Accepted solution]

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

[Former Member]

Hi,

Go to t-code rsecadmin and in that authorization object insert your multi provider technical name under the info object 0TCAIPROV.

if this doesnt work post back the exact issue and paste the error log.

Regards

Joga

[Former Member]

Hi Yoga,

Thanks you for your reply.

We already change the multiprovider in Authorization object and Roles, but it's still not working.

Rgds,

Siandari