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

Search Forums:

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

Page 1 of 3 1 2 3

Search Forums: Search took 0.12 seconds.

  1. Load values from table based on Max Time stamp and by id

    hi all,

    I want to load data from one table to dwh table on hourly basis, my requirement is to read maximum time stamp of each product and then load the row which are greater than that time stamp...
  2. Replies
    0
    Views
    88

    Published Analysis keeps changing

    Hi,

    I published a cube to penatho 5.0.1 ce server,with data source 1

    but when i look in server analysis it is associated with data source 2 if i change to 1 it ok for a while but again after...
  3. hi all, i am unable to get it worked had...

    hi all,

    i am unable to get it worked had anyone got an alternative for this
    i need to schedule a report daily with previous day report
  4. Thank you mcampbell, i am loading date table...

    Thank you mcampbell,

    i am loading date table with 5 years which makes it 1825 rows
    if i load both the date and time in same table i guess if it's low level in seconds, it make's
    my date...
  5. Replies
    6
    Views
    2,383

    hi kouki, Do you mean its done? if soo could...

    hi kouki,

    Do you mean its done? if soo could you help me with that ?
  6. Thank you mcampbell, It worked perfectly for...

    Thank you mcampbell,

    It worked perfectly for date dimension
    But i have two dimensions date(day,month,year) and time(hour,minutes) as we have two tables differently so is there a way to get it...
  7. calculated measure using previous member of selected dimension

    hi all,
    i have a cube where we get measure as maximum number for select dimension and date

    now i have want calculated member as selected date and dimension measure-select dimension and previous...
  8. HI Taqua, Had tried the attached file as...

    HI Taqua,


    Had tried the attached file as suggested but still not getting the way it supposed to be when scheduled in pentaho ce 5.0.1 server

    I am i missing any thing

    13717
  9. Calculated measure based data range value records

    Hello

    sorry if title doesn't make any sense, ok

    i designed a cube in which there is a measure that defines number of products sold in particular time period that works fine

    now i need to...
  10. Scheduling Report for automatic data generation every day

    hi GUltez,


    this is the replica of my report with sample data, everything runs fine when running on Puc with the function i used

    i want to schedule it every day for the report of previous...
  11. HI Just add this function in puclogin.jsp ...

    HI


    Just add this function in puclogin.jsp





    and call this function under $(document).ready(function(){
  12. Replies
    6
    Views
    2,383

    hello, Try this link ...

    hello,

    Try this link
    http://infocenter.pentaho.com/help/index.jsp?topic=%2Fsecurity_guide%2Ftask_auth_cas_sso.html

    i haven't done yet but it might be useful
  13. Thank for the Reply gultez, i created a extra...

    Thank for the Reply gultez,

    i created a extra parameter type--string with default value as =yesterday(), but this also results the same
    when i schedule it results same, doesn't update with...
  14. BUG or a windows security update problem

    hello all,

    I am using pentaho 5.0 it runs successfully but recently windows updated some security updates after that when i try to load
    puc it just keeping on loading with message saying just...
  15. dashboards,reports in lifreray iframe 6.2

    hello all,


    we integrate liferay 6.2 and pentaho 5.01 successfully and both running on same port

    now i posted pentaho reports on liferay portal using iframe for display purpose


    copied...
  16. scheduled report date parameter prompt error

    hello all,

    i created a report with a date as prompt with the function which results in previous date everything works fine on server

    but when i scheduled the report for daily and sending it...
  17. Hi VJ, NOt yet but for now i am using...

    Hi VJ,

    NOt yet

    but for now i am using combination of MDX and Pentaho Report designer to get this done

    Publish it on server and schedule it to receive by email
  18. Date key and time key behaviour strange with measure max value

    i defined a schema in which fact table contains date key yyymmdd and time key HHmmss and measures with dimension keys

    i defined a measure to get max value say meausre1

    when i select the a day...
  19. Replies
    3
    Views
    208

    Thank you guys really appreciated for quick...

    Thank you guys really appreciated for quick response

    It helped me understand the denormalise step in depth

    in my case there is another important column i.e is ERM_ACTL_VLS_LNS_PM_ID the time...
  20. Replies
    3
    Views
    208

    de-normalize step confusion

    i have created a transformation attached below

    i have data with four constants in normalized form with each having different rows as below

    'EGYCON=1257'
    'ACTCON'=1257
    'EGYPF'=1272
    EGYGEN=168
  21. Differentiate Measures based on constant value in other column

    hello,

    I designed a cube in which all the different measures in one column, and other column contains a constant value to differentiate which is which.

    p1----10----type1

    p2----20-----type1
    ...
  22. Time , date Dimension---aggregate values very slow response

    Hello all,

    I designed a schema in which we have measure and date,time and product dimensions

    The date dimension contains date,year,month and quarter columns and a primary key to yyyyMMdd is a...
  23. Replies
    1
    Views
    154

    de-normlize table based on two coulms

    hello all,

    Actual Table

    ID------Value------ Identifier------ Timestamp
    1 -------20 ----------A -----------2014-05-05
    2 -------30 ----------A -----------2014-05-05
    1--------.2...
  24. Replies
    1
    Views
    247

    hey anyone just tell me is it a good idea to run...

    hey anyone just tell me is it a good idea to run pentaho 5.0.1 CE on jboss 7 if it is, is it possible

    please point to some reference documents to achieve this
  25. Replies
    1
    Views
    184

    Hello all, Seems like this is a bit confusing...

    Hello all,

    Seems like this is a bit confusing and my explanation made it worse i guess,

    i try to make it simple need the results as per that ktr for every hour and day and that to its an...
  26. Replies
    1
    Views
    184

    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...
  27. 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...
  28. Replies
    6
    Views
    313

    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
  29. Replies
    6
    Views
    313

    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
  30. Replies
    6
    Views
    313

    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...
  31. 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...
  32. 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...
  33. 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...
  34. 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...
  35. 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:...
  36. 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...
  37. Replies
    1
    Views
    162

    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...
  38. 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/
  39. 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...
  40. 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...
  41. 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.
  42. 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...
  43. 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
    ...
  44. 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...
  45. Thank You Marabu, Point Noted

    Thank You Marabu, Point Noted
  46. 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....
  47. 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...
  48. 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...
  49. 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...
  50. 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...
Results 1 to 50 of 122
Page 1 of 3 1 2 3