Hitachi Vantara Pentaho Community Forums

Search Forums:

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

Page 1 of 2 1 2

Search Forums: Search took 0.02 seconds.

  1. how to create drill down report in pentaho report designer

    Hi,
    I am trying to create drill down report in pentaho report designer. My end goal is to to display the report in the same page as the main report (just below the parent report)or a pop will also...
  2. Vertica Bulk Loader is not working when running in UNIX environment with cluster

    Hi,

    I am trying to use vertica bulk loader utility, but it seems it is not working when running on unix with cluster mode.
    Below is the error Which I am getting:
    It was not possible to load...
  3. Vertica Bulk Loader Is not working when running on Carte

    Hi,
    I am using vertica bulk loader to load the data from source. When running without cluster it is working fine but when trying to run on cluster I am getting
    below error:
    It was not possible to...
  4. Metadata injection is not sending the metadata when running in clustered environment

    Hi,

    I facing some issue with metadata injection step when running in clustered environment, when running locally it is working fine.

    I have attached my transformation also.

    I am using...
  5. Replies
    0
    Views
    604

    Parent Child Hierarchy Table

    Hi,

    Is it possible to create parent child hierarchy table,using table component or any other component.

    For ex: In parent table there few columns like ticket id,ticketname and when I click on...
  6. How to execute Query which uses Temporary tables

    Hi All,

    I am trying to execute a sql script which is has one temp table, I am using SQL OVER JNDI, but while executing it is giving me below error
    Caused by:...
  7. Hi Campbell, I followed the above link and...

    Hi Campbell,

    I followed the above link and able to pass the current date in where clause but now the problem is it is getting applied on all the attributes. Attached my mondrian_sql.log and...
  8. how to write now() functions in Where Clause in MDX quries

    Hi,

    This may be a basic question:) but I am not able to get a solution for this.

    I wanted to find out all the records from current date -30 days, but not able to write it in MDX query.
    My...
  9. Replies
    4
    Views
    826

    Thanks Again Cambell, I have Tried the...

    Thanks Again Cambell,


    I have Tried the second option with Java Script. Attached zip folder to reproduce the same error in Mysql Environment.

    Request you to please look into the attached...
  10. Replies
    4
    Views
    826

    Hi Campbell, Thanks For your reply. I have...

    Hi Campbell,

    Thanks For your reply.

    I have tried below options: CaptionExpression and memberFormatter (Not Sure Implemented in right way or not)


    1:CaptionExpression:

    <Level...
  11. Replies
    4
    Views
    826

    Timestamp Datatype predicate with .0

    Hi,

    I am stuck with one issue. with timestamp datatype.
    My cube has few fields as timestamp data type and in UI it is coming as 22-01-2015 23:55:59.0, I wanted to omit the last ".0".
    have...
  12. Role Based integration issue in Pentaho BI UI

    Hi ,

    I have customized pentaho UI completely by re-using existing code. Now am looking to achieve role based integration on my few menu items with the help of below code

    <script...
  13. Hi, Try after adding -XX:+UseConcMarkSweepGC...

    Hi,

    Try after adding -XX:+UseConcMarkSweepGC in spoon.bat file .This works for me hope holds for you as well.

    Thanks,
    Malay
  14. Replies
    3
    Views
    1,436

    Hi Fcavalli, Use the below query and change...

    Hi Fcavalli,


    Use the below query and change the table name accordingly.


    select LJL.jobname,ltl.TRANSNAME from LOG_TRANS_LEVEL ltl
    join LOG_CHANNEL LC on LC.CHANNEL_ID=ltl.CHANNEL_ID
    join...
  15. Hi KP, PFA Zip folder. Thanks, Malay

    Hi KP,

    PFA Zip folder.

    Thanks,
    Malay
  16. Replies
    3
    Views
    1,436

    Hi, Look for the logging channel. That will...

    Hi,


    Look for the logging channel. That will help you to join with the other table, you can refer it as a bridge table.
    For detailed information go to this link...
  17. Replies
    3
    Views
    1,995

    Hi, It works like a charm, If you use it...

    Hi,

    It works like a charm, If you use it properly.
    For your reference you can take a look to the attached transformation.
  18. Hi, Take Select step after you read from the...

    Hi,

    Take Select step after you read from the source and remove the unwanted columns .
    Thanks,
    Malay
  19. Replies
    2
    Views
    1,272

    Hi vandyc...

    Hi vandyc ,

    PFA transformation, may be that will not the optimum solution but this way you will be able to get your desired xml output. You can also use one ADD XML and one XML OUTPUT step to...
  20. Try to handle the error for csv input step. 14238

    Try to handle the error for csv input step. 14238
  21. Hi Mattia, PFA, Zip folder. Hope that will...

    Hi Mattia,


    PFA, Zip folder. Hope that will solve your problem.

    Thanks,
    Malay
  22. Hi Mattia, No it will not show you the content...

    Hi Mattia,

    No it will not show you the content from all the excel files at the time of "Preview Rows" but when you run your transformation you will get values from all
    the Excel Sheets say for...
  23. Replies
    4
    Views
    836

    Thanks Bruno, It really helped. I'll look on...

    Thanks Bruno,

    It really helped. I'll look on to this issue.
  24. Replies
    4
    Views
    836

    hanka Thanks Bruno for your time. I am...

    hanka


    Thanks Bruno for your time.

    I am interested to know If I enable the logging that PDI provides. will it It impact the overall run time of Job.

    I wanted to enable the logging for our...
  25. Replies
    4
    Views
    836

    Performance Measure If Logging Is Enabled

    Hi,

    I wanted to know If I will enable the logging and run the job it will impact on overall performance ?

    Is there any way I can measure job performance other then feed the sample data and run...
  26. Hi Michael, I am not sure , I got your point....

    Hi Michael,

    I am not sure , I got your point. So according to my understanding I am not finding any problem in writing to text file (No carriage or Line Feed ).
    PFA, transformation with the...
  27. Hi Michael, Use String Operations Step before...

    Hi Michael,

    Use String Operations Step before writing to a file.
    Select "carriage return & line feed " in Remove Special Character and for In Stream column Select your filed in which you wanted...
  28. Replies
    17
    Views
    13,649

    Hi Phani, If you have some restriction to...

    Hi Phani,

    If you have some restriction to upgrade to 5.2 , then you can use external Java script ,I'll try to provide you a sample .prpt file but need some time as I have done this long before on...
  29. Replies
    3
    Views
    2,107

    Hi, I am able to resolve my problem just for...

    Hi,

    I am able to resolve my problem just for information to other Open (installation Directory\biserver-ce\pentaho-solutions\system\common-

    ui\resources\web\prompting\...
  30. Replies
    1
    Views
    1,163

    after so much of googling and so much of R&D I am...

    after so much of googling and so much of R&D I am able to solve my problem. Just for information to others ,if they get stuck in the same situation.




    Open pentaho-prompting-component.js...
  31. Replies
    1
    Views
    1,163

    Autocomplete is not working in google chrome

    Hi,

    I am struggling to get autocomplete work with google chrome.
    I am explaining my problem in detail:

    I have one sample prpt that excepts text parameter , when I am deploying this prpt to the...
  32. Replies
    3
    Views
    2,107

    autocomplete in textbox

    Hi,

    I wanted to give autocomplete limit in text box. I have one prpt report that contains text box parameter, when I deployed it over the server it shows auto complete which some times turn into...
  33. Replies
    0
    Views
    675

    Customization In Date Picker

    Hi,

    I wanted to give some validation over the date picker parameter. For example if I have selected 15-10-2014 as a start date, so for end date user should not be able so select date less than...
  34. Hi Cris, Last year I had a chance to work on...

    Hi Cris,

    Last year I had a chance to work on MS SQL Server 2008 and for me also same error and able to fix it not sure whether the below troubleshoot step will help you or not but you can give a...
  35. Replies
    0
    Views
    1,249

    Multi Tenancy in Pentaho BI server EE 5.0

    Hi,

    Is there any document available to achieve Multi tenancy in BI server? I found some links but not able to find any success Link which I have refereed...
  36. Replies
    3
    Views
    925

    Hi Kwv, I am also trying to achieve CAS...

    Hi Kwv,

    I am also trying to achieve CAS authentication in CE 5.0. Was able to do it in 4.8 but same when I am trying to do in 5.0 giving me some handshaking error . Can you please post, used...
  37. Replies
    2
    Views
    2,433

    Thanks for the solution you provided, It really...

    Thanks for the solution you provided, It really helped !! It works fine with fusion_plugin 2.2 .
  38. Replies
    2
    Views
    2,433

    Fusion Chart Integration with pentaho 5.0

    Hi All,

    I am facing one issue while integrating fusion chart plugin with Pentaho 5.0, Previously it used to work with 4.8.
    CDA : 5.0.1
    CDF : 5.0.1
    fusion_plugin:2.1
    BI server: 5.0
    OS:...
  39. Replies
    0
    Views
    1,027

    Pentaho Reporting Output

    Hi,

    I have an secnariao where I am generating reports designed in PRD using penthao Reporting out put.

    My problem in when I am feeding a PRPT which is not containing any parameters works fine...
  40. Hi, Is there any workarround to achieve the...

    Hi,


    Is there any workarround to achieve the same on 5.0 CE .
    I have tried but giving me multiple errors in applicationContext-spring-security-cas


    2014-02-25 19:57:01,588 ERROR...
  41. Replies
    1
    Views
    1,744

    HI, Which version you are using, I am trying...

    HI,

    Which version you are using, I am trying to achieve SSO authentication in BI server 5.0 but getting error I have posted in this thread.Can you please have alook on to it and guide me where I...
  42. Replies
    5
    Views
    2,586

    No ..still digging in.

    No ..still digging in.
  43. Replies
    5
    Views
    2,586

    CAS authentication in pentaho BI Server 5.0

    Hi,
    I am trying to do CAS authentication in pentaho 5.0 for this I have followed tutorial defined
    http://blog.datamensional.com/2011/07/pentaho-sso-setup-using-cas-and-ldap/...
  44. Saiku showing empty result, Even If query is returning some rows

    Hi,

    I am explaining my problem through attached screen shots please guide me how to over come this problem.



    I am using saiku 2.5 with pentaho 5.0
  45. Thread: Column format

    by mt25
    Replies
    7
    Views
    1,687

    Hi, Hope attached will help you but I think...

    Hi,

    Hope attached will help you but I think this is not the optimal solution, though it might help you out.

    Thanks,
    Malay
  46. Replies
    0
    Views
    1,005

    Error While Connecting to DI slave server

    Hi,

    I am trying to use Data Services via Thin Kettle JDBC Driver. For this I am using the sample transformation that ships with Pentaho, and and trying to run the job on slave server and wanted to...
  47. Hi, For 403 error you need to register your...

    Hi,

    For 403 error you need to register your app in magento after that you will get secrete key and consumer key, later on we can pass this in REST API in kettle.

    If you have any sample access...
  48. Hi, I have replied to the thread which you...

    Hi,

    I have replied to the thread which you have started for REST API for Naimish, can you please provide a bit more detail API link, parameter.For better insight.

    Thanks,
    Malay
  49. Hi, Hope Attached will help you.12314 ...

    Hi,

    Hope Attached will help you.12314

    Thanks,
    Malay
  50. HI, Hope attached will help you .

    HI,

    Hope attached will help you .
Results 1 to 50 of 83
Page 1 of 2 1 2
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

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