Hitachi Vantara Pentaho Community Forums

Search Forums:

Type: Posts; User: Maria Roldan; Keyword(s):

Page 1 of 17 1 2 3 4

Search Forums: Search took 0.03 seconds.

  1. If all the input tables are in the same database,...

    If all the input tables are in the same database, you can just use a Table Input followed by a Table Output.
    In the Input step write a SELECT statement including all the input data from the...
  2. You have to define Folder and Solution as named...

    You have to define Folder and Solution as named parameters in the second transformation.
    (you do it in the Parameters tab in the transformation setting window)
  3. I vote for this! A warning message, and / or...

    I vote for this! A warning message, and / or disabling 2 tabs as soon as one of the tabs is used.
  4. command line argument or parameter? they are 2...

    command line argument or parameter? they are 2 different things.
    - If you use a command line arg., do as follows:
    Get System Info --> CSV file input
    - If you use a named parameter you don't have...
  5. Replies
    12
    Views
    4,048

    Sticky: Hi, Pedro same account? I'm not able to login....

    Hi, Pedro
    same account? I'm not able to login. Have you migrated the accounts or should we create a new one?
    thanks
  6. Thanks, Marabu. We decided to use the API instead.

    Thanks, Marabu. We decided to use the API instead.
  7. anyone? still the same question... thanks

    anyone? still the same question...
    thanks
  8. how to run a job on a server from my local machine

    hello, I'm blocked with the following:

    I'm working with a Repository. From Spoon I run the jobs on a server. I choose Environment Type=Server and then I provide the settings.
    Now I need to do the...
  9. Datasources - Dynamic name of the XML file

    Hello
    I have a report which uses XML as datasource. Is there a way of using a variable for the name of the XML file?
    I don't know the name of the file in advance.
    thank you
  10. Replies
    2
    Views
    1,956

    Hi, three years later... similar issue here! We...

    Hi,
    three years later...
    similar issue here! We don't have a Pentaho BI server running, but an own Tomcat application that runs PDI jobs. The behavior is similar.
    Anyone familiar with this who...
  11. Replies
    4
    Views
    921

    thanks Mathias. It is not possible to pass the...

    thanks Mathias. It is not possible to pass the connection as a parameter. That would be a solution.
    What I finally did was to use a PDI datasource inside the report, and a JNDI connection in the ktr...
  12. Replies
    4
    Views
    921

    Thanks, Marabu. I also read that in several...

    Thanks, Marabu.
    I also read that in several posts, but always related to PRD alone. I wanted to know if there were some trick for doing it differently inside PDI. Maybe the solution would be to...
  13. Replies
    4
    Views
    921

    Pentaho Reporting step & JNDI

    Hi
    We are not able to use the JNDI datasources defined in Tomcat from a report generated with PRD, and used inside PDI.

    Here the details:
    We have several jobs that run inside a Tomcat app.
    In...
  14. strange issue with the Postgres Bulk Loader

    Hi, we have the following issue.
    We have an Amazon instance with Postgres 9.3 and PDI 6, and we want to run a simple transformation that loads data into a table in Postgres.

    When we run the ktr...
  15. Replies
    1
    Views
    516

    yes, it is. As stated in the PDI documentation,...

    yes, it is.
    As stated in the PDI documentation, you should "use this step to store short lived data only! Pentaho cannot guarantee that the file format will stay the same
    between different versions...
  16. I enabled "boolean support", and have the same...

    I enabled "boolean support", and have the same error.
    I'm working with PDI 5.3
    Any solution to this?
    thanks
  17. Replies
    0
    Views
    455

    recommended browsers

    Which are the recommended browsers&versions for Pentaho 5.3?
    The list in Infocenter seems to be outdated.

    In particular I'm having some issues when displaying reports (prd) in html & pdf formats....
  18. You can do this in a job with a "Set Variables"...

    You can do this in a job with a "Set Variables" entry.
    Configure the "Properties file" box so it reads your file, and all your variables will be set included those with variables in them.
  19. Pasing parameters when scheduling a Report

    I need to schedule a report by using the scheduling API.
    The following link is a sample of what I need to do, but I can't figure out how to set the parameters for the report.
    ...
  20. HI, No, in fact I already tried the api. In...

    HI,
    No, in fact I already tried the api.
    In this case I need to reuse the front end, the wizard itself. Given a report, I want to give a user the possibility to schedule it (set the frequency,...
  21. anyone? thank you!

    anyone?
    thank you!
  22. That should work for me Thank you, Vale!

    That should work for me
    Thank you, Vale!
  23. how to call the "schedule creator" wizard

    I have to give the users the possibility to schedule some reports.
    In this case I need to call the "Schedule Creator" wizard not from the Browse Files page ("Schedule..." option)
    but from a...
  24. Replies
    4
    Views
    3,740

    super! thanks

    super!
    thanks
  25. enable / disable features depending on the user

    Is it possible to enable / disable features in a dashboard depending on the logged user?
    In particular I have a CDE dashboard with several links that I only want to enable for power users.
    thanks
  26. Replies
    4
    Views
    3,740

    Thanks Emi That solved my request, but I also...

    Thanks Emi
    That solved my request, but I also need one more thing.
    I'd like to show the dimensions and measures to the left. By default they are hidden until you click on "Edit". Is it possible to...
  27. Replies
    4
    Views
    3,740

    url for opening a cube in saiku

    I have cde dashboard, and I need to add a link that allows me to open a cube with Saiku CE.
    To be more precise, I don't want the default Saiku page. I need to access the Saiku interface, with a...
  28. Replies
    1
    Views
    848

    I found it! When I imported the schema, I chose...

    I found it!
    When I imported the schema, I chose the proper datasource from the list. Then, I selected "Manually enter data source parameter values", and added the rest of the parameters.
    I didn't...
  29. Replies
    1
    Views
    848

    "Missing schemas & cubes" using DSP

    I'm using Mondrian with Dynamic Schema Processor in Pentaho-Suite 5.3 CE,


    I have a CDE dashboard which runs queries against a cube modified by my DSP class. The dashboard works perfectly.

    ...
  30. This step doesn't have that option. Either: -...

    This step doesn't have that option.
    Either:
    - create the filename in a previous transformation, and save the name in a variable. Then you can use the variable with this notation ${variable_name}...
  31. could you please attach your transformation?

    could you please attach your transformation?
  32. You can replace anything with "". The effect is...

    You can replace anything with "". The effect is the same as removing trailing characters.
  33. The key field should be value3, not value2.

    The key field should be value3, not value2.
  34. Use either a "Replace in string" step or a UDJE...

    Use either a "Replace in string" step or a UDJE step.
    In any of them, you should use regular expressions.
  35. Thank you! I just had to enclose the words...

    Thank you!

    I just had to enclose the words true and false between ""
    as in here:
    =IF(ISEXPORTTYPE("table/html"); "true";"false")
  36. different content depending on the output type

    Is it possible to hide or show elements depending on the output type? pdf, html, etc.
    How do I do that?
  37. Replies
    7
    Views
    2,057

    Suppose you have this: X,Y aaa,1 aaa,2 aaa,3...

    Suppose you have this:
    X,Y
    aaa,1
    aaa,2
    aaa,3
    bbb,4
    bbb,5
    bbb,6
    And you want to create a field named Z, with the Y value in the previous row.
  38. Replies
    7
    Views
    2,057

    This step serves for bringing field values from...

    This step serves for bringing field values from rows above or below the current row.
    It's not mandatory to specify a group. But if you define a group (made of one or more fields), then the "lead...
  39. you're right! It's just Chrome. Thank you,

    you're right!
    It's just Chrome. Thank you,
  40. set the width for the parameter lists

    Is there a way to set the width for the parameter lists?
    I have several multi-value list parameters, and some of them only show the first characters of the options; I cannot see the full values.
    I...
  41. if you have the table name in a variable, you...

    if you have the table name in a variable, you could run the following query in a table input:
    select "${table_name}" as ta_name, count(*) as ta_count from ${table_name}

    and then use an Update...
  42. Replies
    8
    Views
    2,174

    It's not clear to me what you need to do. Could...

    It's not clear to me what you need to do.
    Could you please attach your transformation or a screenshot of it?
  43. It should work. Can you provide more details...

    It should work. Can you provide more details about the error?
  44. thanks Gutlez for pointing me this approach! :)

    thanks Gutlez for pointing me this approach!
    :)
  45. multiselect result as a parameter for a PDI datasource

    I have a multiselect selector, and I want to pass the selection as a parameter to a PDI datasource.
    Currently, I have an error because PDI receives an object. In the error message I see something...
  46. Replies
    0
    Views
    421

    Display time in Eastern Time

    In my reports I need to display the time in Eastern Time.
    Is it possible?
    How do I do that?
    thanks
  47. It worked! In fact, this: "ALL" =...

    It worked!

    In fact, this: "ALL" = ${Multiselect}
    didn't worked, but I replaced it with
    "ALL" IN (${Multiselect})
  48. I don't think I understand what you need. Could...

    I don't think I understand what you need.
    Could you provide a more detailed example?
  49. Name of the report above the list of parameters

    Is it possible to display the Name of the Report at the top of the main page, above the parameters?
    Right now I don't see a way to tell which report you are on when you are selecting the filters.
    ...
  50. Thanks Gutlez I'll try it

    Thanks Gutlez
    I'll try it
Results 1 to 50 of 835
Page 1 of 17 1 2 3 4
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

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