Hitachi Vantara Pentaho Community Forums

Search Forums:

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

Page 1 of 7 1 2 3 4

Search Forums: Search took 0.02 seconds.

  1. Replies
    2
    Views
    959

    Hi Naseer, I think you can plug PDI output to...

    Hi Naseer,

    I think you can plug PDI output to Pentaho report, and achieve sap connectivity that way!

    Also refer this link for OLAP4J connection to SAP BW:
    ...
  2. Replies
    6
    Views
    1,499

    Try using the database lookup step. It has 'like'...

    Try using the database lookup step. It has 'like' as a comparator.. and we used exactly the same for referential integrity in one of our projects..
  3. Replies
    2
    Views
    841

    thanks for the reply gutlez! I am trying to...

    thanks for the reply gutlez! I am trying to bypass socks proxy from java_opts in spoon using the
    socksProxyHost and socksProxyPort parameters. But this is not helping :( .. also i'm clueless how...
  4. Replies
    2
    Views
    841

    DB connections fail in EE

    Hi All,

    I have pdi ce 4.4 and pdi ee 5.1 trial installed ... now when i try to connect to databases, pentaho enterprise hangs for a loooong while and then throws an error saying "malformed reply...
  5. Pentaho 5.0 onwards uses the Jackrabbit CMS to...

    Pentaho 5.0 onwards uses the Jackrabbit CMS to store the repository data, hence you will not see the actual folders like they used to be in pentaho 4.8 or below (the pentaho-solutions folder does not...
  6. Replies
    1
    Views
    1,283

    Hide band globally ??

    Hi everyone,

    Is there any global property which allows us to hide a specific band (Eg: Report header, page header etc) on all reports?
  7. Replies
    2
    Views
    949

    There used to be a way, when there were action...

    There used to be a way, when there were action sequences..Even now, if its Excel that you want, you can work your way around with some minimal shell scripting to change the report file name after ...
  8. Hi Chinmayi, Can you format the values in a...

    Hi Chinmayi,

    Can you format the values in a formula, and then feed that as a measure to the pie? (Eg: Use a formula expression and round them)
  9. Replies
    2
    Views
    3,382

    right click on the step -> select "Show input...

    right click on the step -> select "Show input fields" and also see if you are using the same fields in the UDJC step..
  10. Replies
    1
    Views
    618

    yes, you could call pentaho job through the...

    yes, you could call pentaho job through the kitchen script, also you could call a pentaho job from a java application using the Pentaho Kettle APIs
  11. Replies
    1
    Views
    1,318

    What is the output of the shell script when you...

    What is the output of the shell script when you run this? does it throw an error? Did you try refreshing the repository cache and then the metadata cache as well?
  12. as marabu rightly said , please upgrade. !! as...

    as marabu rightly said , please upgrade. !! as for your solution, please check your database log to see if any activity happens there.. there are 2 possibilities:
    -> It is a memory error
    -> The...
  13. Replies
    2
    Views
    706

    Well, if your delimiter is a semi-colon and your...

    Well, if your delimiter is a semi-colon and your data has semi-colon, you must enclose your data with quotes... do you have any enclosure defined for the csv? if yes, specify the type in enclosure...
  14. Replies
    1
    Views
    627

    Pentaho community does not have any license...

    Pentaho community does not have any license cost.. it provides you with a web application where you can generate and schedule reports.. interactive dashboards can be through CDF... try to download...
  15. Replies
    2
    Views
    668

    Where is your dashboard located? Is it a separate...

    Where is your dashboard located? Is it a separate app? Since it is community, im sure u arent using Pentaho's dashboard designer

    Try to display the report in viewer mode embedded in your...
  16. Replies
    4
    Views
    4,871

    You can try to delete the lock files created by...

    You can try to delete the lock files created by h2 in the Jackrabbit repository and then start the server..
  17. If you use stream lookup, the fields from...

    If you use stream lookup, the fields from "Administrateur" will not flow downstream after the lookup.. if you use a merge join.. you can do a left outer join,.. and filter on the column which might...
  18. Replies
    5
    Views
    1,392

    Dear SK, 1. Schedule to run your parent job...

    Dear SK,

    1. Schedule to run your parent job after every 5 minutes

    2.A quick dirty solution is to use the "Wait for SQL" to step perform some querying, and based on its success, the...
  19. Replies
    5
    Views
    1,392

    http://wiki.pentaho.com/display/EAI/Change+Data+Ca...

    http://wiki.pentaho.com/display/EAI/Change+Data+Capture+(CDC)
  20. please do not use the dummy step, just launch two...

    please do not use the dummy step, just launch two copies of table input
  21. Replies
    2
    Views
    718

    Read you log with magnifying glasses it will help...

    Read you log with magnifying glasses it will help you :) :)

    "Caused by: org.postgresql.util.PSQLException: ERROR: permission denied for relation facts_saldos"
  22. Replies
    2
    Views
    1,684

    refer to CDF dashboards for community...

    refer to CDF dashboards for community dashboarding features:
    www.webdetails.pt/ctools/cdf.html‎

    Report designer can also create reports above mondrian cubes. Refer here:
    ...
  23. Replies
    3
    Views
    2,336

    - launch multiple copies of the table input step...

    - launch multiple copies of the table input step and try to monitor the performance change
    - Increase the JDBC fetch size for the DB connection
    - While running in parallel, are you running a...
  24. Replies
    4
    Views
    1,221

    Usually such a scenario is handled by configuring...

    Usually such a scenario is handled by configuring SSO between the application and pentaho..
  25. Replies
    5
    Views
    1,703

    evaluation version :) :P /.. anyways, I shall try...

    evaluation version :) :P /.. anyways, I shall try the support channel
  26. Replies
    5
    Views
    1,703

    any clue here..?

    any clue here..?
  27. Replies
    5
    Views
    1,703

    PDI fails to start on Fedora 19

    I am trying to run PDI which comes bundled with Pentaho 5 on fedora 19 (32 bit). It crashes with the following error:

    ./spoon.sh
    /home/madhu/pentaho/design-tools/data-integration...
  28. Pentaho 5 (data integration server) and admin console

    what happpend to admin console which manages PDI monitoring + Carte subscription in Pentaho 5?

    I understand for reporting admin console is moved into BI server ..
  29. This has to be done in Pentaho user...

    This has to be done in Pentaho user console..After creating the user Go to pentaho user console -> Right click on report or folder which you want to assign permission to user.. if it is on all...
  30. Replies
    3
    Views
    1,053

    Check the pentaho.log to see if any error had...

    Check the pentaho.log to see if any error had happened.. did you run the console initialization tests from admin console.. did it give any errors
  31. Replies
    5
    Views
    1,632

    the wait is over? :) yay!!

    the wait is over? :) yay!!
  32. Replies
    2
    Views
    1,183

    You can use XML input as a datasource and use...

    You can use XML input as a datasource and use Xpath queries to fetch the data.

    For the crosstab part - you might have to use the experimental crosstab feature for now, and consume data from this...
  33. Replies
    1
    Views
    904

    solved.. kept the layout as inline and exported...

    solved.. kept the layout as inline and exported to CSV.. that way, the whole row got treated as a single element and no commas showed up!!!
  34. Replies
    1
    Views
    904

    plain text report

    There is a requirement for a plain txt report where the columns will be identified by their fixed char length.. I tried using the text output of pentaho, but it does not seem to print all columns.....
  35. Hi Ricky, I guess you are passing filename as...

    Hi Ricky,

    I guess you are passing filename as a field.. in that case, you have to pass the "absolute path" (c:/blabla/Desktop/output.csv) or (/home/madhu/output.csv) of the file in the field.. it...
  36. Replies
    4
    Views
    1,054

    use the vertical line....10526

    use the vertical line....10526
  37. Try setting the sheet names for the subreport.....

    Try setting the sheet names for the subreport.. also are they one below the other? are they banded?
  38. Replies
    4
    Views
    1,054

    you have your answer there.. click on the...

    you have your answer there.. click on the element.. go to style... in borders sub section.. for left border size, open up a formula expression.. and say if fieldvalue=5 then 1 else 0.. this way you...
  39. Replies
    2
    Views
    1,791

    unzip your .prpt. it is a collection of XMLs in...

    unzip your .prpt. it is a collection of XMLs in itself..
  40. Please attach your cube. Postgres always needs...

    Please attach your cube. Postgres always needs the subqueries to have an alias name. Maybe you can tweak your cube so that you provide an alias explicitly.
  41. Replies
    1
    Views
    1,337

    self service data export

    Well,

    I tried running an xaction which runs etl and returns a csv report as guided in

    http://forums.pentaho.com/showthread.php?67760-Self-Service-Data-Export-using-Pentaho

    but the problem...
  42. Replies
    19
    Views
    3,046

    Hi Sathish, It depends on your layout... if it...

    Hi Sathish,

    It depends on your layout... if it is simple tabular layout, it is easy to create excels out of CSV from PDI. but i feel it is a very round about option..
  43. Replies
    19
    Views
    3,046

    i dont understand.. what do you mean by 8gb...

    i dont understand.. what do you mean by 8gb memory tweaking? are you settng the heap space to 8gb? what happens when it's lesser? please attach anything which could help debugging.. logs/ktr/prpt ...
  44. Replies
    19
    Views
    3,046

    sathish: is 700k the total record size or record...

    sathish: is 700k the total record size or record size per bursted report? I wonder how could anyone use a 700K data file as a report!!
    If the report generated is a data feed to some other system,...
  45. Replies
    19
    Views
    3,046

    PDI was the way to go... 1200 customer reports...

    PDI was the way to go... 1200 customer reports get generated in 15 mins after storing data from table in temp file per customer, then running it!
  46. Execute jobs in parallel which call the same KTR with different parameter values

    Hi,We need to execute jobs in parallel which call the same transformation.
    The parameters passed to the transformation from each job is different. But when running in parallel, somehow it is always...
  47. Replies
    17
    Views
    7,935

    The answer should lie in Gutlez's post. Is you...

    The answer should lie in Gutlez's post. Is you schema name 'Data' or 'data'?
    Also try to add something similar to this in advanced settings
    (in your case :
    set search_path to data;
    or
    set...
  48. Replies
    17
    Views
    7,935

    What is the problem you face?. Perhaps, you...

    What is the problem you face?. Perhaps, you missed provided "usage" privilieges to your user on the respective schema. Perhaps, you need to set you search_path variable to point to the correct...
  49. Replies
    19
    Views
    3,046

    The splitting using PDI looks to be a superfast...

    The splitting using PDI looks to be a superfast option when compared to single query per customer, before even tuning the system and thinking of cores/clusters! Will update on my results..
  50. Replies
    19
    Views
    3,046

    But somehow, I feel that ResultSetBurstComponent...

    But somehow, I feel that ResultSetBurstComponent was an enterprise option and not supported anymore.

    I could find information in the link you sent, and also in a create_action_sequences.pdf doc.
    ...
Results 1 to 50 of 350
Page 1 of 7 1 2 3 4
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

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