How to find the actual owner of a query in BW

[former_member301123]

Hi,

We have upgraded our BW system from 7.0 to 7.5

After the upgrade, when we check the RSRREPDIR table for most of the queries the actual owner has been changed.

Could someone please suggest us on how to find the actual owner of the queries.

Thanks for all in advance.

Regards,

BI Team.

[john_hawk · Accepted solution]

Hi IBM,

I suspect that the owner name was changed due to required programmatic changes of the upgrade or post-upgrade correcting transports.

At this point, consider spinning up your pre-grade backup in a Sandbox system. Have a business case, your Basis team won't want to do it.

John Hawk

[former_member301123 · Accepted solution]

Hi John,

Thanks for the reply.

We will discuss this with the client.

Regards,

BI Team.