Hitachi Vantara Pentaho Community Forums

Search Forums:

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

Page 1 of 11 1 2 3 4

Search Forums: Search took 0.03 seconds.

  1. Replies
    1
    Views
    1,472

    How to repeat Report Header on each page

    Hi Forum,

    I want to have labels placed in report header band to be repeated on each page of PDF or Excel export.
    Where and which property do I need to set to get this ?

    Any help would be...
  2. Would this be of any help ? ...

    Would this be of any help ?

    http://forums.pentaho.com/showthread.php?148352-Order-by-on-bar-chart-with-out-touching-the-query-in-CDE
  3. Hi Gutlez, Thank you for the suggestions.! ...

    Hi Gutlez,

    Thank you for the suggestions.!

    I had given a try by enabling cache in db lookups and using mysql bulk loader instead table output in Unix OS. It is now much faster.
  4. Thank you Pedro. I will try adding an add-in...

    Thank you Pedro.

    I will try adding an add-in for this in Table component.
  5. Below may be of helpful: ...

    Below may be of helpful:
    http://helicaltech.com/blogs/reading-data-from-single-data-sourcesingle-sql-query-for-two-charts-in-pentaho-cde/
  6. I am attaching my .ktr file and may be you can...

    I am attaching my .ktr file and may be you can have a look and suggest.

    Thank you.!


    18089
  7. Below is the solution found from other recent...

    Below is the solution found from other recent thread.

    Thanks Pedro.!

    function f(){
    var pDate=this.dashboard.getParameterValue('paramDate');
    alert(pDate);
    }
  8. Replies
    2
    Views
    2,202

    Thanks Pedro. ! This worked like a charm and...

    Thanks Pedro. !

    This worked like a charm and my other latest thread is answered with this.!


    function f(){
    var pDate=this.dashboard.getParameterValue('paramDate');
    alert(pDate);
    }
  9. Hi Gutlez, Thank you for inputs. I will take...

    Hi Gutlez,

    Thank you for inputs. I will take out MJS step will give a try with other alternatives.
    DB lookups are configured to return ID's to fact table. (no problem here).



    (My...
  10. How to make only single column value clickable in Table Component

    Hi Community,

    Did any one come across below scenario ?

    In table component, we can assign column type like "String", "numeric", "hyperLink" and etc.

    I need to perform drill down by...
  11. How to make only single column value clickable in Table Component

    Hi Community,

    Did any one come across below scenario ?

    In table component, we can assign column type like "String", "numeric", "hyperLink" and etc.

    I need to perform drill down by...
  12. increase performance when loading data from Oracle source to MySQL target

    Hi Community,

    How to increase performance when loading data from Oracle source to MySQL target ?

    Transformation design is as follows for fact table :

    Oracle Table input > java script step...
  13. How to alert a date type parameter value in Click Action of Table Component

    Hi,
    I have been trying to catch "paramDate" parameter value (Date type parameter) in alert method in "Click Action" of Table component but no luck.

    Did anybody able to alert a date type of...
  14. Thank you for this.! It helped me to do a POC.

    Thank you for this.! It helped me to do a POC.
  15. Replies
    1
    Views
    1,273

    baseAxisTitle and orthoAxisTitle properties. ...

    baseAxisTitle and orthoAxisTitle properties.


    http://forums.pentaho.com/showthread.php?176521-label-add-to-bar-chart
  16. I was also looking for similar functionality. ...

    I was also looking for similar functionality.

    Idashboards and and tableau have these features.

    How can we do the same in cde ?
  17. Hi, Could you please tell, how did you do it ?...

    Hi,
    Could you please tell, how did you do it ?

    Few queries .
    1) Did you display single slice in donut(pie) or how exactly it was?
    2) It is possible to get value as well percentage of slice...
  18. Grouped category for X axis for any CCC chart

    Hi Forum/Leao,

    I am excited to explore the example explained at http://jsfiddle.net/duarteleao/2nxheka0/

    I want to implement it to a normal bar graph or to a line graph( or XY type of graphs)...
  19. Solved it. Source :...

    Solved it.

    Source : http://diethardsteiner.github.io/dashboards/2014/10/15/CCC-Add-Event-Info-to-your-Charts.html

    How I used it for D3 chord :

    for(var i=0; i < dataset.resultset.length;...
  20. How to populate SQL output to D3 understandable json/matrix format

    Hi Forum,

    I am trying alert the data set using below function/method. Do anybody tried how to convert SQL output to D3 understandable format ? (This I am trying for chord diagram).

    When I...
  21. Hi Pedro, Thank you for the inputs. I am going...

    Hi Pedro,
    Thank you for the inputs. I am going to try as suggested.
  22. Replies
    3
    Views
    951

    I think you are looking for CDA editor to test...

    I think you are looking for CDA editor to test your result set. If it is the case, please open the CDA editor in Edit mode and click on Preview button. It will open a new window, there select the...
  23. Hi Pedro, Thank you so much . It worked. A...

    Hi Pedro,
    Thank you so much . It worked.
    A little extend that I am trying is :
    I wanted to have the second parameter cascaded with first parameter.
    i.e., Parameter1 values comes from SQL...
  24. Can we write expression for parameter default value ?

    Hi Forum,

    I have a parameter lets say param1 of integer type and another parameter say param2
    If I want to get param2=param1+4 , how can we do that ? Is it possible to write any java script...
  25. Hi , Thank you for your response. Could you...

    Hi ,
    Thank you for your response.

    Could you please share me how to fix it in ubutnu 14. I am really struck with it and I don't know how to update it or how to get the right jar files.?

    Thank...
  26. PDI .kettle properties file location in ubuntu and start spoon problems

    Hi Forum,
    I used tow execute transformations and jobs on windows platform.

    Recently, I have been involved in the environment setup in linux.

    I have below environment setup

    OS : ...
  27. Replies
    5
    Views
    1,089

    I didn't see any related errors. Is it going...

    I didn't see any related errors.

    Is it going to be available in the market place ? How to get the work done if not ?

    Thank you.
  28. Replies
    5
    Views
    1,089

    Hi Pedro, I am using pentaho 6 CE.

    Hi Pedro,

    I am using pentaho 6 CE.
  29. Replies
    5
    Views
    1,089

    D3 Components Group is missing in LayOut

    Hi Forum,

    Currently, I have installed all the stable versions of C-Tools (CDE, CDF,CDA & CGG). I have also installed "D3 Components Library/Gallery" but I don't see the component (4 or 5 D3)...
  30. How to use parameter(s) for schema in PSW & Saiku ?

    Hi Forum,

    I want to know how to use parameter(s) to schema in PSW and how we get that same in Jpivot view or Saiku ?

    Could anybody tell to use this feature ?

    Thank you in Advance.
  31. Replies
    2
    Views
    670

    Hi, You can use below format in your input...

    Hi,

    You can use below format in your input control to have 'All'.

    SELECT 'All' <aliasName> FROM <tableName>
    UNION
    SELECT <fieldName> <aliasName> FROM <tableName>
  32. Hi Gutlz, Thank you very much for your...

    Hi Gutlz,

    Thank you very much for your continuous valuable suggestions.

    Yes, you are right, the post initially talked about less secure option. Now with your inputs I made changes and given...
  33. * Yes, I am 100% sure to turn ON for gmail. (for...

    * Yes, I am 100% sure to turn ON for gmail. (for yahoo, I didn't check whether there is an option for less secure turn on or off, it just worked).
    * No, I don't see any option in Pentaho that can...
  34. Thank you. It worked now. Documented here. ...

    Thank you.

    It worked now.

    Documented here.
    Pentaho CE 6.0 BA Server Gmail/Yahoo Mail Server Configuration - How to Guide ...
  35. Email (gmail) configuration in Server - gmail/yahoo/hotmail

    Hi Forum,

    I got below error message while configuring and testing gmail setup.
    Test Email Configuration
    Unable to complete email configuration test.
    Verify settings and try again.


    Below...
  36. Hi Gutlez, Thank you for your inputs, would be...

    Hi Gutlez,
    Thank you for your inputs, would be helpful.

    I have come across meta data injection step on how to use it for my problem. What I understood from meta data injection was it will store...
  37. Row and Column Index of "Preview Data" for a transformation

    Hi Community,

    What is the row and column index of preview data of a transformation ?

    USE CASE : Processioning of a CSV file with Java script.

    How to insert the values in respective fields...
  38. Replies
    3
    Views
    1,911

    Hi, Below is my approach to solve the...

    Hi,

    Below is my approach to solve the problem.

    Data Grid -> Add value fields changing sequence -> Java Script.

    var res = field.concat(seq);
    var...
  39. I hope this helps! ~[ATTACH]15393[/ATTACH

    I hope this helps!
    ~[ATTACH]15393[/ATTACH
  40. I have tried as Matt explained. File 1 : ...

    I have tried as Matt explained.

    File 1 :
    product,a,b,c,d,e,f,g,value
    pp0,1,2,3,4,5,6,7,8
    pp1,11,21,31,41,51,61,71,81
    pp2,12,22,32,42,52,62,72,82

    File 2 :
    product,b,c,g,value
  41. Thank you both of you, your suggestions are...

    Thank you both of you, your suggestions are valuable.

    I have given an attempt as explained at http://www.ibridge.be/?p=194 in my case and it can be achievable.

    Need to have a deep dive into...
  42. How to handle csv files with varying meta data between 1 to 7 columns

    How to handle csv files with varying meta data between 1 to 7 columns

    CSV file-1 :
    a , b ,c ,d, e, f, g, value
    ------------------------
    -----------------------
    --------------------------
    ...
  43. Replies
    1
    Views
    519

    I'm interested to know how to do it in CCC ? Had...

    I'm interested to know how to do it in CCC ? Had anyone looked into this earlier ?

    Thanks.
  44. Please check your log and see what causes you not...

    Please check your log and see what causes you not displayed the data.
  45. Replies
    5
    Views
    1,600

    Hi Pedro, I have never opened a ticket in jira...

    Hi Pedro,

    I have never opened a ticket in jira yet, could you please share the link and how to go ? I would like to open a jira ticket on this.

    Thank you in Advance :-)

    Best Regards,...
  46. Replies
    2
    Views
    1,954

    Hi, I had a similar requirement in one of my...

    Hi,

    I had a similar requirement in one of my POC's. I had done below to make the components to listen to the selects after clicking "submitt" only button instead individual selection.

    1)...
  47. You can try similar to this stack overflow thread...

    You can try similar to this stack overflow thread for your parameter default value.

    http://stackoverflow.com/questions/14434777/how-to-get-first-day-of-current-year-in-javascript

    Thanks
  48. Hi, This post may give you the idea on custom...

    Hi,

    This post may give you the idea on custom date input parameter default values. Get current date using java script/jquery and place it in place of parameter in the code that you will see in...
  49. Replies
    5
    Views
    1,600

    Hi Pedro, Thank you for your replay. I...

    Hi Pedro,

    Thank you for your replay.

    I want to get all the queries in CDA drop down as
    DataAccessID : query1
    DataAccessID : query2
    DataAccessID : query3

    When I select query1 or query3...
  50. Replies
    8
    Views
    2,281

    Hi, I can re-produce the same issue with the URL...

    Hi,
    I can re-produce the same issue with the URL format you had taken. It's not the correct way of using after 2nd dashboard URL.

    Use ?(question mark) instead of & after URL.

    Example : ...
Results 1 to 50 of 533
Page 1 of 11 1 2 3 4
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

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