ORA-00936: missing expression

[Former Member]

Hi there,

i created a very simple query, which contains a hierarchy. the query is based on a DSO.

i just made a few changes in the DSO. refilled master data and text data of the hierarchy base infoobject.

now i get an error message when i try to open the query:

ORA-00936: missing expression

then the bex analyzer cancels the connection to the BI.

when i take out the hierarchy from the query, it works. it put it back in, the same error occurs again.

hmm...

btw, i am using bi 7.0 and the old bex analyzer.

thanks a lot for ideas in advance!:)

stefan

Message was edited by:

Stefan Voltz

[Former Member]

ok now it works again, for whatever reason...

all i did was click through the base infoObject and its hierarchy to see whether i can reactivate anything.

i didnt really do anything.

i'm sure the problem will occur again at some point. so dont hesitate if you have an idea.

regards,

stefan

i'll reward points;)