Hitachi Vantara Pentaho Community Forums

Search Forums:

Type: Posts; User: thorsten; Keyword(s):

Search Forums: Search took 0.02 seconds.

  1. Replies
    1
    Views
    718

    Line chart with Stacked Bar as Plot2

    Hi,

    am asking for some help/suggestion on how to tructure the data set, so that I can have the "main" chart be a line chart with a bar chart as "secondary" chart.
    I cant choose a Line Chart as I...
  2. Replies
    0
    Views
    769

    Metadata Generator/Script

    Hi,

    quick question does anyone know of a tool or have a script to generate a Metadata layer?
    The two ways I know is using the Data Connection Wizzard in BA and Metadata Editor.

    I am looking...
  3. Replies
    2
    Views
    1,200

    Hi SRK, a bit late, I have found issues with...

    Hi SRK,

    a bit late, I have found issues with the "Web services lookup" step in version 4.3.0:
    * Transformation with "Web services lookup" does not work if you try to preview in spoon => Response...
  4. Replies
    1
    Views
    718

    MongoDB output step Modifier Policy

    Hallo,

    I am learning/playing around with Pentaho and MongoDB,
    And trying to get example "2.4.1 Modifier Policy" in the Wiki (http://wiki.pentaho.com/display/EAI/MongoDb+output) to work.

    But...
  5. Issue has been resolved, I blame it on the slow...

    Issue has been resolved, I blame it on the slow internet connecting in Africa or my inability to use the iPad
  6. Pentaho EE BI Server 4.8 Mobile iPad Demo not working

    Hi,

    dont know if forum is also for EE questions, if yes here goes:

    I am trying to play with the new Mobile features in Pentaho EE 4.8, but cant get it working on my iPad.
    If I load the demo...
  7. Replies
    2
    Views
    1,019

    Thank you Matt, it works great.

    Thank you Matt, it works great.
  8. Replies
    2
    Views
    1,019

    Accessing Job Log file in the Job/Trans

    Hi, searched the forum, but could not find any help.

    Aim: If a job fails due to a set database-error, it should just start again.

    Plan: If the job fails, parse the logfile for certain SQL...
  9. Replies
    5
    Views
    2,171

    Hi, Have two Table Inputs in a Transformation...

    Hi,

    Have two Table Inputs in a Transformation and control the SQL via a Variable, and the set "Execute for each row" switch and "Insert data from step" in the Table Input. Please see attached...
  10. Different JDBC Connection behaviour between BI-Server/Reports and PDI in DB2

    Hi,

    i am experiencing following problem and would like any input.

    Am using a JDBC Driver to connect to a DB2 Database. The DB2 Database has parallelism set.

    If I execute a SQL Query with a...
  11. Hi, I am experiencing, this problem that with...

    Hi,

    I am experiencing, this problem that with the Kettle - Spoon version 3.2.0, that the database lookup step, is not replacing the variable for the lookup schema.
    In the Transformation I am...
  12. Hallo, In Linux, i would find the Java Process...

    Hallo,

    In Linux, i would find the Java Process that is running the job, by
    ps aux | grep -i "job:TestJob"
    or
    ps aux | grep -i "kettle"

    to find the PIDID, and the force that Process
    kill...
  13. kitchen does not respond/Interruptible sleep

    Hallo,

    I would like to ask if anyone has had similar experiences. Running Spoon version 3.2.0.
    I have a Job with several Transformations, the Job runs fine till about 2hours into the Job.
    And...
  14. Replies
    3
    Views
    1,211

    Agreed the Software just does what I tell it....

    Agreed the Software just does what I tell it.
    Now the Question is how do I tell it to do the following add just a LABEL with multiple lines of text, and get it displyed as an RTF with no new line...
  15. Replies
    3
    Views
    1,211

    Ok I found this Forum using JFreeReport to show...

    Ok I found this Forum
    using JFreeReport to show text in an RTF format
    http://forums.pentaho.com/showthread.php?32873-using-JFreeReport-to-show-text-in-an-RTF-format

    I tried formatting the...
  16. Replies
    3
    Views
    1,211

    Formatting RTF Report

    Hallo,

    I have an Invoice that I generate with PRD, and everything works super to create the PDF document.
    But as expected user requirements change, and they would now like it in RTF.

    I have...
  17. Is the Sorting order maintained, even if stream passes several Database Lookups

    Hi,

    This might be an unnecessary Question.

    I have a 01.Table Output, where the SQL has an "ORDER BY" clause, which is order by the Key used later in a "Merged join".

    Step 02, 03, 04......
  18. Hi, Managed to solve the problem with a...

    Hi,

    Managed to solve the problem with a Xaction.
    With help from http://forums.pentaho.org/showthread.php?p=222442#post222442

    Thanks
  19. Hi, I am trying to do it with an Xaction...

    Hi,

    I am trying to do it with an Xaction aproach now, but with no luck.
    I am comming agross that it is not Possible to run a Report 3.5, with an Xaction.

    Will try to find possible ways to get...
  20. Getting the PDF OutputStream via a http request

    Hi,

    We are tying to call a Report 3.5, via a http request to the Pentaho BI Server, from a seperate JSF Application. And to be able to receive the OutputStream, to process it further and save it...
  21. Transformation Runs fine up untill a point, the slow and no load

    Hallo,

    I have a Transformation (Read DB, combine Streams, Insert or Update DB), it runs fine up untill a point (+- after 3hours) then becomes really 'slow' accourding to Log output, also the LOAD...
  22. Replies
    1
    Views
    5,302

    Hi, Be sure to select the Schema first and...

    Hi,

    Be sure to select the Schema first and then the Table you want to select, selecting the Table directly will not work as DB2 always requires a Schema.
    Or update the JDBC DB2 drivers; this...
  23. Hi, SQL ERROR: 206 Are you sure your...

    Hi,

    SQL ERROR: 206


    Are you sure your Schema and Table names, reach the transformation correctly.

    I personallly Truncate DB2 Tables with PDI, using a "Execute SQL statements" ->
    CALL...
  24. Replies
    5
    Views
    5,233

    Hi, Hope I understand your problem correctly,...

    Hi,

    Hope I understand your problem correctly,

    I used the "Simple evaluation" in a Job, and assigned the Success On->Value, a dummy variable ${NULL_VAL}, as simply entering the string Null...
  25. Hi LindsayV, That does the trick, thanks for...

    Hi LindsayV,

    That does the trick, thanks for the help.
  26. Regex evaluation Step, quick help on regex please

    Hi there,

    Have a very basic question but am not able to find the answer.

    Have a Perl programm with many many regex that filter out bad datasets. Am using one "Regex evaluation Step" for every...
  27. Replies
    3
    Views
    1,247

    I would sugest using a 'Switch / Case' step,...

    I would sugest using a 'Switch / Case' step, after the 'File exist' step, where you check the 'Result fieldname' from the 'File exist' step. Case value data type: Boolean, where Case value 0 ->...
  28. Replies
    2
    Views
    1,206

    The "Database Value Lookup", has the option to be...

    The "Database Value Lookup", has the option to be cached, "Enable cache?". This will reduce your Database queries depending on the type of data you have.

    Check if it is worth putting an index on...
  29. Why dont you change your SQL, by not including...

    Why dont you change your SQL, by not including "varbinary(max) column" in the SELECT statement, instead of using SELECT * .

    SELECT <col1>,<col2>.... FROM <table>

    Try checking "Enable lazy...
  30. Look under Hex to Integer:...

    Look under

    Hex to Integer:
    \samples\transformationsJavaScript - Hex to Integer conversion.ktr

    For a Integer to Hex I tried:
    var nummerke = Packages.java.lang.Integer.toHexString( 0x10000 |...
  31. Hi Matt Casters, Thanks for pointing that out...

    Hi Matt Casters,

    Thanks for pointing that out to me.
    I enabled it and compiled PDI, with it enabled. Fully aware that it will not work for big decimals and binary data. Just to see the...
  32. Use Batch update for inserts, DB2 is it really doing Batch updates

    Hi,

    I am trying to copy Table from one Database of the Operational system to the Staging area DB2 Database.

    I have a simple Kettle transformation, “Table Import” to a “Table Output”
    ...
  33. Adding format / style the Multi Select Boxes, used in a Secure Prompt Filter?

    I am buiding up a dynamic paramterised Report, based on the “Using AJAX to Drive Dependent Report Parameters”
    Am using Multi Selection List to let the user select several values. All works good,...
Results 1 to 33 of 33
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.