In your first screenshot it looks like you have not set the staging area to a sql logical schema, it seems to be set as the target essbase which is not allowed.
JohnGoodwin !!!! Thank you!
but another error raised.
now when i execute the map i get :
org.apache.bsf.BSFException: exception from Jython: Traceback (most recent call last): File "<string>", line 26, in <module> at com.hyperion.odi.essbase.ODIEssbaseDataWriter.loadData(Unknown Source) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:606) com.hyperion.odi.essbase.ODIEssbaseException: com.hyperion.odi.essbase.ODIEssbaseException: Invalid column type specified for Data column [ParentName] . . .
I checked the ParentName in source and target in source it is varchar2(80) and in Essbase is String.
i checked UNICODE_IN_DATA in IKM Essbase(DATA) KM. but error remains.
There is not any error in error log file.
In your original question it was about loading metadata and now it is about loading data, does the metadata interface work now?
If you are trying to load data then your mappings are incorrect as it is indicating you are trying to map parent name to data.
JohnGoodwin !!! I'm so sorry!
Actually I was confused about Essbase and relational databases Terminology about metadata.
I thought when we are talking about metadata we are talking about columns.
after your hint I read your post More to life than this...: ODI Series - Loading Essbase Metadata again.
but when we are going to fill the cube we should use DATA IKM?
Thank you John again!
You helped me another time