I am getting the error for the dimension object in Webi report based on Oracle database.
Error - illegal use of long data-type
In Oracle database Object data-type is long() where as in Universe it has long-text by default, the object values in database is (Null)
Can any one help me to resolve this issue.
ORA-00997: illegal use of LONG datatype
Cause: A value of datatype LONG was used in a function or in a DISTINCT, WHERE, CONNECT BY, GROUP BY, or ORDER BY clause. A LONG value can only be used in a SELECT clause.
Action: Remove the LONG value from the function or clause.
I would suggest you to create separate object on universe with defination like
=TO_LOB(actual column having LONG datatype)
I hope this will help.
If any other issue let me know.