EXTRACTING ESSBASE ASO Application META DATA TO ORACLE SQL(RDBMS)
927689Mar 31 2012 — edited Apr 4 2012Hello
I wanted to extract metadata from an ASO application into my RDBMS( m using oracle sql+)
First i created a new model using the essbase technology and logical schema & then reversed it.
I got all my essbase dimensions ( measures, products, age, stores, times, etc) into my models perfectly.
Now i want to to get measure dimension metadata into oracle sql +, for that i created another model connecting to Oracle database
Before that i had define the columns into appropriate database & appropriate table & it got reflected into my model
Now for connection between these two i had created an interface selecting tables from both as source & target & define KM as "LKM Hyperion essbase metadata to sql" & "IKM SQL to file append" Staging area as "sunopsis memory engine" .
During mapping it doesnot show any error but while executing it giving error as
11 : 37000 : java.sql.SQLException: Unexpected token: MEMBER in statement [LOA.Member]
java.sql.SQLException: Unexpected token: MEMBER in statement [LOA.Member]
at org.hsqldb.jdbc.jdbcUtil.throwError(jdbcUtil.java:62)
at org.hsqldb.jdbc.jdbcPreparedStatement.executeUpdate(jdbcPreparedStatement.java:412)
at com.sunopsis.sql.SnpsQuery.executeUpdate(SnpsQuery.java)
at com.sunopsis.dwg.dbobj.SnpSessTaskSql.execStdOrders(SnpSessTaskSql.java)
at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTaskTrt(SnpSessTaskSql.java)
at com.sunopsis.dwg.dbobj.SnpSessTaskSqlC.treatTaskTrt(SnpSessTaskSqlC.java)
at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTask(SnpSessTaskSql.java)
at com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(SnpSessStep.java)
at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java)
at com.sunopsis.dwg.cmd.DwgCommandSession.treatCommand(DwgCommandSession.java)
at com.sunopsis.dwg.cmd.DwgCommandBase.execute(DwgCommandBase.java)
at com.sunopsis.dwg.cmd.e.i(e.java)
at com.sunopsis.dwg.cmd.h.y(h.java)
at com.sunopsis.dwg.cmd.e.run(e.java)
at java.lang.Thread.run(Unknown Source)
Please help me in sorting out this issues.
Edited by: 924686 on Mar 31, 2012 5:53 AM