Hitachi Vantara Pentaho Community Forums

Search Forums:

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

Page 1 of 8 1 2 3 4

Search Forums: Search took 0.02 seconds.

  1. How much Memory required to generate report from 2 Billion records

    Hello

    Wanted to know How much Memory required to generate report from 2 Billion records?

    Have 2 billions records but not able to complete MDX query in few minutes. Any performance tuning can do...
  2. Replies
    4
    Views
    761

    I think so bco'z all types of checksums are...

    I think so bco'z all types of checksums are machine dependent
  3. Replies
    3
    Views
    1,106

    Some how thats the problem found after long...

    Some how thats the problem found after long struggle. POstgres DB current timestamp and system time both are different which causes the problem.
  4. Replies
    3
    Views
    1,106

    Dates information comes from table column.

    Dates information comes from table column.
  5. Replies
    3
    Views
    1,106

    Update Step Issue

    Hello Team

    Got some weird problem . I am using PDI 4.3/postgres DB and using update step to update record.

    Problem:-
    I have this column data "2017-01-31 17:00:14-08" having data type as...
  6. Replies
    4
    Views
    1,168

    Use "replace in string" step to replace .(dots)...

    Use "replace in string" step to replace .(dots) with blank and use select values to change the data type with metadata tab
  7. Replies
    2
    Views
    776

    May be "Response time(milliseconds) fieldname...

    May be "Response time(milliseconds) fieldname text box will help you. Add name of the field to give you response time.
  8. Replies
    0
    Views
    440

    Changing with set to member

    Hello

    I wanted to change with set mdx query to with member so that can apply solve order in the query. I think we can't use solve_order with "with set " statement.

    e.g i have this and wanted to...
  9. Replies
    3
    Views
    1,970

    I think idea behind why we have end "Add Ending...

    I think idea behind why we have end "Add Ending line to file " is Append feature of "Text File Output" bcoz when we are going to append our records we need to have carraiage return to identify the...
  10. Alternative

    One Alternative is use "Excel Writer " for output and split the rows sets in excel writer to multiple excel files.
    e.g 350k rows will be divided into 4 files 100k in 3 files and 50k in 4th file....
  11. Replies
    13
    Views
    1,025

    could you please add the file which you are using

    could you please add the file which you are using
  12. Replies
    6
    Views
    997

    Solution to your problem - Worked Above PDI-5.0

    This issue is Already added in Backlog of PDI

    http://jira.pentaho.com/browse/PDI-7770


    There is a plugin in market with the name "FastJsonInput" which will resolve your problem. You can get it...
  13. sample transformation

    sample transformation
  14. Replies
    4
    Views
    1,685

    Use "Email messages input" step to retrieve mails...

    Use "Email messages input" step to retrieve mails with pop/imap
    add the details and u r good to go. Tested it fro gmail
  15. use mongodb input step as source and table output...

    use mongodb input step as source and table output step to connect to oracle and load data in oracle db
  16. Replies
    4
    Views
    1,685

    Tested with gmail 1. enable pop from gmail...

    Tested with gmail

    1. enable pop from gmail settings
    2. use mail step from job steps
    3. add the details relating to your accounnt
    4. gmail setting for tls
    smtp: -smtp.gmail.com
    port:- 587...
  17. Thanks for the reply. You are right. What is am...

    Thanks for the reply. You are right. What is am trying to do now is going to store image of the dashboard and storing that image in power point with Apache POI XSlF.
  18. Export Dashboard as Power Point Presentation

    Hello Team


    is it possible to export complete dashboard in Power Point Presentation? Any body can put light on it. Please share your ideas and view on it.


    Appreciate your help and support.
  19. Export Dashboard as Power Point Presentation

    Hello Team

    is it possible to export complete dashboard in Power Point Presentation? Any body can put light on it. Please share your ideas and view on it.

    Appreciate your help and support.
  20. try this

    try this
  21. one of the way is to load the data in database...

    one of the way is to load the data in database and get the metadata information from system tables.
  22. Replies
    1
    Views
    544

    Gotta working

    Well noone responed on this query, may be i have not written it well so thought of adding process of backtracking with API and its working as well.Thanks to Vasii one of community guy for this...
  23. Replies
    1
    Views
    544

    HTTP Client API Query

    Team

    Having some concerns about when getting data from api, getting data is fine as i am able to get all data from api.

    My problem is when i run my problem i am able to get only 100 rows bcoz...
  24. probably this link will help you. ...

    probably this link will help you.

    http://forums.pentaho.com/showthread.php?181634-GC-overhead-limit-exceeded-Running-out-of-memory-PDI-5-2-CE
  25. hope this help

    hope this help
  26. check your server whether any other java process...

    check your server whether any other java process is running on it. kill those processes and try
  27. change your data type of filepath field to string...

    change your data type of filepath field to string in your csv file input
  28. Replies
    4
    Views
    2,338

    You are running batch file with Pan that's why...

    You are running batch file with Pan that's why you are getting this error. you need to run ".ktr" file .
    Pan /file:"Z:\Compiere\Kettle-PDI\Jobs\Production\MAJ_Emplacements\MAJ_Emplaceme
    nts.bat"
  29. Replies
    2
    Views
    925

    Jdk 1.7

    Jdk 1.7
  30. try this

    try this
  31. yep unixodbc drivers are there check some of the...

    yep unixodbc drivers are there check some of the documentation on that.
  32. you need to define ODBC on your server machine...

    you need to define ODBC on your server machine once added no driver required just access by creating a normal connection in PDI with ODBC as connection type
  33. create odbc connection for ms-access in windows...

    create odbc connection for ms-access in windows from datasource-odbc and use this connection from PDI.
  34. Replies
    1
    Views
    444

    its weird but can u check your evaluation...

    its weird but can u check your evaluation condition in the job. right click on hop in a job and you will find some of the eval conditions. probably u can add a snapsht of ur job in the post.
  35. http://wiki.pentaho.com/display/EAI/Unique+Rows

    http://wiki.pentaho.com/display/EAI/Unique+Rows
  36. Replies
    5
    Views
    2,183

    hmm modify this file...

    hmm modify this file "repository.spring.properties" . i have tried it for one user not group.
  37. Replies
    5
    Views
    2,183

    "Dashboards.context.roles" will help you out with...

    "Dashboards.context.roles" will help you out with jquery/javascript function and it looks like(check the Syntex on google)

    var roles=Dashboards.context.roles;
    if(roles.dev)
    {
    ...
  38. try to add indexes on your keys in the tables and...

    try to add indexes on your keys in the tables and run query with explain to find out the time consumption from DB
  39. Replies
    2
    Views
    481

    check the addins sample from cde reference

    check the addins sample from cde reference
  40. Replies
    5
    Views
    1,759

    thanks for the information and it resolved one of...

    thanks for the information and it resolved one of the issue which i faced relating to cda as well. when you use a single paramater more than 10 times or so you will not be able to export data with...
  41. Replies
    10
    Views
    2,582

    get file names step will help you out to get...

    get file names step will help you out to get filename pass this where ever you wanted to.
  42. Replies
    2
    Views
    470

    not able to reproduce may be doing any thing...

    not able to reproduce may be doing any thing wrong let me know.
    modified samples data "QUADRANT_ACTUALS" table and added space after "District Manager " and try to generate Btable through BTable...
  43. you can use when you create a transformation give...

    you can use when you create a transformation give the JNDI name in transformation which would be same as your pentaho server name. when you add a new dashboard as element add that endpoint from data...
  44. use this with your select query '--All--'

    use this with your select query '--All--'
  45. ok try by adding this as path /home/charts...

    ok try by adding this as path /home/charts assumption is you have charts folder inside "Home" and if you have demo/charts as flder structure try with /home/demo/charts as path
  46. did you uploaded the file in bi server or just...

    did you uploaded the file in bi server or just calling sample xactions.
  47. Replies
    5
    Views
    1,759

    looks like you have a problem with path of cda...

    looks like you have a problem with path of cda file. check the path first .
  48. tried with 5.2 CE 1. uploaded blank.xaction in...

    tried with 5.2 CE
    1. uploaded blank.xaction in admin folder
    2. created a dashboard and added xaction component added path=/home/admin and action=blank.xaction and label as test and it worked fine.
  49. Replies
    11
    Views
    1,709

    Thanks for replying. is /test52 folder and root...

    Thanks for replying. is /test52 folder and root are same partitions
    i have /apps and /home 2 different partitions. rest of the things are same which you have mentioned.

    this is what my btable...
  50. Replies
    11
    Views
    1,709

    Opening this issue again. I thought problem being...

    Opening this issue again. I thought problem being resolved, yes but up to some extent when i create biserver folder in any of the users specific folder e.g if i create biserver5.2 setup in...
Results 1 to 50 of 370
Page 1 of 8 1 2 3 4
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

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