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
ODI in the hybrid database world – Amazon Redshift – AWS CLI
-
Written on June 5, 2023 by Rodrigo Radtke de Souza Hi all, probably this is
the last post of this series on how to load data from on-premises databases
to ...
1 year ago
Posts
5 comments:
Try to set DataExportDynamicCalc OFF
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
Hi Glenn, any possibility to clear data in the relational table during the essbase pushing dataexport before to populate again the table? many thanks
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)
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
Post a Comment