Why I created a blog

Its been many years since I first created this blog. It has remained true to Essbase and related information over those years. Hopefully it has answered questions and given you insight over those years. I will continue to provide my observations and comments on the ever changing world of EPM. Don't be surprised if the scope of the blog changes and brings in other Hyperion topics.


Friday, July 10, 2009

2nd Addendum to Data Export

OK, I'm starting to see why people don't like Data Export. I'm trying to export a particular set of data to a relational table and for some reason, one of the dimensions is not showing up in the table. If I change the export to write to a file, the column is there. It is interesting that the order of the row members is different in the flat file than in the relational export. What appears to be happening is it is taking one of my two dense dimensions which shows up as the last row member before my data vailes in my flat file and is moving(or perhaps overlaying) what is my second row member in the flat file. I know that is clear as mud so to show you an example a row my flat file export looks like:

Actual,r1,aaa1,bbb1,ccc1,ddd1,eee1,Tier1,123456.789

In the relational it looks like:
Actual,Tier1,aaa1,bbb1,ccc1,ddd1,eee1,blank,123456.789

so it is shifting or overwriting the R1 with Tier1 and where tier1 should be is blank.

If anyone has figured a workaround for this other than to export to a file and load it into relational, let me know. In the meantime I'm opening a SR with Oracle and se eif they have a fix

5 comments:

maxim_k said...

Try to set DataExportDynamicCalc OFF

GlennS said...

For what I'm doing I need Dynamic calc set to on. The odd thing is it works when exporting to a flat file but not to relational

Marco said...

Hi Glenn, any possibility to clear data in the relational table during the essbase pushing dataexport before to populate again the table? many thanks

GlennS said...

In order to clear the data first, you would have to use a custom defined function to call a stored procedure or issue a sql statement. The Essbase labs group has that CDF on their web site (or it might be on the OTN site)

Marco said...

Hi Glenn, thnks a lot. Now I have the function and registered. I tested on my virtual machine (Essbase 931 and it works in MSACCES, I want to run a "delete from table". At client site I implemented the same function, I'm using the same ODBC used for essbase sql interface defined on a window 64 bit server, but even if the connection is ok, essbase seems to wait something during the calculation and after the connection to the oracle schema, the statement I want to pass that is "delete from tablename" is not logged on the Oracle environment. The connection is logged. Can be something related to the ODBC? I tried to use the thin client connection but the connection is not working. Any idea please? Many thanks in advance. Marco