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

Search Forums:

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

Page 1 of 5 1 2 3 4

Search Forums: Search took 0.11 seconds.

  1. Replies
    2
    Views
    75

    See infocenter :...

    See infocenter : http://infocenter.pentaho.com/help/topic/report_designer_user_guide/jfreechart_reference/reference_property_domain-title-font.html
  2. I found a work arround. The problem was that the...

    I found a work arround. The problem was that the themeResources.js was not loaded in IE. What I did was
    1. Make a java script that test which kind of browser is used. Place that script in the...
  3. Replies
    2
    Views
    120

    You can also accomplice this with css. Make a css...

    You can also accomplice this with css. Make a css class with a width from for example 1200px and the dashboard will become broader. With css margin-left: -300px the dashboard will be moved to the...
  4. When you use a JDBC data set. Place {call...

    When you use a JDBC data set. Place {call usp_NameStorageProcedure (${Par1}, ${Par2})} in the query
  5. Start ..\biserver-ce\start-pentaho.bat

    Start ..\biserver-ce\start-pentaho.bat
  6. You can hide the cda files in the PUC. Go to...

    You can hide the cda files in the PUC. Go to ..\biserver-ce\pentaho-solutions\system\cda\plugin.xml and remove or disable the content-types tag:

    <content-types>
    <content-type type="cda"...
  7. Issue loading stylesheets in Internet Explorer

    I made my own PUC theme. When I use Internet Explorer the style sheets are not loaded. When I select the url and the "Enter" the style sheet is loaded. I have the same behavior when I use the F5...
  8. Replies
    2
    Views
    104

    When you declare a datasource in the...

    When you declare a datasource in the Administration Console then you can use sql over sqljndi. Then jndi is the name of the datasource.
  9. Replies
    1
    Views
    112

    Did you download the jtds.jar file or the...

    Did you download the jtds.jar file or the sqljdbc.jar file?
  10. Replies
    0
    Views
    83

    Action successfull

    Is it possible to remove the “Action successful” message which appear after firing a xaction. The xaction runs a kettle transformation. The xaction has no output so something like

    <outputs> ...
  11. Replies
    2
    Views
    168

    try this one ...

    try this one

    http://anonymousbi.wordpress.com/2012/10/28/pentaho-bi-server-4-5-0-definitive-mysql-installation-guide/
  12. With CDE you can make those kind of dashboards

    With CDE you can make those kind of dashboards
  13. Replies
    5
    Views
    270

    For a new window. Use window.open instead of...

    For a new window. Use window.open instead of window.location

    For a new tab use :

    top.mantle_openTab('tabname', 'Tablname',...
  14. Yes you can. Use the CDE plugin to create a...

    Yes you can. Use the CDE plugin to create a dashboard within Pentaho
  15. Replies
    5
    Views
    270

    Do you want to execute a prpt file outside the...

    Do you want to execute a prpt file outside the dashboard? Then when you want to link to the report inventory.prpt report inside the ..\pentaho-solution\steel-wheels\reports directory the click action...
  16. In the samples directory you can find the...

    In the samples directory you can find the transformatio: JavaScript - Base64 Decoder and Encoder.ktr. This gives an example to encrypt your data.
  17. Try to decrease the logging size. See:...

    Try to decrease the logging size. See: http://infocenter.pentaho.com/help/topic/performance_tuning_guide/concept_pdi_log_params.html
  18. Replies
    4
    Views
    161

    In the insert/update step you have a check box...

    In the insert/update step you have a check box for "Don't perform any updates"
  19. Just write the name of the database connection...

    Just write the name of the database connection "dbcon" in the jndi field should work
  20. Replies
    4
    Views
    161

    With the Insert/Update step

    With the Insert/Update step
  21. Did you restart your bi server? In the image from...

    Did you restart your bi server? In the image from the Administration Console. It hasn't a connection with the bi server at that time
  22. Replies
    1
    Views
    232

    You can use the CE edition for free. Only for the...

    You can use the CE edition for free. Only for the EE edition you need to have a licence.
  23. In start-pentaho.bat: set memory minimum (Xms)...

    In start-pentaho.bat: set memory minimum (Xms) and maximum (Xmx) in tomcat, for example: -Xms516m -Xmx1024m
  24. For the year : "=YEAR(TODAY())" For month :...

    For the year : "=YEAR(TODAY())"
    For month : "=MONTH(TODAY())"
  25. You can read the data with the step "XML Input...

    You can read the data with the step "XML Input Stream" (StAX).
  26. Declare a variable in the kettle.properties file....

    Declare a variable in the kettle.properties file. The value is your base dir. Then you can use that as a variable
  27. Replies
    4
    Views
    679

    Did you delete the pentaho.xml file. See...

    Did you delete the pentaho.xml file. See
    Remember deleting tomcat\conf\Catalina\localhost\pentaho.xml , Pentaho creates on startup pentaho.xml as a copy of context.xml.
  28. Replies
    4
    Views
    679

    I didn't do is myself but found this site:...

    I didn't do is myself but found this site: http://anonymousbi.wordpress.com/
  29. accet to a cube is done by Roles. See for example...

    accet to a cube is done by Roles. See for example the mondrian_technical_guide.pdf document on page 42. You can find the document in your schema workbench directory. ..\schema-workbench\doc\
  30. The 30 day trial is the Enterprise edition. The...

    The 30 day trial is the Enterprise edition. The version you download from sourceforce is the Community edition. To start the CE yust run start-pentaho.bat.
  31. Replies
    5
    Views
    513

    Log in as a administrator and unhide the folder.

    Log in as a administrator and unhide the folder.
  32. Ok. Those directory's and files will be created...

    Ok. Those directory's and files will be created when the server is running.
    Try to edit the start-pentaho.bat and place some pause (breaks) in the file. Then you can see what is happening.
  33. The logs are still on the same place. So...

    The logs are still on the same place. So
    ..\biserver-ce\tomcat\logs and ..\biserver-ce\pentaho-solutions\system\logs
  34. I did it with one folder without subfolders and...

    I did it with one folder without subfolders and before uploading to the 5.0 server I created the folder in the Public directory
  35. I didn't found the file either. Another way to...

    I didn't found the file either. Another way to import your reports is
    1. zip the directory which you want to import.
    2. In the User console go to Browse Files and choose Upload (Folder actions)...
  36. Replies
    6
    Views
    260

    Is your bi server running on the same computer as...

    Is your bi server running on the same computer as your kettle program? So can your bi-server find the xml file?
  37. In Pentaho 5 the administration functionality is...

    In Pentaho 5 the administration functionality is integrated in the User Console and not in a different program. So I don’t think Pentaho will fix this issue in older versions.
  38. There is an example in ..\D:\Pentaho\Pentaho...

    There is an example in ..\D:\Pentaho\Pentaho 4.8\biserver-ce-4.8.0\biserver-ce\pentaho-solutions\plugin-samples\pentaho-cdf\20-samples\sample_dashboard_broadcast

    But it is easier to use CDE
  39. The problem is in the console.xml. You can find...

    The problem is in the console.xml. You can find it in ..\administration-console\resource\config. The tag <homepage-url>http://www.pentaho.com/console_home</homepage-url> is causing the trouble...
  40. Replies
    3
    Views
    281

    I guess that his sheets don’t have the same...

    I guess that his sheets don’t have the same columns .
    So Name and Age in sheet A, Address and State in sheet B…
    You can’t put them together in one input step because column A from all the sheets...
  41. Why not use an input table step where you use :...

    Why not use an input table step where you use : select * from table where age is null. Then join the text file with the input table step and you have only the records from the table where the age...
  42. In your cube you can access user or roles to...

    In your cube you can access user or roles to parts of a cube, For some documentation see f.e. : http://mondrian.pentaho.com/documentation/schema.php#Access_control
  43. Replies
    4
    Views
    233

    When you run your transformation you get this...

    When you run your transformation you get this error message

    2013/11/06 07:28:27 - Formula.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : Unexpected error...
  44. Replies
    4
    Views
    233

    You can use a formula :...

    You can use a formula : if(isblank([sub-caterogy]);[main-category];[sub-category])
  45. I hope I understand you correctly you want to...

    I hope I understand you correctly you want to save the report under a different name for each day. I would do that with the help of Kettle. Make a transformation that run the report and write the...
  46. Replies
    3
    Views
    467

    Do you have a system variable JAVA_HOME that has...

    Do you have a system variable JAVA_HOME that has to point to your java directory? Something like System Variable : JAVA_HOME and Variable value : C:\Program Files\Java\jre7

    When a dos window only...
  47. You have to place the sapjco3.dll file in the...

    You have to place the sapjco3.dll file in the libext folder

    Regards,

    Johan
  48. Replies
    19
    Views
    1,513

    There is no trick to connect to a mssql server....

    There is no trick to connect to a mssql server.
    Is the mssql server configured correctly? Is port 1433 listening to the sql server?
  49. Ok, it is strange when you can't reach the...

    Ok, it is strange when you can't reach the production server via http and it is possible to reach the server to copy a file to the solution repository.
    But, as you mentioned, that is a way to put a...
  50. You can use the step "Replace in string"

    You can use the step "Replace in string"
Results 1 to 50 of 224
Page 1 of 5 1 2 3 4