US and Worldwide: +1 (866) 660-7555

Search Forums:

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

Page 1 of 2 1 2

Search Forums: Search took 0.01 seconds.

  1. Replies
    0
    Views
    29

    Suggestion Required on this KTR

    HI all,

    I being working with PDI for a month and still not able to deal with this requirment

    Let me explain the requirement

    1.property file data grid contains formula which results should...
  2. Thanks Marubu, I did achieved the task now the...

    Thanks Marubu,

    I did achieved the task now the calculations of units are perfect and everything run fine when i work with whole table.
    i am getting rows till completed hour from input table as...
  3. Replies
    6
    Views
    101

    Thanks Gultez and Darnell, I am going with...

    Thanks Gultez and Darnell,

    I am going with gultez solution as i am not much fan of javascript, but how to get last run's to time for from time is where i got struck
  4. Replies
    6
    Views
    101

    Thank You MIck, I am using input step to get...

    Thank You MIck,

    I am using input step to get data but i don't want the data of present running hour, so that i get all completed hourly data loaded to another table
  5. Replies
    6
    Views
    101

    Get data till Last hour from table inut

    Hello all

    i had a job which runs every hour, i need to get data till end of the last hour only

    lets say if system time is 2014-04-14 07:01:55 at time of job runs, i need to get records till...
  6. Thanks Dzmitry, I created a transformation to...

    Thanks Dzmitry,

    I created a transformation to get data as meter1/ units / Actual Units(will be calculated) / time / meter2 ...
    and done required calculation but i not able to put those in...
  7. Hi Marabu, Sorry for that thread...

    Hi Marabu,


    Sorry for that thread that was created for another person and posted unknowingly,,

    we need to check the last row record of the output table for any meter Id, and read that...
  8. Thanks Dzmitry...

    Thanks Dzmitry

    The Data Flow table 1 is loaded every hour with 100 meters data for that hour, only the formula file is static(in some cases Slowly changing)

    any way I am trying the way you...
  9. Thanks Dzmitry, Really appreciated for quick...

    Thanks Dzmitry,
    Really appreciated for quick response

    we did everything in complete java, but requirement is to move to etl tools (kettle),

    The formula file is slowly Changing (i would say no...
  10. Read Formulas from Property File and calculate accordingly in table

    Hello EveryOne,


    we have a requirement to read formulas from Property file and calculate accordingly
    Key --- Value
    Meter1 -- Meter2
    Meter4 --- Meter3+Meter5

    Formula:...
  11. Thanks marabu table1:meterid,reading,timestamp...

    Thanks marabu

    table1:meterid,reading,timestamp
    table2:meterid, units,Actual_units,timestamp-----[hourly data table]

    Actual_units calculation is like difference of units like...
  12. separate Pentaho. log File for each day

    Hello,

    I need to create a one separate pentaho.log file for each day, is it possible just like catalina log files

    I edited some filed like
    <param name="MaxFileSize" value="500KB"/> <param...
  13. hello Exaltra This might get handy ...

    hello Exaltra


    This might get handy

    http://anonymousbi.wordpress.com/2013/12/15/pentaho-bi-server-5-0-1ce-mysql-installation-guide/
  14. Thank you Marabu Got it and successfully...

    Thank you Marabu

    Got it and successfully implemented


    now i getting units for meterid 1 from 0 to 23 for first day and second day so on
    i missing units for 0'th hourly every day i.e null...
  15. atttched .ktr file for refrence

    Thank You Marabu for your support.

    I created this ktr as suggested and achieved the format as required till Analytic query i am getting null value by using Lag 1 for group by Hour,

    its working...
  16. Thanks Gutlez, Grant all permissions to *.*...

    Thanks Gutlez,

    Grant all permissions to *.* for root user on mysql workbench in os x does not effect for unknow reason
    i tried those statements using terminal then it worked strange.
  17. DATA from on table to another with Hourly totals calulaction atttched .ktr

    Hello Everyone

    Thanks Marubu

    I created the Transformation as explained

    the problem i am facing is, its not grouping meter wise, hour, day. i.e its not getting one record per hour after...
  18. Kettle My sql database connection error on os x

    i am using kettle in windows from a quite some time with out any problem

    i tried using kettle on mac shows the below error , mysql Database are working fine with give username and password
    ...
  19. Thanks gultez, I have written a bat file and...

    Thanks gultez,

    I have written a bat file and scheduled it using task scheduler, i was just curious to know which scheduler is better in performance and monitoring

    task scheduler or use quartz...
  20. Thank You Marabu, Point Noted

    Thank You Marabu, Point Noted
  21. did tried but i am struggling to start up give me...

    did tried but i am struggling to start up give me something to start up............. i am counting on you guys... really confused how to achieve this....
  22. DATA from on table to another with Hourly totals

    hello all,

    I am new to PDI 4.4, BI Server 4.8 CE and DB MYsql
    our requirement is to load data from table1 to table2,
    table1 contains meter reading records for every 45 second for around 60...
  23. Thanks Mick, I was done with two parts could u...

    Thanks Mick,

    I was done with two parts could u plz elaborate on scheduling, like i have to publish this to puc or how i make this job automatized say run every hour ..

    if we double click on...
  24. Load files from folder to database using ETL

    Hello,

    I am New to PDI i have to read the files present in a folder and insert data to mysql table and move those files to different location this has to run every hour or when ever files present...
  25. Mail if at all Scheduled report mailing fails

    Hi there,

    I successfully scheduled a report and getting through mails,
    i want a solution if at all the scheduled fail to send a mails as per schedule can i get a mail about this as we don't known...
  26. Replies
    0
    Views
    92

    Pentaho 5.0 ce with Jboss and CBF

    Hi there,

    I was trying to run Pentaho 5.0 with jboss 7 and also include Community Build Framework

    i tried couple of threads ...
  27. Replies
    1
    Views
    696

    hello ankitsha, I need the same but with...

    hello ankitsha,

    I need the same but with parameter like date with datevalue(now()-1) is it possible at all....thanks
  28. Report not working in puc timeutil.js,formatting.js

    In the catalina log I see something like this: "GenericServlet.ERROR_0004 - Resource /reporting/reportviewer/common-ui/util/timeutil.js not found in plugin common-ui", but if I search for this...
  29. Multi parameters date to and from, triggering problem

    hi all,

    I created a report with 3 parameters as input parameters Can we make this report to execute till we select all the parameters instead of refresh for every selection of parameters

    12630
  30. Replies
    1
    Views
    281

    Hello I been looking for same let me if u...

    Hello

    I been looking for same let me if u solved
  31. Replies
    1
    Views
    144

    CDE- Error Strange thing

    HI,
    I am using BI-server 4.8 stable version, I installed all the ctools available in market place only Stable version.

    But the thing is see below screenshot, some of the component of cde data...
  32. Replies
    3
    Views
    918

    Hi there, It seems like i am missing the...

    Hi there,


    It seems like i am missing the folders /common-ui/util/ , /cdf
    in this path solutions/system/reporting/reportviewer/common-ui/util/ i am just wondering that if i created this folder...
  33. Replies
    12
    Views
    2,858

    Thanks that worked like a charm.... do u have...

    Thanks that worked like a charm....
    do u have any thing to popup the value of cgg dial when we move cursor over it
  34. Thanks for Quick reply i am using 3.5.0., Pentaho...

    Thanks for Quick reply i am using 3.5.0., Pentaho 4.8.0 stable version..
    is it to Just download mondrain3.6.1.jar file from source forge and put it in...
  35. Hello Usha, hey Same problem here, would u...

    Hello Usha,

    hey Same problem here, would u mind to Share ur solution for that if at all its solved...
  36. Replies
    1
    Views
    197

    Hello, i have return this script new...

    Hello,

    i have return this script
    new Date(+new Date-86400000).getDate() + '-' + (new Date(+new Date-86400000).getMonth()+1) + '-' + new Date(+new Date-86400000).getFullYear();

    this displays...
  37. Replies
    1
    Views
    197

    java script forums...

    Hello all,
    Just wondering is there any good forums for Java script as good as this one..........especially for scripts usefully in Dashboard developments like getting the present date and a week...
  38. (case when (hour(dbdate) < 4) then...

    (case when (hour(dbdate) < 4) then date_format((cast(dbdate as date) - interval 1 day ),'%d-%m-%Y') else date_format(cast(dbdate as date),'%d-%m-%Y') end) AS `reportingdate`
    this worked for me in...
  39. day as 0400 to 0400

    Hello Every One,
    Wish u a very happy and easy debugging new year..............

    i have written a case to make view from original fact table to make my reporting day as 0400 to next day 0400hrs...
  40. thanks darnell.nelson.. i got the first one,...

    thanks darnell.nelson..

    i got the first one, would u mind to explain the second option in detail that would be a great Thank U For Your Time
  41. day is 0400 to 0400 of next day in cubes

    hello,

    I had strange requirement my day should be from 0400hrs to 0359hrs of next day, but the date should be same of that day

    example if we consider 11-12-13 it should be 0400hr of 11-12-13...
  42. Replies
    2
    Views
    388

    got it worked if any one had a similar problem i...

    got it worked if any one had a similar problem i can explain

    thanks to all who ever tried to sort me out.....Thank U For Your Time
  43. got the syntax it is with member...

    got the syntax it is

    with
    member [measures].[ma1] as 'Round([measures].[m1],2)'
    member [measures].[ma2] as 'Round([measures].[m2],2)'
  44. Replies
    1
    Views
    283

    hey got it worked my bad little confuse when...

    hey got it worked my bad little confuse when posted

    it simple inherits the year from the above graph
  45. saiku report--daily executions and send by mail

    hello,

    Is it possible to save the saiku report in required form with a date parameter set to something like (date.previous date)

    and automated it by scheduling to run daily at 0700hours and...
  46. Replies
    12
    Views
    2,858

    helloo - How can I increase the font for the...

    helloo

    - How can I increase the font for the values in the dial? and interactive like place a cursor on it, should show values just like other charts in bar , pie etc
  47. Replies
    1
    Views
    283

    click action for drilling down

    hello all

    I have designed a dashboard to show yearly values,

    and and a click action to popup monthly for particular year clicked works fine upto here.

    function f1(s,c,v){...
  48. Replies
    2
    Views
    331

    let me know if bar,line combination works in cde,...

    let me know if bar,line combination works in cde, i know i can use prd for this but i don't know how to use schema/cube as data source
  49. rounding off values in cube and mdx query

    hello,

    I have designed a cube where all measures shown only two decimal of the values(using formatterstring #,##.00) in saiku analytics's works fine

    but when i wrote a mdx query using that cube...
  50. Replies
    2
    Views
    388

    hello, any guidance would be apreciated....

    hello,

    any guidance would be apreciated....
Results 1 to 50 of 97
Page 1 of 2 1 2