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.09 seconds.

  1. Remove zip files which are older than a week

    hi all,

    I taking full backup of all databases every day and making a single zip file and storing it in folder with date append

    Ex:Backup_full_2014-09-15.zip

    Now i want to remove the zips...
  2. Exactly what i want is just Edit schedule screen...

    Exactly what i want is just Edit schedule screen alone as users requesting they need access to add/remove emails frequently and change times accordingly. is there a way to do it
  3. Schedules as Separate page to display in portal

    Hello,


    I need to give access to user to add email-id or change timings or to pause reports that are scheduled in the pentaho scheduler, as most of the user are
    non-tech guys it should be...
  4. Moving file from local to remote system in ETL

    Hi all,

    We take backup of DB every week so i have to move that file to remote system, but before moving i need to compress that, is it possible using PDI, any ideas would be great help for me
  5. 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...
  6. Replies
    0
    Views
    111

    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...
  7. 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
  8. 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...
  9. Replies
    6
    Views
    2,415

    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 ?
  10. 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...
  11. 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...
  12. 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
  13. 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...
  14. 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...
  15. HI Just add this function in puclogin.jsp ...

    HI


    Just add this function in puclogin.jsp





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

    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
  17. 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...
  18. 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...
  19. 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...
  20. 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...
  21. 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
  22. 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...
  23. Replies
    3
    Views
    226

    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...
  24. Replies
    3
    Views
    226

    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
  25. 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
    ...
  26. 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...
  27. Replies
    1
    Views
    168

    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...
  28. Replies
    1
    Views
    261

    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
  29. Replies
    1
    Views
    199

    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...
  30. Replies
    1
    Views
    199

    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...
  31. 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...
  32. Replies
    6
    Views
    336

    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
  33. Replies
    6
    Views
    336

    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
  34. Replies
    6
    Views
    336

    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...
  35. 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...
  36. 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...
  37. 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...
  38. 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...
  39. 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:...
  40. 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...
  41. Replies
    1
    Views
    170

    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...
  42. 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/
  43. 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...
  44. 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...
  45. 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.
  46. 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...
  47. 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
    ...
  48. 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...
  49. Thank You Marabu, Point Noted

    Thank You Marabu, Point Noted
  50. 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....
Results 1 to 50 of 126
Page 1 of 3 1 2 3