This discussion is archived
2 Replies Latest reply: Dec 6, 2012 10:42 PM by 883712 RSS

Essbase Error: Unknown Member

883712 Newbie
Currently Being Moderated
run sql in Administration :

SELECT 0 s_0, "HZY_PRO"."Measure"."Sales" s_1 FROM "HZY_PRO" WHERE ("Period"."Gen5,Period" = '1101')

return error:

Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 96002] Essbase Error: Unknown Member [Period].[1101] used in query (HY000)
SQL Issued: set variable LOGLEVEL = 0;SELECT 0 s_0, "HZY_PRO"."Measure"."Sales" s_1 FROM "HZY_PRO" WHERE ("Period"."Gen5,Period" = '1101')


but running sql as following is OK:

SELECT
0 s_0,
"HZY_PRO"."Period"."Gen5,Period" s_1,
SORTKEY("HZY_PRO"."Period"."Gen5,Period") s_2,
"HZY_PRO"."Measure"."Sales" s_3
FROM "HZY_PRO"
WHERE
("Period"."Gen5,Period" = '1101')

why should "Period"."Gen5,Period" be in select clause?

Thanks a lot.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points