Home » SQL & PL/SQL » SQL & PL/SQL » Error ORA-00932 when viewing data from an OLAP cube
Error ORA-00932 when viewing data from an OLAP cube [message #680702] Tue, 02 June 2020 03:42
Messages: 1
Registered: June 2020
Junior Member
I'm using Oracle AWM to create an OLAP cube with three dimensions.

After the creation of the dimension and the mapping of the cube I use data validation to check the data and it's all right. Then, I maintain the cube in order to load the data and it all works, without any error. When I try to "View the cube" in gives me an error:

ORA-00932: inconsistent datatypes; expected CHAR, got NUMBER.
In the log the error is reported three times, so I'm assuming it's one for each dimension, but it doesn't specify where the error is. I have double checked the datatype of the table columns mapped to the levels of the dimensions and they are consistent with the type of data in it (some are varchar2, other are number).

As I said, when I maintain the cube and when I do data validation it gives no error/warning, so I can't understand what's wrong. Can you please help me?

Thank you a lot
Previous Topic: count per group
Next Topic: Split Comma seperated Value
Goto Forum:

Current Time: Sat May 15 03:57:37 CDT 2021