authorization error while opening a query

[Former Member]

Hi All,

We have a new installation of BW NW2004s up and running. We are on Patch 7 on the back-end and patch 2 on the front-end. We can develop almost all objects on the back-end (with dumps here and there) but we can not execute any queries (both content and custom queries) the error message we get is "error occurred in the communication with the BW server, could not determine a value for variable 0DAT from the authorizations". This is in the sandbox so we all have "SAP ALL" authorization.

Has anybody come across this issue? What could be the cause/solution?

Thanks,

Paul.

[Former Member · Accepted solution]

Hi,

Do you have 0DAT variable installed from a business content?

If not, install it.

Best regards,

Eugene

[Former Member · Accepted solution]

Thanks Eugene, this worked for me.

Paul.

[Former Member · Accepted solution]

Hi Paul,

If you problem has been solved, please close the thread either by rewarding points or by choosing Solved on your own option.

Best regards,

Eugene