Search Results

Search results 1-20 of 193.

  • User Avatar

    With Jedox 6 there is a new option "Add Filename column" in the Directory connection which does this.

  • User Avatar

    Variable from ETL to Web

    a_froehlich - - Palo ETL

    Post

    This is possible. Take a look at this Knowledge Base article: knowledgebase.jedox.com/knowle…pi-of-jedox-etl-from-php/ and at the Macros of the Demo-Spreadsheet "ETLTasks" which comes with the Jedox Setup. The docu of the ETL SOAP-API, which is indeed quite technical, can be found in the Jedox SDK which you can download from here: jedox.com/de/services/downloads

  • User Avatar

    Hi, You could load the Extract to a local filebased H2- or Derby-database in a Relational Load with Mode "Create" as a first load. The other loads extract then from this table with a simple "SELCT * from table". In the forthcoming Jedox release there will be a built-in solution for this use-case in most of the extract types.

  • User Avatar

    Use a FieldTransform, add under Target a row with the name of the dimension as Field na and the constant value "Actual" as Input.

  • User Avatar

    No, this is currently not possible. In a forthcoming Jedox version there will be a new load component for arbitrary Relational SQL calls (Create, Update, Stored Procedures....). Like any other load, it will also be executable from within a Groovy Script.

  • User Avatar

    Spaces are ignored in ETL

    a_froehlich - - Palo ETL

    Post

    In general, all column values are automatically trimmed in the result of an extract or a transforms as described here: knowledgebase.jedox.com/knowle…l-function-concatenation/ Though, you should be able to achieve your usecase using a File Connection with "#space" as data delimiter and eventually the FieldTransform Function "Concatenation".

  • User Avatar

    With Jedox 5.1 SR3 the connection type "Access" will technically no longer be based on the JDBC-ODBC bridge but on the JDBC driver UCanAccess. It's worth trying out again with this version. See also documentation here: knowledgebase.jedox.com/knowle…/whats-new-jedox-5-1/#SR3 knowledgebase.jedox.com/knowledgebase/connection-to-access/

  • User Avatar

    Java LoadCells Sehr Langsam

    a_froehlich - - General

    Post

    Your method setdata_Block looks good, but it depends of course on input values. What exception message do you get?

  • User Avatar

    Java LoadCells Sehr Langsam

    a_froehlich - - General

    Post

    It seems that you are writing only one single cube cell with method loadCells. This method is rather meant for bulk-loads i.e. writing for example 100.000 cube cells at once. Try to do this and measure the times again. I'm sure it will be much faster than 100000 * 15 ms.

  • User Avatar

    This was indeed an ETL-UI Bug which is already fixed in the latest version 5.1 SR2.

  • User Avatar

    In forthcoming Jedox ETL 5.1 release the usage of the Olap Java Client-Library (palojlib) will be much easier: There will be one central method com.jedox.palojlib.interfaces.IDatabase getDatabase(String connection) which returns an IDatabase-object for a Jedox connection in the ETL project. With this object all methods of the Olap Java Client-Library are available. The connection is opened, at the end of an ETL execution the connection is closed automatically from ETL. Up to now, usage of palojl…

  • User Avatar

    Concerning the question: "....but would it be possible to display the content of the functions..." ? If you are familiar with XSLT you can achieve this yourself. You have to adapt the file "etldoc.xslt" in the output folder of the generated project documentation. It transforms the data from "etldoc.xml" which contains all ETL component settings.

  • User Avatar

    For your info: Jedox ETL 5.1 will have a new transform type called "RScript" with a direct integration of R into an ETL process.

  • User Avatar

    This "avg" aggregation in ETL defines how the source data of the TableTransform is aggregated before it is written to Olap server. It does not define how aggregation from base to consolidated cells is done in Olap analysis.

  • User Avatar

    Complete API in Groovy

    a_froehlich - - Palo ETL

    Post

    You could already use the Java client libs (palojlib) in a Groovy script, but it includes several steps: Opening the connection, reading database, dimension and elements.... Check the javadoc for palojlib to get more details. In Groovy-Jobs this may be reasonable but in Groovy-Functions it's more tricky: Performance will be poor if you have a high number of rows/elements, as individual Olap-requests are necessary for each row. So, a lookup-function is currently the best way, also from a performa…

  • User Avatar

    ETL connection to a FTP server

    a_froehlich - - Palo ETL

    Post

    That should be working, whereas FTPS is not yet supported.

  • User Avatar

    Jedox extract from SAP BW on HANA

    a_froehlich - - Palo ETL

    Post

    Exactly. That should be all to do.

  • User Avatar

    Jedox extract from SAP BW on HANA

    a_froehlich - - Palo ETL

    Post

    You can continue to use the SAP BW-specific extract types from SAP Jedox Connectivity to extract from Cubes, Data Store Objects and Infoobjects. They are working independently of the underlying database. If BW is running on SAP Hana, in theory, the extraction process should be somehow faster. There is also a JDBC driver available for SAP Hana. With it, it should be possible to extract from any table of the SAP Hana Database using Jedox ETL extract type "GenericDB". For more details on this extra…

  • User Avatar

    There are already plans for a specific job type for such external jobs in standard Jedox ETL, but I cannot tell yet when it will be done.

  • User Avatar

    Note that the experimental Extract type for Excel will be generally available with the next Jedox ETL release.