You can use KETTLE to achieve this.
Type: Posts; User: johanhammink; Keyword(s):
You can use KETTLE to achieve this.
In Browse Files screen choose View -> Show Hidden Files
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
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...
Create a JAVA_HOME environment variable which point to your java directory. Something like C:\Program Files\Java\jre7
Which version of Pentaho
Which version of Java
Which kind of operating system
What is the log telling you?
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
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.
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.
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....
Use a Job to create a stored procedure and not a transformation. In the Execute SQL script check "Send SQL as single statement"
Use Kitchen to run the job and make a cron job or windows task which start the task every serveral minutes
What changed since the bi-server worked fine?
What version of Penaho and Java is running? Was there a Java update?
For the report designer JNDI is configured in your user directory.Something like C:\Users\Username\.pentaho\simple-jndi\default.properties
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
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...
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
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...
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"
I think you are working with a 32 bits java version. Java 32 bits is not able to work with 2048M
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...
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)
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"
Pentaho 6 is shipped with CDE. So not neccessary to install it
Here you can find some tips to increase the speed of loading data into MySQL
Because it is the EE edition I would say ask the Pentaho support
version 6.0 is the latest version. They don't call them stable anymore.
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
To hide a cube or parts of it use roles. See: http://mondrian.pentaho.com/documentation/schema.php#Access_control
Is it perhaps a firewall issue? Can you ping to that ip address?
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
Try removing the directory with the name of the plugin in the directory ..biserver-ce\pentaho-solutions\system and restart the server
Yes it is. In the "Atributes" tab of the field there is an option "show-changes". Set it to true
Which version of PDI you work. I think there where problems with ; in a SQL script in some versions of PDI
For each csv file a "Text File Input" step and a "Table Output" step
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
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...
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
Small addition. Also place the parameter as a listeners in the pie chart
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
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...
The example from Marabu still works in version 5.4
The images is comming from ..\biserver-ce\pentaho-solutions\system\common-ui\resources\themes\crystal\globalCrystal.css
look for :
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
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
Do you get any message in the log files?
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.
Depending on the settings in Kettle the connection properties can also being stored in the transformation and job files.