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

Search Forums:

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

Page 1 of 8 1 2 3 4

Search Forums: Search took 0.10 seconds.

  1. You can use KETTLE to achieve this.

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

    In Browse Files screen choose View -> Show Hidden Files
  3. Replies
    4
    Views
    150

    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
  4. 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...
  5. 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
  6. 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?
  7. 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
  8. 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.
  9. Replies
    5
    Views
    269

    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.
  10. 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....
  11. Replies
    2
    Views
    188

    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"
  12. 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
  13. 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?
  14. 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
  15. 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
  16. Replies
    2
    Views
    143

    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...
  17. Replies
    8
    Views
    493

    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...
  18. Replies
    8
    Views
    493

    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...
  19. Replies
    8
    Views
    493

    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...
  20. 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
  21. 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...
  22. Replies
    3
    Views
    180

    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...
  23. I didn't try it on CE but try this link (it is...

    I didn't try it on CE but try this link (it is for the EE version but most of the steps are the same)
    https://help.pentaho.com/Documentation/6.0/0F0/0K0/040/0A0
  24. Replies
    7
    Views
    329

    Are you working with the EE edition? Because in...

    Are you working with the EE edition? Because in the CE edition there is no Dashboard menu options. But in the CE edition you can find CDE "File" -> "New" -> "CDE Dashboard"
  25. Replies
    7
    Views
    329

    Pentaho 6 is shipped with CDE. So not neccessary...

    Pentaho 6 is shipped with CDE. So not neccessary to install it
  26. Here you can find some tips to increase the speed...

    Here you can find some tips to increase the speed of loading data into MySQL
    http://julienhofstede.blogspot.nl/2014/02/increase-mysql-output-to-80k-rowssecond.html
  27. Because it is the EE edition I would say ask the...

    Because it is the EE edition I would say ask the Pentaho support
  28. version 6.0 is the latest version. They don't...

    version 6.0 is the latest version. They don't call them stable anymore.
  29. Replies
    5
    Views
    233

    There is an example "Foodmart.xml" You can find...

    There is an example "Foodmart.xml" You can find that in the demo directory of your schema workbench. Roles you place in your cube must also assigned to the user in the BA server
  30. Replies
    5
    Views
    233

    To hide a cube or parts of it use roles. See:...

    To hide a cube or parts of it use roles. See: http://mondrian.pentaho.com/documentation/schema.php#Access_control
  31. Is it perhaps a firewall issue? Can you ping to...

    Is it perhaps a firewall issue? Can you ping to that ip address?
  32. You are not using a mysql driver...

    You are not using a mysql driver (org.hsqldb.jdbcDriver). And why are you using version 4.8? The newest version of Pentaho is 6.0
  33. Replies
    3
    Views
    156

    Try removing the directory with the name of the...

    Try removing the directory with the name of the plugin in the directory ..biserver-ce\pentaho-solutions\system and restart the server
  34. Replies
    2
    Views
    148

    Yes it is. In the "Atributes" tab of the field...

    Yes it is. In the "Atributes" tab of the field there is an option "show-changes". Set it to true
  35. Which version of PDI you work. I think there...

    Which version of PDI you work. I think there where problems with ; in a SQL script in some versions of PDI
  36. For each csv file a "Text File Input" step and a...

    For each csv file a "Text File Input" step and a "Table Output" step
  37. Replies
    1
    Views
    166

    Your query is correct and the parameter should be...

    Your query is correct and the parameter should be a string. What is the value of the parameter? The sample report "Inventory list" works with such a query/report
  38. As of version 5.0 content in the server is stored...

    As of version 5.0 content in the server is stored in a jackrabbit repository. So the easiest way to opload a xaction file to the server is to do that in the "Browse Files" page of the user console...
  39. There is a sample of the HelloWorld.xaction. You...

    There is a sample of the HelloWorld.xaction. You can find that in Public -> BI Developer Examples -> Getting Started -> HelloWorld.xaction. Perhaps you have to enable "Show hidden files" in the menu
  40. Replies
    3
    Views
    246

    Small addition. Also place the parameter as a...

    Small addition. Also place the parameter as a listeners in the pie chart
  41. Replies
    15
    Views
    8,606

    Sticky: I think Pentaho wants to release the whole 6.0...

    I think Pentaho wants to release the whole 6.0 stack the same day. The release date is October 14 . See http://www.pentaho.com/product/data-pipeline-pentaho-6-0-release
  42. Replies
    11
    Views
    881

    This part of the log point to the problem. I...

    This part of the log point to the problem. I think the server isn't stopped correctly. The easiest way to resolve is to restart the computer.

    method failed; nested exception is...
  43. The example from Marabu still works in version 5.4

    The example from Marabu still works in version 5.4
  44. The images is comming from...

    The images is comming from ..\biserver-ce\pentaho-solutions\system\common-ui\resources\themes\crystal\globalCrystal.css
    look for :
    #login-background {
    background:...
  45. In version 5.x there is no admin console....

    In version 5.x there is no admin console. Everything is in the user console. Only available if logged in as an administrator.
    The easiest way to schedule transformations and job is with the PDI
  46. The .kettle directory for the DI server is by...

    The .kettle directory for the DI server is by default in C:\.kettle. For spoon it is in the the userdirectory of the user. So by default they are looking to another file
  47. Do you get any message in the log files?

    Do you get any message in the log files?
  48. http://infocenter.pentaho.com/help/topic/config_pd...

    http://infocenter.pentaho.com/help/topic/config_pdi_server/task_pdi_starting_spoon.html#repository_connection
  49. When you schedule a job in the enterprise edition...

    When you schedule a job in the enterprise edition the schedule is managed by the PDI server. So this server must be running. The schedule is not executed by the PDI design tool.
  50. Depending on the settings in Kettle the...

    Depending on the settings in Kettle the connection properties can also being stored in the transformation and job files.
Results 1 to 50 of 398
Page 1 of 8 1 2 3 4