US and Worldwide: +1 (866) 660-7555

Search Forums:

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

Page 1 of 61 1 2 3 4

Search Forums: Search took 0.17 seconds.

  1. Yes, in the transformation. When you open the...

    Yes, in the transformation. When you open the transform step in the job, you can then wire the column in the result set to fill in your parameter.
  2. Sorry, the site won't let me reply! The last...

    Sorry, the site won't let me reply! The last transform is a Table Input connected to an Excel Output, both of which use the parameter you declared.

    - - Table Input ( select <star> from...
  3. This is the old way (and is supported back to...

    This is the old way (and is supported back to around PDI3.1) This is basically what I was suggesting, but the thread won't let me reply any more.
  4. According to...

    According to http://infocenter.pentaho.com/help48/index.jsp?topic=%2Fpdi_user_guide%2Fconcept_pdi_usr_working_with_jndi_carte.html

    You've got it in the right place.
    However, within the VM, you...
  5. Since PDI is java based, why run it inside a...

    Since PDI is java based, why run it inside a further virtualized environment?

    usually, PDI wants the simple-jndi in %USERPROFILE% somewhere (.kettle I think, but it's been a long time since I used...
  6. Sorry... I'm late to this thread. Use...

    Sorry... I'm late to this thread.

    Use PARAMETERS.

    Job (Wrapper)
    - Start
    - Transform (Get List of Tables)
    - - Table Input (Exactly as you have it resulting in OBJECT_NAME)
    - - Copy Rows to...
  7. Since BIServer 5, there is no separate...

    Since BIServer 5, there is no separate admin-console. Everything is built into the User Console now.
  8. Yes, there's a bug here somewhere. I can't find...

    Yes, there's a bug here somewhere. I can't find it over at http://http://jira.pentaho.com
  9. LLoyd, The recommendation was to use the Group...

    LLoyd,

    The recommendation was to use the Group By step. Follow the link, and look in your samples folder.
  10. Have a look at the Dimension Lookup step and the...

    Have a look at the Dimension Lookup step and the Combination Lookup step.
    They should do what you are looking for.
  11. I was just teasing, and making the same statement...

    I was just teasing, and making the same statement that you were...
    It's coming later rather than sooner, because few are willing to step up and fund it.

    My organization is only using PDI, so I...
  12. Replies
    3
    Views
    177

    File System Repository is still a repository. ...

    File System Repository is still a repository. You have to treat it as if it were a DB repository.

    Alternatively, you can just save them as files, use the file path method of calling jobs (Job...
  13. I don't, since I use that flow quite regularly....

    I don't, since I use that flow quite regularly.
    Perhaps post your Transform.

    Also, are you running this within BI Server, or from command line, or from Spoon?

    Perhaps it is an error in your...
  14. Fixed that for you :P

    Fixed that for you :P
  15. For this particular type, the only other option I...

    For this particular type, the only other option I can think of is to use the StAX step.

    However, if your structure was a little bit different:


    <?xml version="1.0" encoding="UTF-8"?>...
  16. Try putting sqljdbc_auth.dll in %windir%\system32

    Try putting sqljdbc_auth.dll in %windir%\system32
  17. Analyzer and Interactive Reporting are different...

    Analyzer and Interactive Reporting are different use-cases.

    Interactive Reports is a similar use-case to Pentaho Report Developer, but when you don't know (or want to give users the ability to...
  18. Replies
    11
    Views
    3,294

    I'd still be just as grumpy and unpleasant. :D...

    I'd still be just as grumpy and unpleasant. :D
    It's an old thread, and I have good days and bad days, apparently I had hit on a string of bad days.
  19. Replies
    3
    Views
    177

    Be consistent. In your batch file, you are...

    Be consistent.

    In your batch file, you are asking for a file, NOT a repository.
    In the job you run, you are asking for a job in a repository.

    Think of it as two different DBs: You initially...
  20. So move your items to the Page Header, and set...

    So move your items to the Page Header, and set the size of the Group Header to 0.
  21. Have a look at Split Field to Rows...

    Have a look at Split Field to Rows and Row denormaliser

    I'm not sure if denormalizing the data as you are suggesting is a "good idea" or not... But I can help you get there if that's where you...
  22. When you ran it, did you set the value?

    When you ran it, did you set the value?
  23. Where did you set the variable ${input}? ...

    Where did you set the variable ${input}?

    Reminder: You cannot set and use a variable in the same transformation.
  24. http://www.meteorite.bi/products/saiku-reporting

    http://www.meteorite.bi/products/saiku-reporting
  25. This seems to be working as expected (based only...

    This seems to be working as expected (based only on your description), what is it that you are expecting to see?
  26. You can set your repeating element to...

    You can set your repeating element to /catalog/document/dept and reference the other fields by relative reference.



    Name XPath Element Result type Type Format Length ...
  27. Thread: Data type error

    by gutlez
    Replies
    8
    Views
    187

    In the file you posted, the Text File Output has...

    In the file you posted, the Text File Output has a value type of "None" for Principal_ID Number ... That's not valid, but I don't think if should cause issues.

    Try setting the "Binary to Normal"...
  28. Thread: Data type error

    by gutlez
    Replies
    8
    Views
    187

    I don't have 5.4 on my machine yet, so I can't...

    I don't have 5.4 on my machine yet, so I can't really help much.

    But... Are you 100% certain that you're getting kitchen 5.4 rather than kitchen 5.3 if they are both installed on the same...
  29. AWS marketplace? I think you might be looking in...

    AWS marketplace?
    I think you might be looking in the wrong place...
    http://sourceforge.net/projects/pentaho/files/Business%20Intelligence%20Server/5.4/
  30. If you run the transform manually from the...

    If you run the transform manually from the command line (including the parameter), does it work correctly?
  31. What about your Windows OS... Is it 32bit of...

    What about your Windows OS... Is it 32bit of 64bit?
    https://developer.jboss.org/thread/70669?_sscc=t
  32. Replies
    9
    Views
    210

    Big question: What version of PDI are you using?...

    Big question: What version of PDI are you using?
    There's a bug in one of them that can cost you rows when the number of rows exceeds commit size.
  33. In your Transform, press Ctrl-T and go to the...

    In your Transform, press Ctrl-T and go to the Parameter tab. Is your Parameter listed there?
  34. Replies
    3
    Views
    105

    Why would you do that when you can do XML Input...

    Why would you do that when you can do XML Input and JSON Output with native PDI steps?
  35. Before asking us to show you how to accomplish a...

    Before asking us to show you how to accomplish a particular goal, tell us what you've tried, and what you've looked at.

    In this case, if you look through the samples at the Row Normalizer step,...
  36. Replies
    2
    Views
    87

    I doubt this will help, but try putting the whole...

    I doubt this will help, but try putting the whole file argument in quotes:
    kitchen.bat "/file:D:\SMT\Integrations\Kettle\FNMP\FNMP.kjb" /server:APPDAVIRTUAL### /port:11990 /user:2487247 /pass:####...
  37. Thread: Row Value

    by gutlez
    Replies
    11
    Views
    302

    This is one of the RARE cases where I would...

    This is one of the RARE cases where I would suggest using Modified JavaScript step.
    marabu might have better ideas, but you can put a nested if statement in to your javascript step to "carry...
  38. Replies
    10
    Views
    369

    Wouldn't it make more sense to: Pull the...

    Wouldn't it make more sense to:
    Pull the Max(create_date) from destination, and then ask source for only those rows that have a create_date > than that?
    At the same time, Pull the Max(update_date)...
  39. MS SQL Connection - This uses the Open Source...

    MS SQL Connection - This uses the Open Source JTDS JDBC Driver
    MS SQL Connection (native) - This uses the closed source but $0 MS JDBC Driver

    There is debate as to which one is more efficient.
    ...
  40. Replies
    4
    Views
    176

    Same!

    Same!
  41. Tip in advance: Reporting requires standard...

    Tip in advance: Reporting requires standard columns.
    I would suggest taking the superset of columns, and fill them with null if the JSON key is missing.
  42. Replies
    10
    Views
    369

    So if source.created_date

    So if source.created_date <= max(destination.updated_date) and source.updated_date > max(destination.updated_date) then it's an update.
    if source.created_date > max(destination.updated_date) and...
  43. Or make the transformation transactional. If...

    Or make the transformation transactional.
    If it's within one transaction, it should be OK for the Insert.
  44. Replies
    10
    Views
    369

    This indicates that the Insert/Update is your...

    This indicates that the Insert/Update is your bottleneck, and you need to tune your transform.

    Using fields in your Table Input might help you identify which rows are completely new, and which...
  45. Replies
    1
    Views
    295

    Issue 1 sounds like the Garbage Collection thread...

    Issue 1 sounds like the Garbage Collection thread that is on the board....
  46. Replies
    2
    Views
    165

    Have a good look at the Value Mapper step.

    Have a good look at the Value Mapper step.
  47. Do you have Lazy conversion turned on?

    Do you have Lazy conversion turned on?
  48. Replies
    3
    Views
    1,281

    LKBrown_DBA that doesn't actually solve the issue...

    LKBrown_DBA that doesn't actually solve the issue provided.
    The issue is that in the DB, the datatype is a string in one table, and numeric in the other.

    In recent PDI versions (This thread is...
  49. You need to assemble the *ENTIRE* filename in one...

    You need to assemble the *ENTIRE* filename in one field, and then use the "Accept file name from field" box.
  50. Replies
    2
    Views
    112

    If no steps throw an uncaught error, then your...

    If no steps throw an uncaught error, then your transform will report success.
    So... Catch the errors and do something with them, or filter to a dummy step...
Results 1 to 50 of 3010
Page 1 of 61 1 2 3 4