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

Search Forums:

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

Page 1 of 53 1 2 3 4

Search Forums: Search took 0.16 seconds.

  1. Replies
    1
    Views
    26

    Try the Mail Job Entry...

    Try the Mail Job Entry
  2. Thread: automatic Job

    by gutlez
    Replies
    2
    Views
    35

    You have spaces in your names... Did you...

    You have spaces in your names... Did you remember to enclose them in quotes?

    kitchen.bat /rep:Kettle /job:PAs aelter als 2 Wochen /dir:/CMP - MyFactory/MyFactory/ /user:admin /pass:Passwort1
    vs...
  3. I don't know that there's an easy way to do that,...

    I don't know that there's an easy way to do that, short of joining on just the phone number, and then filtering out the records that don't meet your time window. You could do a calculation...
  4. Replies
    5
    Views
    207

    Usual answer on this: Start back at the...

    Usual answer on this:
    Start back at the beginning to figure out what's going on.

    Excel Input -> Text File Output. If that runs, then add the next step from your transform, and repeat.

    Note...
  5. Replies
    2
    Views
    105

    Each Job Entry has the option of allowing you to...

    Each Job Entry has the option of allowing you to execute the next step based on success or on fail.
    You can use this functionality to send mail on steps that fail to execute completely.

    You also...
  6. Replies
    4
    Views
    482

    You can configure Firefox to pass NTLM...

    You can configure Firefox to pass NTLM information to the server. (See here)
    I'm not sure how you configure the server to understand it.

    Short answer: I can get you one step closer, but not all...
  7. Replies
    10
    Views
    179

    Two ways I can think of: 1) Your calling Job...

    Two ways I can think of:

    1) Your calling Job would specify the carte server as an "Execute on remote server" for an additional job that would collect the file, and process it.
    2) Your calling Job...
  8. Replies
    10
    Views
    179

    Another option is to have a Carte server running...

    Another option is to have a Carte server running "near" the database, which will grab that text file, and process it into the DB... Thus your network roundtrip times are a lot shorter.
  9. Replies
    10
    Views
    179

    After you swap the Insert / Update with an Update...

    After you swap the Insert / Update with an Update step, you still have to select the "Don't perform lookup" box, or it will still do a lookup first. Don't ask - I don't know why it does that.
  10. Replies
    10
    Views
    179

    You might be able to squeeze a little bit more...

    You might be able to squeeze a little bit more out of it by using an Update step, and disabling the lookup. But that shouldn't improve the speed much. Do you have cache turned on on the Combination...
  11. Have a good look at:...

    Have a good look at:
    http://wiki.pentaho.com/display/EAI/Dimension+Lookup-Update
  12. Replies
    1
    Views
    101

    Something like:...

    Something like:...
  13. Replies
    1
    Views
    103

    You'll get a better response if you either fill...

    You'll get a better response if you either fill out the form at http://www.pentaho.com/contact
    or call one of the numbers found on that page.
  14. You could define error handling for the step that...

    You could define error handling for the step that is having issues, and then redirect the "error" rows to a text file to review.
  15. Thread: Update Step

    by gutlez
    Replies
    2
    Views
    103

    Are you using the Update step, or the Insert /...

    Are you using the Update step, or the Insert / Update step?

    Insert / Update has to do a query first to determine if the row exists, and then do an Insert if it doesn't.
  16. Replies
    4
    Views
    210

    But if you have to edit the entry anyway to...

    But if you have to edit the entry anyway to update the filename that you are calling, then you can edit the log file at the same time.
  17. Replies
    5
    Views
    150

    Usual answer - make it work in Spoon first. Then...

    Usual answer - make it work in Spoon first. Then get it to work in API.
  18. "Group By...

    "Group By", OrderNo, Concatenate strings with , ?
  19. Replies
    2
    Views
    96

    So in theory, you should be doing at most 22M...

    So in theory, you should be doing at most 22M roundtrips to the DB... (Ouch, but can't be helped much)

    Did you turn on the "Enable Cache" in Database Lookup?
    What is the round-trip time from the...
  20. Walk us through it very slowly... (and maybe even...

    Walk us through it very slowly... (and maybe even post your transform - be sure to clean your DB connection information first!)

    What is your incoming stream?
    What are you trying to accomplish...
  21. Replies
    4
    Views
    210

    I find that ${Internal.Transformation.Name} is...

    I find that ${Internal.Transformation.Name} is not set at the Job level (others claim to see differently). However, ${Internal.Job.Name} is. That however will not help you, since you want the log...
  22. Your generate rows step is generating 10 rows,...

    Your generate rows step is generating 10 rows, not 1.
    So your Execute All Stored Procedures step is being called 10 times, so each of the SP that it calls will be called 10 times...

    So, if that...
  23. Have a look at the Group By...

    Have a look at the Group By steps.
    One of the grouping options is "Concatenate strings separated by , (comma)"
  24. Replies
    16
    Views
    389

    Yes, I used to do it with 3.6 regularly.

    Yes, I used to do it with 3.6 regularly.
  25. Replies
    16
    Views
    389

    Try 3.8 and see if it plays nicer

    Try 3.8 and see if it plays nicer
  26. Replies
    16
    Views
    389

    I'm trying to remember what version you need for...

    I'm trying to remember what version you need for BIServer 4.8.
    The thing is you reported using PSW 5.3 - How are you doing that when the latest you can find is 3.8?

    You don't want to be on trunk...
  27. Replies
    16
    Views
    389

    The only other suggestion I would have is Use PSW...

    The only other suggestion I would have is Use PSW 4.8 if you are going to use BIServer 4.8 ... Generally, you want to keep your tools at the same version.
  28. Nope -it's more of a DBA level thing... ...

    Nope -it's more of a DBA level thing...

    Basically your Database Administrator creates a view that merges the appropriate rows where Date_Key and Campus_Key are the same, which would then have all...
  29. Short answer: Yes, it can be done. Have a quick...

    Short answer: Yes, it can be done.
    Have a quick look through: http://mondrian.pentaho.com/documentation/schema.php#Virtual_cubes

    If your fact tables are in the same database, then it may be...
  30. Replies
    3
    Views
    145

    Ok. So short version: Dimension - Part that you...

    Ok. So short version:
    Dimension - Part that you want to break the data by.
    Hierarchy - A pathway down through the dimension.
    Level - A group of the part above (you can have multiple levels)
    ...
  31. Replies
    3
    Views
    145

    I would have thought that Campus would be a...

    I would have thought that Campus would be a dimension of its own, not a level of dimension GL_Default

    Since you can have the same Campus within different Account Category values, this is why you...
  32. Replies
    16
    Views
    389

    With Pentaho-BI-Server versions below 5, you have...

    With Pentaho-BI-Server versions below 5, you have to set the publish password, and the account has to have admin level permissions.

    This is documented at...
  33. Replies
    4
    Views
    178

    Not if the actual use-case requires something to...

    Not if the actual use-case requires something to be completed in Job 1 before Job 2 happens.

    Usually, "Get Rows from Result" consumes those rows, so that the next job can't also "Get Rows from...
  34. It's not intuitive, but calculator has the...

    It's not intuitive, but calculator has the Calculation: "First letter of each word of a string A in capital"

    More intuitive, but still not obvious: String operations: Lower/Upper: Lower, InitCap: Y
  35. Replies
    8
    Views
    148

    Generally, I've found Linux ETL to be faster, but...

    Generally, I've found Linux ETL to be faster, but again, without a complete picture, we're all shooting in the dark here.
  36. Replies
    8
    Views
    148

    So, if your transform has the file paths directly...

    So, if your transform has the file paths directly written in them (can't say for sure without the KJB/KTR), then it's possible that your server is trying to pull the data from your workstation. That...
  37. Replies
    8
    Views
    148

    "call the job remotely" Care to expand on that a...

    "call the job remotely"
    Care to expand on that a little?

    Are you copying the KJB/KTR to the remote linux box and running it via SSH and command line?
    Are you using carte and telling spoon to run...
  38. Do you mean like: http://www.ibridge.be/?p=199

    Do you mean like:
    http://www.ibridge.be/?p=199
  39. Replies
    3
    Views
    186

    Please DO NOT do this. Use the correct Oracle...

    Please DO NOT do this. Use the correct Oracle JDBC driver, as marabu previously recommended.
  40. That's not what I've experienced.

    That's not what I've experienced.
  41. As long as there is a Key defined in the...

    As long as there is a Key defined in the database, then the DB Engine will not allow the insert (duplicate key error, or Unique Index Constraint violation). This can then be caught with error...
  42. Replies
    4
    Views
    224

    So you want to transform some data, and then send...

    So you want to transform some data, and then send ONE email. That sounds like a set of requirements for a Job, not a transformation.


    Because the use-cases between the job step and a...
  43. So... RepositoriesMeta.writeData() is for...

    So... RepositoriesMeta.writeData() is for writing the metadata about a stream within a transformation or job to an existing Repository, rather than writing about a repository.

    kettle-servlets.xml...
  44. Why not use the Calculator step which has a built...

    Why not use the Calculator step which has a built in "Date A - Date B (seconds)" calculation?
    You can then use the Group By step to Sum across the values in a group.
  45. Did you read the documentation you linked to? ...

    Did you read the documentation you linked to?



    Keys to match

    Specify fields containing the keys on which to match
  46. Are you saying that you want to capture the rows...

    Are you saying that you want to capture the rows that you can't do a Table Output on because they already exist?
    Then why not use a Table Output, with Error Handling defined to capture those rows?
  47. Well, How about I help you answer your own...

    Well, How about I help you answer your own question...

    Given 1411154919 , what is the data type? Note: That could be a date, an integer, a string, a floating point, a binary, or a timestamp.
    ...
  48. Well, somewhat neither. You should declare a...

    Well, somewhat neither.
    You should declare a calculated measure when you're building your schema. See: http://mondrian.pentaho.com/documentation/schema.php for reference

    When you create your MDX...
  49. You would need to config JBoss to provide the...

    You would need to config JBoss to provide the JNDI to the PDI Instance.
    See: http://docs.jboss.org/jbossweb/3.0.x/jndi-resources-howto.html for reference.

    When JBoss is providing the JNDI...
  50. Replies
    13
    Views
    304

    Simply use the format string in your CSV Input....

    Simply use the format string in your CSV Input.
    The other ways are simply not as efficient.

    The string "yyyy/MM/dd" cannot be used to parse "20140923" because there are no /'s in it. you would...
Results 1 to 50 of 2633
Page 1 of 53 1 2 3 4