2 Replies Latest reply: Dec 7, 2012 12:42 AM by 883712 RSS

    Essbase Error: Unknown Member

    883712
      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.