Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

error in obiee 12c analyze

Question
1
Views
0
Comments
Ali Jafarinoor
Ali Jafarinoor Rank 1 - Community Starter
edited Aug 13, 2024 7:11PM in Oracle Analytics Cloud and Server

hello everyone I use obiee 12c

i just create a cube with just one dimension in awm but when i want to create a analyze in obiee i get the following error:

in my workspace (sample) I have 7 cube and 12 dimension . all of them work fine apart from this!!!

Error Codes: OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65P

State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. (HY000)

State: HY000. Code: 43113. [nQSError: 43113] Message returned from OBIS. (HY000)

State: HY000. Code: 17001. [nQSError: 17001] Oracle Error code: 34492, message: ORA-34492: Analytic workspace object SAMPLE.SAMPLE!MOJAVEZ_SUM_C does not exist. measure mojavez_sum_c from MOJAVEZ_SUM_C dimension ppmdate_id as varchar2(200) from PPMDATE with attribute ppmdate_level as varchar2(200) from PPMDATE_LEVELREL hierarchy PPMDATE_PARENTREL(PPMDATE_HIERLIST 'HIC1') inhierarchy PPMDATE_INHIER loop optimized row2cell r2c ^ at OCI call OCIStmtExecute. (HY000)

State: HY000. Code: 17010. [nQSError: 17010] SQL statement preparation failed. (HY000)

SQL Issued: SELECT s_0, s_1, s_2, s_3, s_4, s_5, s_6, s_7 FROM ( SELECT 0 s_0, CAST(NULL AS VARCHAR(1)) s_1, CAST(NULL AS VARCHAR(1)) s_2, "SAMPLE - مجوز خريد"."مجوز خريد"."SUM_C" s_3, 'Total' s_4, CAST(NULL AS VARCHAR(1)) s_5, IDOF("SAMPLE - مجوز خريد"."PPMDATE"."PPMDATE"."Total") s_6, CAST(NULL AS VARCHAR(1)) s_7 FROM "SAMPLE - مجوز خريد" UNION ALL SELECT 1 s_0, "SAMPLE - مجوز خريد"."PPMDATE"."TOTAL - Short Description" s_1, CAST(NULL AS VARCHAR(1)) s_2, "SAMPLE - مجوز خريد"."مجوز خريد"."SUM_C" s_3, 'Total' s_4, IDOF("SAMPLE - مجوز خريد"."PPMDATE"."PPMDATE"."HIC1 - TOTAL") s_5, IDOF("SAMPLE - مجوز خريد"."PPMDATE"."PPMDATE"."Total") s_6, CAST(NULL AS VARCHAR(1)) s_7 FROM "SAMPLE - مجوز خريد" WHERE IDOF("SAMPLE - مجوز خريد"."PPMDATE"."PPMDATE"."Total") IN (1) UNION ALL SELECT 2 s_0, "SAMPLE - مجوز خريد"."PPMDATE"."TOTAL - Short Description" s_1, "SAMPLE - مجوز خريد"."PPMDATE"."year - Short Description" s_2, "SAMPLE - مجوز خريد"."مجوز خريد"."SUM_C" s_3, 'Total' s_4, IDOF("SAMPLE - مجوز خريد"."PPMDATE"."PPMDATE"."HIC1 - TOTAL") s_5, IDOF("SAMPLE - مجوز خريد"."PPMDATE"."PPMDATE"."Total") s_6, IDOF("SAMPLE - مجوز خريد"."PPMDATE"."PPMDATE"."year") s_7 FROM "SAMPLE - مجوز خريد" WHERE IDOF("SAMPLE - مجوز خريد"."PPMDATE"."PPMDATE"."HIC1 - TOTAL") IN ('TOTAL_1') ) djm FETCH FIRST 65001 ROWS ONLY