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

Search Forums:

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

Page 1 of 9 1 2 3 4

Search Forums: Search took 0.32 seconds.

  1. Replies
    3
    Views
    102

    You can use Javascript. Something like: var...

    You can use Javascript. Something like:

    var str = 'abcdef';
    function reverseStr(str) {
    var reversed = "";
    var len = str.length;
    for (var i = 1; i < (len + 1); i++) {
    reversed +=...
  2. Replies
    2
    Views
    189

    Wich step are you using to extract data from...

    Wich step are you using to extract data from Excel. With the default settings in the Excel Writer step the memory consuming can be high with larger files. Enable the "Stream XSLX data" option. This...
  3. Replies
    5
    Views
    126

    It should be select [..] where name = case...

    It should be
    select
    [..]
    where name = case when ${category_name} = 'All product category' then name else ${category_name} end
  4. With the default settings in the Excel Writer...

    With the default settings in the Excel Writer step the memory consuming can be high with larger files. Enable the "Stream XSLX data" option. This can do the trick
  5. Replies
    1
    Views
    113

    First make a field with formula...

    First make a field with formula =if([Name]="John";1;0) Then with that field you make a function : Sum (Running) with the result of the formula
  6. Replies
    30
    Views
    964

    If you work with PDI 6.1 you can have a look at...

    If you work with PDI 6.1 you can have a look at the plugin "Stream Schema Merge". You can download that plugin through the Marketplace. See blog post...
  7. In your example when you don't find a # it will...

    In your example when you don't find a # it will give an error. What you can do is use the "Split Field" step with Delimiter # and New Field NewAccount
  8. I don't know the step KafkaConsumer but this...

    I don't know the step KafkaConsumer but this solutions works with orther plugins. With other steps the plugin directory must be placed in the . .\report-designer\plugins and not in...
  9. Place your plugin in ..\report-designer\plugins

    Place your plugin in ..\report-designer\plugins
  10. Replies
    1
    Views
    179

    In PDI there is a sample transformation that...

    In PDI there is a sample transformation that passes parameters to a report. ..\data-integration\samples\transformations\Pentaho Reporting Output Example.ktr
  11. After creating users in the PAC you can use those...

    After creating users in the PAC you can use those user in the bi-server of Pentaho. After starting that server you can access that with browser with an address something like http://localhost:8080
    ...
  12. Replies
    2
    Views
    176

    Did you define the JAVA_HOME as a Windows...

    Did you define the JAVA_HOME as a Windows Environment Variable? So is java started?
  13. Replies
    1
    Views
    219

    Do you work on a GUI linux version? If not you...

    Do you work on a GUI linux version? If not you cannot run spoon.sh because it is a gui program
  14. vjsp90, which version are you using? I think...

    vjsp90, which version are you using? I think there are some pentaho 5 version it was not working. (I think 5.0 and 5.1). With version 6.0 it works for me
  15. Replies
    2
    Views
    263

    use a parameter

    use a parameter
  16. Replies
    4
    Views
    300

    What are the connection properties? What kind of...

    What are the connection properties? What kind of error do you get? Is the ODBC conection working anywhere else? Is ODBC 32 bits and Java 64 bits?
  17. You are working with the Enterprise Edition and...

    You are working with the Enterprise Edition and not with the Community Edition. You can download the CE here: https://sourceforge.net/projects/pentaho/files/
  18. The sqljdbc.jar file is the correct file. But...

    The sqljdbc.jar file is the correct file. But what is in the error message
  19. Replies
    3
    Views
    305

    You can download it from...

    You can download it from here:http://ci.pentaho.com/job/agile-bi/
  20. Use Tekst File input. In tab "Content" Filetype...

    Use Tekst File input.
    In tab "Content" Filetype -> "Fixed"
    In tab "Fields" add 1 row with Position = 1 and length heigh enough that the whole row is in it
  21. This error mesage you will receive when the cube...

    This error mesage you will receive when the cube is not correct.
    When in the Schema Workbench can you open your cube and then go to File - New - MDX Query?
  22. PDI can't find the jdbc driver file. Make sure...

    PDI can't find the jdbc driver file. Make sure you placed the necessary driver file in your pdi installation
  23. Replies
    3
    Views
    309

    You have to install the "WAQR" plugin through the...

    You have to install the "WAQR" plugin through the Marketplace
  24. Replies
    4
    Views
    175

    The formula should be something like...

    The formula should be something like FIND("45105038" ; [AccountInfo])
  25. Replies
    4
    Views
    175

    You can do that with a formula step or a...

    You can do that with a formula step or a javascript
  26. Replies
    7
    Views
    317

    When using the EE version you can always ask...

    When using the EE version you can always ask Pentaho support
  27. I think Pentaho version 6 is not working with...

    I think Pentaho version 6 is not working with Java version 6. The minimum version is java7
  28. Replies
    2
    Views
    755

    Are you running with a 64 bits java version?...

    Are you running with a 64 bits java version? Because C:\Program Files (x86)\Java\jre1.8.0_73\bin\javaw.exe is pointing to a 32 bits version. When running on a 32 bits version change memory size to...
  29. You can use KETTLE to achieve this.

    You can use KETTLE to achieve this.
  30. In Browse Files screen choose View -> Show Hidden...

    In Browse Files screen choose View -> Show Hidden Files
  31. Replies
    4
    Views
    440

    User: admin and password: password There is...

    User: admin and password: password
    There is since version 5 no administator interface. It is in the interface itself localhost:8080. When you have admin rights you access admin task
  32. What is it what you want to achieve? The 2...

    What is it what you want to achieve?
    The 2 lines you mentioned only set the variable when you start PDI with SpoonConsole.bat or SpoonDebug.bat. Not when you start spoon.bat.
    When you places a...
  33. Create a JAVA_HOME environment variable which...

    Create a JAVA_HOME environment variable which point to your java directory. Something like C:\Program Files\Java\jre7
  34. Which version of Pentaho Which version of Java...

    Which version of Pentaho
    Which version of Java
    Which kind of operating system
    What is the log telling you?
  35. Where is that column coming from? In a Text File...

    Where is that column coming from? In a Text File Input you can use "Trim Type" both. Otherwise use the step "String operations" to remove empty spaces
  36. Are there perhaps empty spaces in the csv or...

    Are there perhaps empty spaces in the csv or excel file?
    Otherwise run your transformation with a higher logging level to see the exact sql statement and see if that is correct.
  37. Replies
    5
    Views
    468

    Is Pentaho version 4.8 also a requirement?...

    Is Pentaho version 4.8 also a requirement? Otherwise use the newest version (6.0). In that version cde, cda and cdf are already installed.
  38. You can make and run a transformation with spoon...

    You can make and run a transformation with spoon (the GUI).
    You can save that transformation in a database or as a .ktr file.
    With PAN you can run that transformation outside the GUI interface....
  39. Replies
    2
    Views
    292

    Use a Job to create a stored procedure and not a...

    Use a Job to create a stored procedure and not a transformation. In the Execute SQL script check "Send SQL as single statement"
  40. Use Kitchen to run the job and make a cron job or...

    Use Kitchen to run the job and make a cron job or windows task which start the task every serveral minutes
  41. What changed since the bi-server worked fine? ...

    What changed since the bi-server worked fine?
    What version of Penaho and Java is running? Was there a Java update?
  42. For the report designer JNDI is configured in...

    For the report designer JNDI is configured in your user directory.Something like C:\Users\Username\.pentaho\simple-jndi\default.properties
  43. A subreport is not necessary. Make a new query...

    A subreport is not necessary. Make a new query were you get the result you want. Then use a function SingleValueQuery to retrieve this information and place that in your report
  44. Replies
    2
    Views
    221

    Check if you have declared a JAVA_HOME variable?...

    Check if you have declared a JAVA_HOME variable?
    When you have a 32 bits java version see this thread: http://forums.pentaho.com/showthread.php?198116-PDI-6-does-not-start&highlight=

    Try also to...
  45. Replies
    8
    Views
    1,826

    C:\data-integration>spoon DEBUG: Using JAVA_HOME...

    C:\data-integration>spoon
    DEBUG: Using JAVA_HOME
    DEBUG: _PENTAHO_JAVA_HOME=C:\Program Files (x86)\Java\jre1.8.0_66
    DEBUG: _PENTAHO_JAVA=C:\Program Files (x86)\Java\jre1.8.0_66\bin\javaw.exe

    Any...
  46. Replies
    8
    Views
    1,826

    When you have a 64 bits machine you should be...

    When you have a 64 bits machine you should be able to install java 64 bits. (it is possible to have both java 32 and 64 bits). The 64 bits version of java is by default installed C:\Program Files...
  47. Replies
    8
    Views
    1,826

    Because you are running with java 32 bits you...

    Because you are running with java 32 bits you have to edit the spoon.bat. Look for if: "%PENTAHO_DI_JAVA_OPTIONS%"=="" set PENTAHO_DI_JAVA_OPTIONS="-Xms1024m" "-Xmx2048m" "-XX:MaxPermSize=256m"
    and...
  48. I think you are working with a 32 bits java...

    I think you are working with a 32 bits java version. Java 32 bits is not able to work with 2048M
  49. I don't think you canuse variable/parameters in a...

    I don't think you canuse variable/parameters in a formula. When you want to use formula you need tofill a column with the parameter. You can do that with a JavaScript. Of causeyou can do everything...
  50. Replies
    3
    Views
    333

    The Agile-BI plugin is not automaticly shipped...

    The Agile-BI plugin is not automaticly shipped with PDI. You can download it from http://ci.pentaho.com/job/agile-bi/ and place the agile-bi folder in ..\data-integration\plugins.
    This is for...
Results 1 to 50 of 427
Page 1 of 9 1 2 3 4