5 Replies Latest reply on Jul 24, 2014 10:37 AM by JohnGoodwin

    ODI 11g  &  Essbase



      I've a problem with connecting to Essbase from ODI.

      I can connect and retrieve Essbase metadata using ODI 11g. so i can create model and view sample data there.

      although it gives me in message tab when reverse engineer meta data:

      2014-07-23 00:44:39.101 WARNING EPMOHPS-20350 Unable to parse UMC from Essbase. Will continue assuming that cube is not spun from Studio. Parsing problem : java.lang.ClassNotFoundException: com.hyperion.cp.clients.util.UMCParser


      but i can see Essbase dimension and cube in my model and use them in my interfaces.


      the problem is that when I create an interface that sends data from a table to Essbase dimension , when i execute the interface i get this error :


      java.lang.IllegalArgumentException: Driver name cannot be empty
        at org.springframework.util.Assert.hasText(Assert.java:161)
        at com.sunopsis.sql.SnpsConnection.setDriverName(SnpsConnection.java:302)
        at com.sunopsis.dwg.dbobj.DwgConnectConnection.setDefaultConnectDefinition(DwgConnectConnection.java:380)
        at com.sunopsis.dwg.dbobj.DwgConnectConnection.<init>(DwgConnectConnection.java:274)
        at oracle.odi.core.datasource.dwgobject.support.DwgConnectConnectionCreatorImpl.createDwgConnectConnection(DwgConnectConnectionCreatorImpl.java




      I tried JohnGoodwin blog post ( More to life than this...: ODI Series Part 1 ) but i couldn't find any adapter for ODI 11g and Essbase at edelivery.oracle.com. (version problem?)


      I downloaded ODI companion 11g and copied all of oracledi.sdk folder (bin , javadoc , lib) contents in







      and i added companion xml-references KMs to my project.


      but the error still remains.







      Windows Server 2008 R2 64bit


      Oracle DB Server:

      same as Essbase server.



      version :

      machine is different from Essbase server.

      RCU data is on Essbase machine DB.










      would you please help me?