Hi,
Loading from flat file to info cube successful but rollup to aggregates is giving a sql error ORA1438 which is
SQL-ERROR: 1.438 ORA-01438: value larger than specified precision allowed for this column.
I managed to rollup several requests only one request is giving me the above problem.
I don't think it is a data problem because the load to info cube is successful.
I don't think it is a system error because I managed to rollup several other requests from the same cube.
Please let me know in case anyone comes across this before.
Thanks
Naga