Change Ownership of Query

[Former Member]

In our system, if developer A creates a query, only developer A will be able to make changes to the query. Is there a way to change the ownership of a query that developer A made to developer B in the case that developer A wins the lottery and leaves the company? If so, please describe the process.

As a side question, is this a "best practice"? It seems short-sighted to only allow the query creator to make changes to the query. Especially considering that there could be universes, webi, etc all built off of a single query and if that query developer gets hit by a bus, everything has to be rewritten (assuming there is no way to change the ownership).

[umashankar_poojar]

Hi Jason,

     If all these responses are not helping, even I feel the Standard BEx transport is stopping you to change the query when someone already changing it. In a way agree with Anand Mehrotra

Do this, find out the request which is currently locked the query. Goto SE03 tcode and put the request and unlock it.

Remember if the request has task, then first unlock the task and later request.

Hope it helps!

Thanks,

Umashankar

[Former Member]

Due to management policies, resolving the issue by granting 0BI_ALL in dev to all developers is not an option. Management fears that granting 0BI_ALL opens up the HR cube which has highly sensitive information. So I need to know how one would go about changing the ownership of a query to another developer to allow for non-creator query modifications.

[Former Member]

Copying the query and renaming it is an easy fix, but in some cases we have universes, webis, etc. built on top of the queries. Renaming the query won't help in these cases. We need to truly change the owner.

[former_member182470]

Hi Jason,

             You have discarded the most suitable solution for your issue. You say there is a sensitive information in HR cube. I am just wondering on one thing here. This is just a Dev system. Why is your mgmt worrying about Dev data? They should worry about Prod data.

             As you say, copying a query is also not possible in your case because of BO in place. You have locked both solutions. I strongly feel you can assign 0BI_ALL as I told you in my first reply.

Regards,

Suman

[anshu_lilhori]

Hi Jason,

If both the option which we suggested is not helping in your case then another option is to change the owner of the query directly in a table through a small ABAP program if i in case you cannot edit the table directly.

Check out the below thread which speaks about the same,

http://scn.sap.com/thread/1391381

Hope this helps.

Regards,

AL

[Former Member]

Hi Dear Jason,

This is the problem of object locking in transport request. Please create global request , so that all the query changes objects are in global request any user can modify query otherwise user who has created request can modify.

Regards,

Anand Mehrotra.

[KamalMehta]

Hi Jason,

In our system all the developers are given access for 0BI_ALL and they can change any Bex query in Dev but whenever we are doing changes they are collecting in Bex Transport with the owner who is authorize to approve BW Transports.

Thanks

[former_member182470]

To avoid all such problems, we should give 0BI_ALL access to all developers in Dev system.

Any one can work on any query. But keep an eye on query transports to target systems. Review the TRs before moving...

[anshu_lilhori]

Hi Jason,

To me it seems the authorization issue--You can check the query role for it.

Lot of threads are available on the same issue.A simple search would have given you lot of idea.

https://scn.sap.com/thread/374572

Hope this helps.

Regards,

AL

[Former Member]

Hi Jason,

Seems to be an authorization issue, system is not allowing to modify a query. Can you check with Basis/Security team for same.

They can keep trace and find out which objects are missed in authorization.

Regards,

Ganesh

[RamanKorrapati]

Hi Jason,

Any one can change the query if he have required authorizations on specific bex query.

So take basis team help and give the authorizations required user(B).

- RSECADMIN. need to play with roles and profiles.

Thanks