在部署立方的时候,报错以下错误:
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "OLAPSYS.CWM2_OLAP_UTILITY", line 1660
ORA-01403: no data found
ORA-06512: at "OLAPSYS.CWM2_OLAP_CUBE", line 33
ORA-06512: at "OLAPSYS.CWM2_OLAP_CUBE", line 55
ORA-06512: at "OLAPSYS.CWM2_OLAP_CUBE", line 386
ORA-06512: at line 10
拿到SQL*Plus中运行可以得到出错信息如下:
AMD-00001 create cube "EXPENSE_WH.REL_EXPENSE"
AMD-00001 create Measure "EXPENSE_WH.REL_EXPENSE.EXPENSE"
AMD-00100 nof found Dimension "EXPENSE_WH.REL_CATEGORY"
.....
看来,没法找到所需要的dimension
但之前:dimension的deploy都成功了,cube部署时,Deployment OPtions: Deploy to Catalog only
请教各位,如何解决?
谢谢先。