1 Reply Latest reply: Jan 29, 2013 6:05 PM by user3715462 RSS

    Unable to create user-defined table in essbase studio 11.1.2

    user3715462
      Hello all,

      Essbase studio 11.1.2 on Windows 7 and source is oracle database 11gR2

      trying to create a user-defined table in Essbase Studio

      This sql statement ran fine in Toad for Oracle but when plugged in
      User defined-table in Essbase Studio, i always get the error below.

      Can someone please advise?
      Thanks,

      Kev


      Select Unique TO_CHAR(T1.TRANSDATE, 'YYYY') as YEAR,
      TO_CHAR(T1.TRANSDATE, 'MM') as MONTH,
      TO_CHAR(T1.TRANSDATE, 'MONTH') as MONTHNAME, T1.TRANSDATE
      From SALES T1;


      Error during importing of the source 'VIEWTIME'. Line = 1.
      Sql exploration exception.
      driver.DriverException.GetDatabaseInfoFailed
      ORA-00911: invalid character