Jedox - How to export SOAP Log into Excel file

227 views Asked by At

I'm pretty new on Jedox, and I'm trying for internal use to export some specific "warning logs" (eg. "(Mapping missing)" ) into an excel/wss file.

And I don't how to do that...

Can you help me please.

Regards, Usik

1

There are 1 answers

1
Erwin Zeiter On

The easiest way to get these information is to use the Integrator in Jedox. There you have the possibility to use a File Extract and then you can filter the information you are searching for. After that it's possible to load these filtered information into a File. The minimum steps you'll need are Connection -> Extract -> Transform -> Load. Please take a look at the sample projects that are delivered with the Jedox software. In the example "sampleBiker", there are also file connections, extracts etc. You can find more samples in:

<Install_path>\tomcat\webapps\etlserver\data\samples

I recommend to check the Jedox Knowledgebase.

The other way (and maybe more flexible way) would be to use, for example, a PHP macro inside of a Jedox Web report and read the log file you're trying to display. If you've got a more specific idea what you'd like to do, please let me know and I'll try to give you an example how to do so.