authorization error while opening a query
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?