Hitachi Vantara Pentaho Community Forums

Search Forums:

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

Search Forums: Search took 0.02 seconds.

  1. Edit users and roles without plataform, using hibernate database

    Hello,

    I need to edit user and roles but not using the plataform, using a hibernate database.

    However I try to connect this database, using this credential:
    ...
  2. Thanks for your help. I apply this solution...

    Thanks for your help.

    I apply this solution and works excellent.
  3. Problem to see and print the error in log linux- PDI 5.3

    Hi,

    I have a process in a linux server with a PDI 5.3 and I create a .sh for execute a process, for example:
    fecha=$(date +"%Y-%m-%d-%H_%M_%S")
    /opt/data-integration/kitchen.sh...
  4. namesheet as a parameter in a excel input step

    Hi,

    I write because I have an Excel with 2 sheet and I need pass the namesheet as a parameter to a transformation in a Excel Input and this step don't permit that.

    How I Can do?

    Thanks for...
  5. Replies
    1
    Views
    549

    Problem with Formula step-extract month

    Hi,

    I write because I have a problem with a formula step.
    I need to extract from a column in a excel, a field date ("2014/06/31"), the month and the year and concatenate like this: 201406.

    I...
  6. Hi, The process take a Excel file for store...

    Hi,

    The process take a Excel file for store information in a database.
    The Excel file is not mine, it is created for other people (users) that send by FTP and the process automatically execute...
  7. I tried some things: 1. Divide the excel in 2...

    I tried some things:

    1. Divide the excel in 2 parts in 2 ETL differents.
    In the ETL 1, load 4500 rows. In the ETL 2 load the remaining (4500).
    The ETL 1 load OK, but when execute the ETL 2 show...
  8. Hi, I can´t save it as CSV because the file is...

    Hi,

    I can´t save it as CSV because the file is sent for the user in Excel format :(
    I tried go through Excel to CSV and later CSV to Table, but it doesn't work.

    Thanks for your help.
  9. java.lang.OutOfMemoryError: Java heap space in Excel Input Step

    Hi,

    I have this problem:

    I have an Excel with 200 columns and 8000 rows.
    I need to insert this information in a table.
    The ETL is just an Input-Output (Excel input step and Table Output...
  10. Replies
    2
    Views
    1,567

    Hi, Thanks for your answer, but the regular...

    Hi,

    Thanks for your answer, but the regular expresion doesn't work.

    Thanks
  11. Replies
    2
    Views
    1,567

    problem with character (á) in cvs file name

    Hi,

    I have some cvs file with the name: ExámenMedico1012011_30062011.cvs, ExámenMedico1012013_30612011.cvs and I nedd to store in a database.

    For process I have a server linux 64 bits and...
  12. Replies
    2
    Views
    2,214

    Problem with table output -batch

    Hello,

    I using the step "table output" checking the option "use batch update for insert". However the step show me this error:
    Unable to empty ps and commit connection.
    [Teradata JDBC Driver]...
  13. Replies
    5
    Views
    3,239

    Thanks for your help. I tried updating the...

    Thanks for your help.

    I tried updating the Teradata driver and installing DI 4.3 but doesn't work.
    The database connection is successfully but after a minutes fail, and sometimes works and...
  14. Replies
    5
    Views
    3,239

    Hi, thanks for your answer. This is the...

    Hi,

    thanks for your answer.

    This is the error:
    *******************************
    com.teradata.jdbc.jdk6.JDK6_SQL_Connection@74ee7e66 Read message 1: Incomplete LAN message header: read 0 bytes...
  15. Replies
    5
    Views
    3,239

    Configuring timeout in PDI

    Hi,

    We have a connection to Teradata with PDI 4.2.1. The problem is that PDI Teradata displays an error when take more than one minute to respond.
    I think it may be because PDI has a timeout set...
  16. Differences between distinct-count and distinct count Schema Workbench

    Hi,

    I making a cube in schema workbench.
    When I create a measure in option aggregator there are two count: distinct-count and distinct count.

    I test both and show me the same result.
    ...
  17. Thread: Parameters

    by larry
    Replies
    3
    Views
    1,208

    hi,The solution was create another query:SELECT...

    hi,The solution was create another query:SELECT nameproduct FROM (select idpcto, nameproductUNIONselect idpcto, tnameproductfrom dim_products w) datasWHERE idpcto IN (${prm_pcto})Create a subreport...
  18. Thread: parametros

    by larry
    Replies
    1
    Views
    1,414

    Hola, La solucion fue crear otro query:...

    Hola,

    La solucion fue crear otro query:
    SELECT nameproduct FROM (
    select idpcto, nameproduct
    UNION
    select idpcto, tnameproduct
    from dim_products w) datas
    WHERE idpcto IN (${prm_pcto})
  19. Thread: Parameters

    by larry
    Replies
    3
    Views
    1,208

    Hi, I dont need that. I have a a parameter...

    Hi,

    I dont need that.

    I have a a parameter with the id and the name, I need show in the report the name, but i need send the id as a a parameter for another query.

    thanks
  20. Thread: parametros

    by larry
    Replies
    1
    Views
    1,414

    parametros

    Hi,

    Soy nuevo en esto del report designer.

    Tengo un reporte que me muestra productos, cant y precio.
    El reporte tiene 2 query:

    El usuario escoge un nombre de pcto: Este es el query para el...
  21. Thread: Parameters

    by larry
    Replies
    3
    Views
    1,208

    Parameters

    Hi,

    I'm new in report desinger 3.8 and I dont know do this:

    I have a report that show a products with price and cant.
    The report has 2 query sql:

    The user choose the product: This query is...
  22. Replies
    0
    Views
    801

    Pentaho in the cloud

    Hi,

    I would like to know if it is possible execute pentaho from the cloud,
    I would like have a database and the plataform in the could and execute all from there.
    I tried create a mysql...
  23. Replies
    2
    Views
    1,567

    Hola, Busca y edita el archivo PUCLogin.jsp...

    Hola,

    Busca y edita el archivo PUCLogin.jsp ubicado en biserver-ce\tomcat\webapps\pentaho\jsp.
    Luego busca la linea (casi al final) que dice:
    <td class="dark"><div id="container_content"><img...
  24. How to disable the automatic grouping of members stpivot

    Hi,

    In jpivot there is a property of dynamic grouping to avoid scrolling through large amounts of information.
    # MemberNavigator.groupingMemberCount=12
    I need to do the same for STpivot....
  25. Replies
    1
    Views
    838

    Compare 2 paremeters and validate

    Hi,

    I have 2 parameters of numbers and I would like validate those parameters:
    if parameter 1 < parameter 2: ok
    if parameter 1> parameter 2: show a message: no valid!!!

    Thanks for your help.
  26. Replies
    1
    Views
    931

    I solve the problem. The field in the database...

    I solve the problem.
    The field in the database was double, I change for Int.
  27. Replies
    1
    Views
    931

    Problem with format number.

    Hi,

    I have a number (year) with format number (#), but in the dashboard (pie) show me with decimal.
    Example: 2011 and show me 2011.0

    Thanks!!!
  28. Replies
    0
    Views
    1,158

    change style at "x Axis Name" fusion chart

    Hi,
    I have a graphic in fusion chart.
    I would like change the style at the name in "x Axis Name".
    Example:
    x Axis Name=user Is in arial 10, bold
    I would like change for verdana, no bold.

    I...
  29. Replies
    0
    Views
    2,065

    change color font x Axis Name fusion chart

    Hi,I have a graphic in fusion chart.I would like change the style at the name in "x Axis Name".Example:x Axis Name=user Is in arial 10, boldI would like change for verdana, no bold.I search in...
  30. Replies
    2
    Views
    1,127

    Salu2, si es un schedule publico. El usuario...

    Salu2,

    si es un schedule publico.
    El usuario que uso para entrar al puc es administrador (definido en el pac).
    Lo mas extraño es que ni siquiera veo las publicaciones que vienen por defecto.
    ...
  31. Replies
    2
    Views
    1,127

    No puedo ver las planificaciones en el PUC

    Salu2,

    Tengo un schedule en el PAC el cual me envia un email con un reporte adjunto.
    Por lo tanto estos schedule deberian verse en el espacio de trabajo del PUC (despues de compartirlos y...
  32. Replies
    4
    Views
    1,876

    Hi, I did that you write me and works ok. Much...

    Hi,
    I did that you write me and works ok.
    Much better!!!

    Thanks.
  33. Replies
    4
    Views
    1,876

    Excelent!!! I had "Enable Lazy Conversion", but...

    Excelent!!!
    I had "Enable Lazy Conversion", but add select values step and works ok.

    Thanks for your help.
  34. Replies
    4
    Views
    1,876

    convert byinary-string to string

    Hello,

    I have a field (products) from mysql database and the transformation show me the values with type string<binary-string> , but in the mysql the field is define varchar.

    I use the...
  35. Replies
    0
    Views
    989

    cannot view schedule in workspace pentaho

    Hi,

    I schedule in the PAC a report for sending email and share and schedule in PUC.
    However, I cant view this schedule in the workspace in the PUC.
    I,m using biserver 3.5.2
    How can I do for...
  36. Replies
    6
    Views
    3,327

    Hi, Is possible put in the...

    Hi,

    Is possible put in the SubscriptionExecute.EMAIL_BODY_MESSAGE, messages customizables(with variables)

    Thanks.
  37. Replies
    0
    Views
    796

    2 Subreport in the same excel file

    Hi,

    I have 2 subreports in a report and I need show it in excel, un subreport in a sheet and the other en other sheet in the same file.

    How can I do that
  38. Replies
    7
    Views
    3,347

    Hello, The report works, the problem was that...

    Hello,

    The report works, the problem was that path was bad directed.
    But I have another question: When the xaction send the mail, the page show me a message, I would like to show me a message...
  39. Replies
    3
    Views
    2,434

    Hola Ya me funciono el reporte, el problema...

    Hola

    Ya me funciono el reporte, el problema era que tenia mal direccionada la ruta del reporte.
    No obstante tengo otra dudita: cuando el xaction envia el mail, aparece un mensaje, me gustaria que...
  40. Replies
    3
    Views
    2,434

    enviar un reporte x email

    hola,

    Quisiera tener un reporte prpt que se envie por email.
    Ya hice un xaction que llama a un reporte que hice, pero,aunque veo el reporte no se envia nada x email.

    He intentado tambien con...
  41. Replies
    7
    Views
    3,347

    Thanks for you answer, I did that and show me...

    Thanks for you answer,

    I did that and show me the report, but when I write the email for sending the report (Enter E-mail Address since e-mail addresses in EMPLOYEES TABLE are not valid.) the...
  42. Replies
    7
    Views
    3,347

    hi, I found it, but the page show me this...

    hi,

    I found it, but the page show me this error:
    Could not send email because the email server settings have not been configured properly pentaho.

    I changed the email_config.xml with my...
  43. Replies
    7
    Views
    3,347

    xaction for send email

    hello,

    I´m in pentaho and I would like create a .xaction for send email.
    How can I do that??

    Thanks for you help.
  44. store data in the same excel excel I'm using in the ETL

    Hello,

    I am working with PDI and I have a doubt.
    I have an ETL that extracts data from an excel file, then compare it to others,make processes and have new data.
    What I need is to aggregate the...
  45. Guardar datos en un archivo excel que ya estoy usando.

    Hola,

    Estoy trabajando con PDI y tengo una duda.
    Tengo una ETL la cual extrae los datos de un archivo excel, luego lo comparo con otros y hago unos procesos de los cuales saco nuevos datos.
    Lo...
Results 1 to 45 of 45
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.